| From: | "Lada 'Ray' Lostak" <ray(at)unreal64(dot)net> |
|---|---|
| To: | "Alex" <alex(at)meerkatsoft(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SELECT Question |
| Date: | 2003-11-20 07:32:58 |
| Message-ID: | 00a401c3af38$8564a1e0$0d01a8c0@utopia |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
> Is there an easy way to write a select statement that returns me the
> frist free number or any within the range of 200?
> For example if 1-30, and 32-50 are occupied then i would like to fill in
> the new entry with id 31.
> I currently do it with a function but I was just wondering if there is a
> way without it..
If I understand well, what something about
SELECT min(xxx) FROM table WHERE xxx<50
Best regards,
Lada 'Ray' Lostak
Unreal64 Develop group
http://www.orcave.com
http://www.unreal64.net
--------------------------------------------------------------------------
In the 1960s you needed the power of two C64s to get a rocket
to the moon. Now you need a machine which is a vast number
of times more powerful just to run the most popular GUI.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stef | 2003-11-20 07:36:05 | Re: Point-in-time data recovery - v.7.4 |
| Previous Message | Stef | 2003-11-20 07:29:41 | Re: Point-in-time data recovery - v.7.4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex | 2003-11-20 07:39:56 | Re: SELECT Question |
| Previous Message | Alex | 2003-11-20 07:22:14 | SELECT Question |