Re: [HACKERS] using a join in an 'INSERT ... SELECT' ...

2000-09-13 Thread Stephan Szabo
On Thu, 14 Sep 2000, The Hermit Hacker wrote: > > Okay, logically I think this makes sense, but its not working ... should > it? > > globalmatch=# insert into auth_info_new > globalmatch-# select ai.* from auth_info ai, auth_info_new ain > globalmatch-# where ai.username != ain.username; > INSE

[HACKERS] using a join in an 'INSERT ... SELECT' ...

2000-09-13 Thread The Hermit Hacker
Okay, logically I think this makes sense, but its not working ... should it? globalmatch=# insert into auth_info_new globalmatch-# select ai.* from auth_info ai, auth_info_new ain globalmatch-# where ai.username != ain.username; INSERT 0 0 auth_info has 14k tuples, but some are duplicates ... I