From: | Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com> |
---|---|
To: | missive(at)hotmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: newbie question for return date |
Date: | 2002-10-29 01:12:42 |
Message-ID: | 3DBDE08A.9030009@intransa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hey a suggestion, what if PG would support the negative limit as in
select * from table limit -1 to mean limit it from the other end of
list.....
Sort of like some languages where they support
array[1] vs array[-1].
I'm not sure, but it looks like order by will sort the list which is
expensive and then
allow us to get the first chunk specified by limit.
Lee Harr wrote:
>In article <xEgv9(dot)2668$h_4(dot)374526(at)news20(dot)bellglobal(dot)com>, tviardot wrote:
>
>
>>Hi guys, here a newbies question.
>>I've made a table with some action and date.
>>How may i query the most recent date. (I'd like to return only the record
>>which have the most recent date ).
>>Tx
>>
>>
>>
>>
>
>How about:
>
>SELECT * FROM t ORDER BY d DESC LIMIT 1;
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hadley Willan | 2002-10-29 01:31:06 | User functions not displayed by \df |
Previous Message | Lee Harr | 2002-10-29 00:52:19 | Re: newbie question for return date |