Simple way to get missing number

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

Responses

Browse pgsql-general by date

  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?

Browse pgsql-sql by date

  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