X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1E6C39FA4D8 for ; Thu, 8 Jun 2006 18:40:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 31874-09 for ; Thu, 8 Jun 2006 18:40:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web37907.mail.mud.yahoo.com (web37907.mail.mud.yahoo.com [209.191.124.102]) by postgresql.org (Postfix) with SMTP id D81F99F9316 for ; Thu, 8 Jun 2006 18:40:13 -0300 (ADT) Received: (qmail 96520 invoked by uid 60001); 8 Jun 2006 21:40:12 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=CD8+ynCa9xC2VD1xalZd4+dI0RsnmGHlTRGV3Ytue8FOlP/D78Z6LVn/myQBOBUsSJZg2C1M3ypoJ/4OjihLRr3+fH0FZles9Hpy5Tt4krk2Vg8KsfUAGVI56mUDFLynTGa6xm2+2sM4r0yHjb0r6tXRCcswGycY00ZCxnpb0S0= ; Message-ID: <20060608214012.96518.qmail@web37907.mail.mud.yahoo.com> Received: from [216.173.173.66] by web37907.mail.mud.yahoo.com via HTTP; Thu, 08 Jun 2006 14:40:12 PDT Date: Thu, 8 Jun 2006 14:40:12 -0700 (PDT) From: CG Reply-To: cgg007@yahoo.com Subject: empty set To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/103 X-Sequence-Number: 25339 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? CG __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com