Re: Simple way to get missing number

On Tuesday 24 Apr 2012, Andreas Kretschmer wrote:
> Emi Lu <emilu(at)encs(dot)concordia(dot)ca> wrote:
> > 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 ;
>
> something like
>
> ,----[ code ]
>
> | test=# select * from emi_lu ;
> |
> | i
> |
> | ---
> |
> | 1
> | 2
> | 3
> | 5
> | 6
> | 8
> | 9
> |
> | (7 rows)
> |
> | Time: 0,246 ms
> | test=*# select * from generate_Series(1,10) s left join emi_lu on
> | (s=emi_lu.i) where i is null;
> |
> | s | i
> |
> | ----+---
> |
> | 4 |
> | 7 |
> |
> | 10 |
> |
> | (3 rows)

Nice one, but curious about how would this perform if the numbers in
question extended into 7 figures or more?

Regards,

-- Raj
--
Raj Mathur || raju(at)kandalaya(dot)org || GPG:
http://otheronepercent.blogspot.com || http://kandalaya.org || CC68
It is the mind that moves || http://schizoid.in || D17F