Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group