Re: Is This A Set Based Solution?

From: George Weaver <gweaver(at)shaw(dot)ca>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is This A Set Based Solution?
Date: 2007-03-15 14:47:27
Message-ID: 008001c76710$da487db0$6400a8c0@Dell4500
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Stefan Berglund wrote:

> foo WHERE (ID = 53016 OR ID = 27 OR ID = 292 OR ID = 512) or I could
> alternatively pass the string of IDs ('53016,27,292,512') to a table
> returning function which TABLE is then JOINed with the table I wish to

Stefan,

The user selections will be in some sort of list. Could you not use WHERE
ID IN (the list)?

Regards,
George

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2007-03-15 15:00:18 Re: Automating access grants
Previous Message John D. Burger 2007-03-15 14:46:07 Re: Native type for storing fractions (e.g 1/3)?