Received: from srvlnx02.pup.ch ([195.134.149.6]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6AD70a71055 for ; Tue, 10 Jul 2001 09:07:00 -0400 (EDT) (envelope-from juerg.rietmann@pup.ch) Subject: select only the first record To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0.5 September 22, 2000 Message-ID: From: juerg.rietmann@pup.ch Date: Tue, 10 Jul 2001 15:09:18 +0200 X-MIMETrack: Serialize by Router on srvlnx02/Pup/ch(Release 5.0.5 |September 22, 2000) at 07/10/2001 03:09:20 PM MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Archive-Number: 200107/102 X-Sequence-Number: 3886 Hello there Is it possible to do a query and selecting only the first record in ad table ? e.g. select FIRST * from cars Tx in advance ... jr ============================================ PFISTER + PARTNER, SYSTEM - ENGINEERING AG Juerg Rietmann Grundstrasse 22a 6343 Rotkreuz Switzerland phone: +4141 790 4040 fax: +4141 790 2545 mobile: +4179 211 0315 ============================================