RE: [HACKERS] Associative Operators? (Was: Re: [NOVICE] Out of f rying pan, into fire) - Mailing list pgsql-hackers

From Michael Davis
Subject RE: [HACKERS] Associative Operators? (Was: Re: [NOVICE] Out of f rying pan, into fire)
Date
Msg-id 93C04F1F5173D211A27900105AA8FCFC1452A6@lambic.prevuenet.com
Whole thread Raw
List pgsql-hackers
I have not been able to track down any information on coalesce nor get
PostgreSQL execute it.  Where is this documented?
-----Original Message-----From:    Zeugswetter Andreas IZ5
[SMTP:Andreas.Zeugswetter@telecom.at]Sent:    Wednesday, March 17, 1999 1:29 AMTo:    hackers@postgreSQL.orgSubject:
Re:[HACKERS] Associative Operators?  (Was: Re:
 
[NOVICE] Out of f rying  pan, into fire)
>  > >> I tried to create a C function to overcome this but noticed
that if any> >> parameter in my C function is NULL then the C function always
returns> NULL.> >> I saw some references in the archives about this issue but was
unable> to> >> determine where it was left.  What is the status of this issue?> Yes, this is current behavior.
    > Would a compromise be to add DECODE and NVL ?
The Standard has the more flexible function COALESCE, which is
alreadyimplemented in postgresql.Simply say
coalesce(field_that_can_be_null,value_to_return_insteadof_null)
Andreas 


pgsql-hackers by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [HACKERS] Re: Developers Globe (FINAL)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] aggregation memory leak and fix