Re: [GENERAL] the last row in a table

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
>
>
>
>

Browse pgsql-general by date

  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

Browse pgsql-interfaces by date

  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