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,''999'')::integer;'
la
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
--
Mark Leslie wrote:
> "Previously, if a non-character value was supplied to an operator or
> function that requires text input, it was automatically cast to text,
> for most (though not all) built-in data types. This no longer happens:
> an explicit cast to text is now required for all non-character
2008/5/28 Wouter Schaubroeck <[EMAIL PROTECTED]>:
>
> Hey all,
>
> I've upgrade my postgresql version to 8.3.1 (from 8.2.x), and loaded
> it with the EPGS data, for using in geotools. While this used to work
> with version 8.2, this doesn't with the new version. This is the error
> i receive:
>
> C
Hey all,
I've upgrade my postgresql version to 8.3.1 (from 8.2.x), and loaded
it with the EPGS data, for using in geotools. While this used to work
with version 8.2, this doesn't with the new version. This is the error
i receive:
Caused by: org.postgresql.util.PSQLException: ERROR: operator does
