From: | "K(dot)T(dot)" <kanet(at)calmarconsulting(dot)com> |
---|---|
To: | <hoelc(at)pd(dot)jaring(dot)my>, <pgsql-interfaces(at)postgreSQL(dot)org> |
Cc: | <pgsql-admin(at)postgreSQL(dot)org>, <pgsql-general(at)hub(dot)org> |
Subject: | Re: [GENERAL] the last row in a table |
Date: | 1999-03-09 14:23:35 |
Message-ID: | 000901be6a38$6e0840a0$38dba5ce@p2-400-death |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-interfaces |
How about...
select field1 where primary_key = select max(primary_key) from table;
or something like that :) I always mess up the parenthesis...cant remember
whether or not they are needed here around the second select.
-----Original Message-----
From: hoelc <hoelc(at)pd(dot)jaring(dot)my>
To: pgsql-interfaces(at)postgreSQL(dot)org <pgsql-interfaces(at)postgreSQL(dot)org>
Cc: pgsql-admin(at)postgreSQL(dot)org <pgsql-admin(at)postgreSQL(dot)org>;
pgsql-general(at)hub(dot)org <pgsql-general(at)hub(dot)org>
Date: Tuesday, March 09, 1999 7:03 AM
Subject: [GENERAL] the last row in a table
>Hello,
>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?
>Thank you.
>Regards,
>lch
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sze Yuen Wong | 1999-03-09 14:54:46 | Calcuate percentage. |
Previous Message | hoelc | 1999-03-09 12:08:43 | the last row in a table |
From | Date | Subject | |
---|---|---|---|
Next Message | Bartek Teodorczyk | 1999-03-09 14:44:57 | Getting field length in libpq |
Previous Message | The Hermit Hacker | 1999-03-09 14:18:11 | Re: [INTERFACES] PgAccess 0.96 version released |