RE: [INTERFACES] Table viewer for big sorted tables - Mailing list pgsql-interfaces

> -----Original Message-----
> From: owner-pgsql-interfaces@postgreSQL.org
> [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Ryszard Kurek
> Sent: Sunday, October 17, 1999 6:40 PM
> To: pgsql-interfaces@postgreSQL.org
> Subject: [INTERFACES] Table viewer for big sorted tables
> 
> 
> On Sat, Oct 16, 1999 at 04:20:30PM -0400, Tom Lane wrote:
> > Ryszard Kurek <rychu@sky.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;
> 
> after some tests....
> 
> above statement works great, but this no :
>  SELECT ... FROM products WHERE product_name < 'current_product' 
>  ORDER BY product_name DESC LIMIT 1;
> :(
>

This would also work in 7.0.
You could try it in the current snapshot.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp