Postgres Pro
Downloads
Home   >   mailing lists

Re: How to deal with NULL values on dynamic queries? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to deal with NULL values on dynamic queries?
Date
Msg-id 2396.1273207639@sss.pgh.pa.us
Whole thread Raw
In response to How to deal with NULL values on dynamic queries?  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view 
Andre Lopes <lopes80andre@gmail.com> writes:
> I have a query that some values could be NULL, how can I deal with this
> problem?

PG 8.4 and up have a function quote_nullable() that would do what I
think you're looking for.  On an older version, you could define such a
function for yourself.

            regards, tom lane

pgsql-general by date:

Previous
From: Lew
Date:
Subject: Re: Notification of Limited Account Access
Next
From: Ivan Sergio Borgonovo
Date:
Subject: unable to avoid a deadlock at the end of a long transaction