On 04/24/2012 11:10 AM, Emi Lu wrote:
I got it and thank you very much for everyone's help!!
It seems that "left join where is null" is faster comparing with
"except". And my final query is:
select num as missing
from generate_series(5000, #{max_id}) t(num)
left join t1 on (t.num = t1.id)
I got it and thank you very much for everyone's help!!
It seems that "left join where is null" is faster comparing with
"except". And my final query is:
select num as missing
from generate_series(5000, #{max_id}) t(num)
left join t1 on (t.num = t1.id)
where t1.id is null;
Emi
On 04/24/201
Raj Mathur (राज माथुर) wrote:
>
> Nice one, but curious about how would this perform if the numbers in
> question extended into 7 figures or more?
TIAS
(Try It And See)
Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.
On 04/24/2012 07:15 AM, Emi Lu 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 500
select miss_num(id)
from t1 ;
Will return:
===
37, 800, 8001
T
select generate
On Tuesday 24 Apr 2012, Andreas Kretschmer wrote:
> Emi Lu 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 500
> >
> > select miss_num(id)
> >
Emi Lu 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 500
>
> select miss_num(id)
> from t1 ;
something like
,[ code ]
| test=# select * from emi_lu ;
|
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 500
select miss_num(id)
from t1 ;
Will return:
===
37, 800, 8001
Thanks a lot!
Emi
--
Sent via pgsql-sql mailing list (pg
