Skip site navigation (1) Skip section navigation (2)

Re: Matching several rows

From: Vraj Mohan <vrajmohan(at)comcast(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Matching several rows
Date: 2006-01-18 16:35:39
Message-ID: dqlqos$tj0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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?
> Ivan

In response to

pgsql-sql by date

Next:From: Christian Paul B. CosinasDate: 2006-01-18 21:33:09
Subject: Re: Characters that needs escape characters when inserting to database
Previous:From: JeffDate: 2006-01-18 15:41:42
Subject: Re: bug with if ... then ... clause in views

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group