Simple way to get missing number - Mailing list pgsql-sql

From Emi Lu
Subject Simple way to get missing number
Date
Msg-id 4F96B57E.8080306@encs.concordia.ca
Whole thread Raw
Responses Re: Simple way to get missing number  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Simple way to get missing number  (Steve Crawford <scrawford@pinpointresearch.com>)
List 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


pgsql-sql by date:

Previous
From: Jasen Betts
Date:
Subject: Re: getting the OS user name
Next
From: Andreas Kretschmer
Date:
Subject: Re: Simple way to get missing number