Is there a reason you cannot do an if/else statement on the list size? That is what I do on my queries.
-Aaron
On 6/8/06, Scott Marlowe <[EMAIL PROTECTED]> wrote:
On Thu, 2006-06-08 at 16:40, CG wrote:
> PostgreSQL 8.1
>
> I've been trying to write a SQL prepare routine. One of the challenging
> elements I'm running into is an empty set ...
>
> "select foo from bar where foo in ? ;"
>
> What if "?" is an set with zero elements? What is the proper value to use to
> replace "?" indicating an empty set?
NULL?
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
