From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Ryszard Kurek" <rychu(at)sky(dot)pl> |
Cc: | <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | RE: [INTERFACES] Table viewer for big sorted tables |
Date: | 1999-10-18 08:29:33 |
Message-ID: | 000d01bf1942$e7d20560$2801007e@cadzone.tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> -----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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 1999-10-18 08:39:35 | RE: [INTERFACES] ODBC: 'Insufficient base table information for u pdating or refreshing' error with ADO |
Previous Message | Christian Wessely | 1999-10-18 06:33:57 | subscribe |