From: | Chris Thompson <thompson(at)ednet(dot)co(dot)uk> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | limiting a select |
Date: | 2002-07-04 17:35:33 |
Message-ID: | Pine.LNX.4.33L2.0207041822480.26441-100000@boyce.ednet.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I am using the following query
$query = "SELECT id, title, type, SUBSTRING(description FOR $description_size) as description, ";
$query .= "date, display_date ";
$query .= "FROM events WHERE active='t' ";
$query .= "ORDER BY date ASC;";
I was wondering if someone could give me a hint on how to alter this to
only return 9 results, of which there will, if available, be up to 3 of
each 'type' of event.
There are 3 possible values for the type column (text) in the db.
Any pointers appreciated,
Chris
--
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. Any
offers or quotation of service are subject to formal specification.
Errors and omissions excepted. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of edNET or lightershade ltd. Finally, the
recipient should check this email and any attachments for the presence of
viruses. edNET and lightershade ltd accepts no liability for any damage
caused by any virus transmitted by this email.
--
--
Virus scanned by edNET.
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Friedman | 2002-07-04 19:24:21 | user-defined functions/triggers; cannot dump |
Previous Message | Tom Lane | 2002-07-04 17:12:24 | Re: KEYEXISTS function |