This should work:
select cast('123' as int), cast(123 as text);
José
JT Kirkpatrick ha scritto:
> I'm trying to do an update query that compares an int4 field to a variable
> which I think contains a string (it was passed in through cgi.pm). can I
> convert that string to an integer? - it will always be a number passing
> through. I vaguely remember oracle having a to_number function - does
> postgres have something similar?
>
> jt