Postgres Pro
Downloads
Home   >   mailing lists

Thread: Cast

Cast

From
"Renato Gondim"
Date:
This select doesn't work:



Select cast('' as int)

Re: Cast

From
Michael Fuhr
Date:
On Fri, Jul 08, 2005 at 01:33:13PM -0300, Renato Gondim wrote:
> This select doesn't work:
>
> Select cast('' as int)

Any empty string isn't a valid integer, so PostgreSQL 7.3 and later
reject it.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/