Received: from zulus.sky.pl (gw.zulus.sky.pl [212.160.70.12]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA45461 for ; Sat, 16 Oct 1999 18:24:27 -0400 (EDT) (envelope-from rychu@sky.pl) Received: from poldas.sky.pl (pb140.szczecin.ppp.tpnet.pl [212.160.42.140]) by zulus.sky.pl (Postfix) with ESMTP id CCEE72DD29; Sun, 17 Oct 1999 00:25:32 +0200 (CEST) Received: by poldas.sky.pl (Postfix, from userid 1000) id 9818312BACA; Sat, 16 Oct 1999 23:02:50 +0200 (CEST) Date: Sat, 16 Oct 1999 23:02:50 +0200 From: Ryszard Kurek To: Tom Lane Cc: pgsql-interfaces@postgresql.org Subject: Re: [INTERFACES] Table viewer for big sorted tables Message-ID: <19991016230250.B4742@fnet.pl> References: <19991016210215.A4354@fnet.pl> <9459.940105230@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0pre2i In-Reply-To: <9459.940105230@sss.pgh.pa.us> On Sat, Oct 16, 1999 at 04:20:30PM -0400, Tom Lane wrote: > Ryszard Kurek writes: > > The slow version is: > > SELECT min(product_symbol) FROM products WHERE product_name > 'current_product'; > > Try > > SELECT ... FROM products WHERE product_name > 'current_product' ORDER BY product_name LIMIT 1; I've tried several combination but not this particual one... IT WORKing now !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!1 thank you very much, you saved my life :) -- pozdrowienia, Ryszard Kurek UIN: 1741033 mailto:rychu@sky.pl * sms: 501128171@sms.centertel.pl * www.fnet.pl/rychu