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

Re: problem selecting multiple records (again!)

From: Nabil Sayegh <nsmail(at)sayegh(dot)de>
To: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
Cc: Giorgio Andreoletti - mentelocale <giorgio(dot)andreoletti(at)mentelocale(dot)it>, pgsql-novice(at)postgresql(dot)org
Subject: Re: problem selecting multiple records (again!)
Date: 2001-06-05 23:48:15
Message-ID: 991784895.8441.2.camel@billy.labor.localnet (view raw or flat)
Thread:
Lists: pgsql-novice
On 05 Jun 2001 17:01:14 -0500, Manuel Sugawara wrote:
> 
> something like
> 
> select * from events where ref in (select distinct ref from events limit 3);
> 
> will do what you want.

Not exactly, he wanted the NEXT 3 events.

[...]
> > now suppose that today is 2001-05-09 and i want to publish on my web-site
> > the next 3 events:
[...]

--
 Nabil Sayegh



In response to

Responses

pgsql-novice by date

Next:From: Manuel SugawaraDate: 2001-06-06 00:40:01
Subject: Re: problem selecting multiple records (again!)
Previous:From: Manuel SugawaraDate: 2001-06-05 22:01:14
Subject: Re: problem selecting multiple records (again!)

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