From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
---|---|
To: | Emi Lu <emilu(at)encs(dot)concordia(dot)ca> |
Cc: | pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Simple way to get missing number |
Date: | 2012-04-24 14:31:39 |
Message-ID: | 20120424143139.GA7555@depesz.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
On Tue, Apr 24, 2012 at 10:15:26AM -0400, Emi Lu wrote:
> 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 ;
select generate_series( (select min(id) from t1), (select max(id) from
t1))
except
select id from t1;
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2012-04-24 14:36:55 | Re: Simple way to get missing number |
Previous Message | Emi Lu | 2012-04-24 14:15:26 | Simple way to get missing number |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2012-04-24 14:36:55 | Re: Simple way to get missing number |
Previous Message | Emi Lu | 2012-04-24 14:15:26 | Simple way to get missing number |