Re: [INTERFACES] Table viewer for big sorted tables

From: Ryszard Kurek <rychu(at)sky(dot)pl>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [INTERFACES] Table viewer for big sorted tables
Date: 1999-10-16 21:02:50
Message-ID: 19991016230250.B4742@fnet.pl
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Sat, Oct 16, 1999 at 04:20:30PM -0400, Tom Lane wrote:
> Ryszard Kurek <rychu(at)sky(dot)pl> 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(at)sky(dot)pl * sms: 501128171(at)sms(dot)centertel(dot)pl * www.fnet.pl/rychu

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Ryszard Kurek 1999-10-17 09:39:56 [INTERFACES] Table viewer for big sorted tables
Previous Message Tom Lane 1999-10-16 20:20:30 Re: [INTERFACES] Table viewer for big sorted tables