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

problems selecting multiple records (again!)

From: "Giorgio A(dot)" <jh(at)libero(dot)it>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: problems selecting multiple records (again!)
Date: 2001-05-30 19:57:45
Message-ID: 002e01c0e942$cc54d980$2f50fea9@pollicino (view raw or flat)
Thread:
Lists: pgsql-novice
hi everyone,
i already wrote to this list for the same problem.... i thought i had
resolved it, but i was wrong !
i'll explain my problem in a different (and simplier to understand) way:

suppose you have a table representing some events like this:

id  |  ref  |  date
-----------------------
1  |  10  |  2001-05-10
2  |  10  |  2001-05-11
3  |  10  |  2001-05-12
4  |  20  |  2001-05-11
5  |  20  |  2001-05-13
6  |  30  |  2001-05-15

the "ref" field is used to match this table with an another table containing
the description of the event in that date.
So, in this example I have the same event (identified as '10') which is
repeated 3 times, another event ('20') repeated twice, and an event with a
single occurance ('30').
now suppose that today is 2001-05-09 and i want to publish on my web-site
the next 3 events:

doing a simple SELECT i will get :

1  |  10  | 2001-05-10
2  |  10  |  2001-05-11
4  |  20  |  2001-05-11

but what i really wanted was :

1  |  10  | 2001-05-10
4  |  20  |  2001-05-11
6  |  30  |  2001-05-15

i.e., i don't want to get more than one occurance of the same "ref".

plz help me since i'm getting crazy trying to solve this problem !!!
keep in mind that i'll have a table with hundreds of event, so the faster
way to get the result is the preferred :-)

the web publishing system is based on zope.

tnx for your help

Giorgio A.




Responses

pgsql-novice by date

Next:From: Nabil SayeghDate: 2001-05-30 20:57:11
Subject: Re: problems selecting multiple records (again!)
Previous:From: Tim BarnardDate: 2001-05-30 17:30:48
Subject: Re: Things are terribly quiet

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