| From: | "Matt L(dot)" <survivedsushi(at)yahoo(dot)com> | 
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org | 
| Subject: | nullif('','') on insert | 
| Date: | 2005-08-21 01:40:23 | 
| Message-ID: | 20050821014023.92296.qmail@web35209.mail.mud.yahoo.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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 
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt L. | 2005-08-21 02:25:57 | booleans and nulls | 
| Previous Message | Bernard Henry Voynet | 2005-08-20 19:27:15 | Unwanted nested dollar-quoted constants |