From: | Fomichev Michael <fomichev(at)null(dot)ru> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org, Vikrant Rathore <vikrant(at)chemquick(dot)com> |
Subject: | Re: [SQL] Mail about duplicate rows |
Date: | 1999-06-07 05:11:35 |
Message-ID: | Pine.LNX.4.04.9906071801290.3228-100000@ns.region.utsr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces pgsql-sql |
On Mon, 7 Jun 1999, Vikrant Rathore wrote:
> I am trying to append a table radius from another table radiustemp, both
> having the same structure, but want to append only those tuples from
> radiustemp which are not there in radius. The size of the table can be
> up to 165 MB.
> So anyone can suggest me a better way of doing this.
>
> The structure if table is like this .
>
> Table = radius
> +----------------------------------+----------------------------------+-------+
>
> | Field | Type |
> Length|
> +----------------------------------+----------------------------------+-------+
>
> | uname | char()
> | 256 |
> | logdate | date
> | 4 |
> | logtime | time
> | 8 |
> | duration | int4
> | 4 |
> | status | char()
> | 20 |
> | nasadd | char()
> | 20 |
> | port | int4
> | 4 |
> | bytesin | int4
> | 4 |
> | bytesout | int4
> | 4 |
> | packin | int4
> | 4 |
> | packout | int4
> | 4 |
> | misc | int4
> | 4 |
> +----------------------------------+----------------------------------+-------+
>
> Thank's in advance for your help.
>
> Thanks & regards,
> Vicky
>
insert into RADIUS select * from RADIUSTEMP where UNAME not in (select
UNAME from RADIUS)
UNAME must be unique. If it is not, than you need to use another field
(for example "code") which will be unique.
P.S. Nice book about SQL: "Understanding SQL" by Martin Gruber. ISBN
5-85582-010-6
@------------------+-----------------------------------------------@
| Fomichev Mikhail | The Government of Kamchatka region. |
| Vladimirovich | The Labour and Social Development Department. |
|<fomichev(at)null(dot)ru>| |
@------------------+-----------------------------------------------@
From | Date | Subject | |
---|---|---|---|
Next Message | Vikrant Rathore | 1999-06-07 05:37:12 | Re: [SQL] Mail about duplicate rows |
Previous Message | Peter Harvey | 1999-06-07 02:53:53 | ANNOUNCE: unixODBC Beta 1.0.5 |
From | Date | Subject | |
---|---|---|---|
Next Message | Vikrant Rathore | 1999-06-07 05:37:12 | Re: [SQL] Mail about duplicate rows |
Previous Message | Vikrant Rathore | 1999-06-07 02:33:42 | Mail about duplicate rows |