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;
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@sky.pl * sms: 501128171@sms.centertel.pl * www.fnet.pl/rychu