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