From: | Oleg Broytmann <phd(at)sun(dot)med(dot)ru> |
---|---|
To: | hoelc <hoelc(at)pd(dot)jaring(dot)my> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: [GENERAL] the last row in a table |
Date: | 1999-03-10 08:42:06 |
Message-ID: | Pine.SOL2.3.96.SK.990310114052.6083H-100000@sun.med.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
Hi!
On Tue, 9 Mar 1999, hoelc wrote:
> I am developing a database with PostgreSQL in Linux, and using ecpg to write the
> C program to communicate with the database.
> One of my application need to get the data from the last row in a table.
> Is there any function or command that can tract which is the last row of data in
> a table?
Reorder your query to get the data in the FIRST row and use cursor to fetch
just the row.
> Thank you.
> Regards,
> lch
Oleg.
----
Oleg Broytmann National Research Surgery Centre http://sun.med.ru/~phd/
Programmers don't die, they just GOSUB without RETURN.
From | Date | Subject | |
---|---|---|---|
Next Message | Gilles Darold | 1999-03-10 09:16:35 | Re: [GENERAL] Postgres tutorial examples ! |
Previous Message | Remigiusz Sokolowski | 1999-03-10 07:24:46 | Re: [GENERAL] i want to start automaticly postgres when a reboot my server...help please..... |
From | Date | Subject | |
---|---|---|---|
Next Message | Stuart Rison | 1999-03-10 11:38:39 | Re: [GENERAL] Re: [INTERFACES] the last row in a table |
Previous Message | Hannu Krosing | 1999-03-10 08:00:25 | Re: [INTERFACES] Retrieve rows 1 by 1 |