Hi Tom,
(B
(B> You didn't say what PG version you are using, but I'd venture to bet
(B> it is pre-7.4.
(B
(BSorry I didn't give the version number, here is the output from select
(Bversion():
(B
(BPostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC 2.95.3
(B
(BThis is the first time that
"[EMAIL PROTECTED] (Tom Lane)" wrote in comp.databases.postgresql.sql:
> "Iain" <[EMAIL PROTECTED]> writes:
>
>> I found this interesting and thought I'd offer it up for comment.
>
> You didn't say what PG version you are using, but I'd venture to bet
> it is pre-7.4.
This must've been
"Iain" <[EMAIL PROTECTED]> writes:
> I found this interesting and thought I'd offer it up for comment.
You didn't say what PG version you are using, but I'd venture to bet
it is pre-7.4.
regards, tom lane
---(end of broadcast)--
(B
(B
(BHi All,
(B
(BI found this interesting and thought I'd
(Boffer it up for comment.
(B
(BI have the following delete:
(B
(Bdelete from tableB where id not in (select
(Bid from tableA);
(B
(BThere are about 100,000 rows in table A,
(Band about 500,000 in table B. id is ind
