Altering built-in functions cast - Mailing list pgsql-general

From Matt A.
Subject Altering built-in functions cast
Date
Msg-id 20050826005530.77061.qmail@web35201.mail.mud.yahoo.com
Whole thread Raw
Responses Re: Altering built-in functions cast  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Anyone know how I could alter the cast of the nullif()
function directly to return INT?

We use NULLIF() for adding [1|0|null] according to the
evalution of nullif('x','') into integer columns.
Where x is an integer and sometimes a empty string,
which if it's an empty string (x='') then we add NULL
cause NULLIF says if '' == '' then return NULL

Thank you,
matthew



__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Postgresql replication
Next
From: Tony Caduto
Date:
Subject: Re: Its Beta Time Again ... 8.1 Beta 1 Now Available