| 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: | Whole Thread | Raw Message | 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 |