From: Vikrant Rathore <vikrant@chemquick.com>
To: Fomichev Michael <fomichev@null.ru>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Mail about duplicate rows
Date: Mon, 07 Jun 1999 13:37:12 +0800
Message-ID: <375B5A88.61C7B37A@chemquick.com> (raw)
References: <Pine.LNX.4.04.9906071801290.3228-100000@ns.region.utsr>
Thanks for your help. But as you know the UNAME is not unique in radius logs. The
primary key for this table is (Uname,logdate,logtime).
So this three fields together forms a primary key of the table.
Thanks & regards,
Vicky
Fomichev Michael wrote:
> 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@null.ru>| |
> @------------------+-----------------------------------------------@
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: vikrant@chemquick.com, fomichev@null.ru, pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Mail about duplicate rows
In-Reply-To: <375B5A88.61C7B37A@chemquick.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox