Received: from gl.aser.de (s217-115-138-162.colo.hosteurope.de [217.115.138.162]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6ADesa84817 for ; Tue, 10 Jul 2001 09:40:54 -0400 (EDT) (envelope-from gcg@gl.aser.de) Received: from pinguin (pec-161-202.tnt9.b2.uunet.de [149.225.161.202]) by gl.aser.de (Postfix) with SMTP id 4138D636D5; Tue, 10 Jul 2001 15:55:06 +0200 (CEST) Content-Type: text/plain; charset="iso-8859-1" From: Christof Glaser Organization: gl.aser software engineering . internet service To: juerg.rietmann@pup.ch, pgsql-sql@postgresql.org Subject: Re: select only the first record Date: Tue, 10 Jul 2001 15:38:55 +0200 X-Mailer: KMail [version 1.2] References: In-Reply-To: MIME-Version: 1.0 Message-Id: <01071015385500.00730@pinguin> Content-Transfer-Encoding: 8bit X-Archive-Number: 200107/104 X-Sequence-Number: 3888 On Tuesday, 10. July 2001 15:09, juerg.rietmann@pup.ch 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 LIMIT 1; Without ORDER BY, there is no "first" record - any record could be returned. Regards, Christof Glaser