Re: empty set

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: cgg007(at)yahoo(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: empty set
Date: 2006-06-08 21:42:22
Message-ID: 1149802941.25526.279.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jim C. Nasby 2006-06-08 23:09:33 Re: pgxml & xpath_table
Previous Message CG 2006-06-08 21:40:12 empty set