nullif('','') on insert
От | Matt L. |
---|---|
Тема | nullif('','') on insert |
Дата | |
Msg-id | 20050821014023.92296.qmail@web35209.mail.mud.yahoo.com обсуждение исходный текст |
Ответы |
Re: nullif('','') on insert
|
Список | pgsql-sql |
I need to test whether or not a value is null on insert. Example: insert into table (column) values nullif('','')); ERROR: column "column" is of type boolean but expression is of type text. It works in MSSQL (probably against not standards) but nonetheless I need to make it work. I assume it's returning 'NULL' w/ quotes? I don't know where to look to alter it. I looked into functions but all I see is how to write "AS queries" or point to various snippets. I'd rather just alter the nullif function. Is there a function for this or could someone give me an example to insert NULL? Cheers Matt __________________________________ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail
В списке pgsql-sql по дате отправления: