From: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, "pgsql-general(at)postgresql(dot)org >> \"pgsql-general(at)postgresql(dot)org\"" <pgsql-general(at)postgresql(dot)org> |
Subject: | Simple way to get missing number |
Date: | 2012-04-24 14:15:26 |
Message-ID: | 4F96B57E.8080306@encs.concordia.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
Good morning,
May I know is there a simple sql command which could return missing
numbers please?
For example,
t1(id integer)
values= 1, 2, 3 .... 5000000
select miss_num(id)
from t1 ;
Will return:
===============
37, 800, 8001
Thanks a lot!
Emi
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2012-04-24 14:31:39 | Re: Simple way to get missing number |
Previous Message | Andrew Dunstan | 2012-04-24 14:10:24 | Re: [HACKERS] Namespace of array of user defined types is confused by the parser in insert? |
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2012-04-24 14:31:39 | Re: Simple way to get missing number |
Previous Message | Jasen Betts | 2012-04-24 09:48:02 | Re: getting the OS user name |