It is easier to think of this as SET INTERSECTION which leads to:
SELECT id FROM urights WHERE right = 2
SELECT id FROM urights WHERE right = 5
SELECT id FROM urights WHERE right = 10
Ivan Steganov wrote:
> Thank you to everyone for the great help!
> I will evaluate all methods in our query (It is actually well complexer then
> this sample) and choose the best one.
> Is there any "scientific" name to this kind of "several rows match for one
> result" data selection?
In response to
pgsql-sql by date
|Next:||From: Christian Paul B. Cosinas||Date: 2006-01-18 21:33:09|
|Subject: Re: Characters that needs escape characters when inserting to database|
|Previous:||From: Jeff||Date: 2006-01-18 15:41:42|
|Subject: Re: bug with if ... then ... clause in views|