Postgres Pro
Downloads
Home   >   mailing lists

Last x records - Mailing list pgsql-general

From Matthias Teege
Subject Last x records
Date
Msg-id 87elwkv1ec.fsf@moon.mteege.de
Whole thread Raw
List pgsql-general
Tree view 
Moin,

is there any way to get the last x records of an query
result?

I can use "... order by x DESC LIMIT n" but I need ASC not
DESC, the last records in the correct order.

Many thanks
Matthias

--
Matthias Teege -- matthias@mteege.de -- http://emugs.de
make world not war
PGP-Key auf Anfrage

pgsql-general by date:

Previous
From: Tulio Oliveira
Date:
Subject: Problems with RAISE EXCEPTION
Next
From: martin.chantler@convergys.com
Date:
Subject: Re: Migrate from MS SQL 6.5 to postgres??