RE: [INTERFACES] Table viewer for big sorted tables

> -----Original Message-----
> From: owner-pgsql-interfaces(at)postgreSQL(dot)org
> [mailto:owner-pgsql-interfaces(at)postgreSQL(dot)org]On Behalf Of Ryszard Kurek
> Sent: Sunday, October 17, 1999 6:40 PM
> To: pgsql-interfaces(at)postgreSQL(dot)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(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;
>
> 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(at)tpf(dot)co(dot)jp