Re: [Geotools-gt2-users] epsg in postgres 8.3.1

[Wouter S. <wou...@gm...>]

Aha!

Workaround works :)

First i created a function to convert the string to an int, and than i
created the actual cast. This are the sql commands i used:

create or replace function convertStringToInteger(character varying)
returns integer
 as 'select to_number($1,''99999999999'')::integer;'
 language sql
 immutable
 returns null on null input;

create cast (character varying as integer) with function
convertStringToInteger(character varying) as implicit;

I have changed DirectEpsgFactory.java, but have not tested it -yet-,
i'll keep you informed!

grtz, w

On Wed, May 28, 2008 at 10:49 AM, Martin Desruisseaux
<mar...@ge...> wrote:
> Hello Wouter
>
> I opened a JIRA task for this issue.
>
> http://jira.codehaus.org/browse/GEOT-1835
>
> In the main time, I would be curious to see if the workaround suggested by
> Mark Leslie (define the cast as implicit) works?
>
>        Martin
>