subject:"\[SQL\] SQL state\: 22P02"

Re: [SQL] SQL state: 22P02

2007-11-22 Thread Rodrigo De León

On Nov 22, 2007 11:24 AM, Franklin Haut <[EMAIL PROTECTED]> wrote: >num return > -- >0 0 >null false >1212 >a false >12ab false > > it´s possible get these results ? Try: SELECT NUM , CASE WHEN TRIM(NUM) ~

[SQL] SQL state: 22P02

2007-11-22 Thread Franklin Haut

Hi, I got the message "SQL state: 22P02" to produce: create table test (num varchar(20)); insert into test (num) values (null); select * from test where cast(num as int8) = 0; --ok, no error insert into test (num) values ('123123'); select * from test where cast(num as int8) = 123123;