Re: Is This A Set Based Solution? - Mailing list pgsql-general

From George Weaver
Subject Re: Is This A Set Based Solution?
Date
Msg-id 008001c76710$da487db0$6400a8c0@Dell4500
Whole thread Raw
In response to Is This A Set Based Solution?  (Stefan Berglund <stefan_berglund@msn.com>)
List 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


pgsql-general by date:

Previous
From: "John D. Burger"
Date:
Subject: Re: Native type for storing fractions (e.g 1/3)?
Next
From: Douglas McNaught
Date:
Subject: Re: Automating access grants