RE: SQL parse error - Mailing list pgsql-sql

Hi Borek,

What version of PostgreSQL are you using? This works fine for me on
7.02. Time to update, maybe?

Hope this helps

Francis

>
>    Hello all,
>
>    My following problem is:
>
> swports=# select substring(cp from 1 for 4)::int4 from out2cp;
> ERROR:  pg_atoi: error in "6.1,": can't parse ".1,"
>
>    SQL syntax is apparently OK. When I omit the typecast, the query
> works:
>
> swports=# select substring(cp from 1 for 4) from out2cp;
>  substr
> --------
>  3182
>  3182
>  3182
> -8<- text deleted ---
>
>    The cp entries are varchars in form NNNN.N, where N is numeral.
>    So can someone explain why the parse error?
>