On Tuesday, 10. July 2001 15:09, [EMAIL PROTECTED] wrote:
> Hello there
>
> Is it possible to do a query and selecting only the first record in
> ad table ?
>
> e.g. select FIRST * from cars
SELECT * FROM cars ORDER BY <your pkey> LIMIT 1;
Without ORDER BY, there is no "first" record - any record could be
returned.
Regards,
Christof Glaser
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
