|
From: Wouter S. <wou...@gm...> - 2008-05-28 21:04:44
|
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 > |