pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jackson, DeJuan <djackson@cpsgroup.com>
To: vikrant@chemquick.com, Fomichev Michael <fomichev@null.ru>
Cc: pgsql-sql@postgreSQL.org
Subject: RE: [SQL] Mail about duplicate rows
Date: Mon, 7 Jun 1999 16:37:50 -0500
Message-ID: <D05EF808F2DFD211AE4A00105AA1B5D21F24D9@cpsmail> (raw)

Then you would use:
INSERT INTO radius
SELECT * FROM raduistemp r1
WHERE NOT EXISTS(SELECT 1 FROM radius r2
    WHERE r1.uname=r2.uname AND r1.logdate=r2.logdate AND
r1.logtime=r2.logtime);
	-DEJ

> -----Original Message-----
> From:	Vikrant Rathore [SMTP:vikrant@chemquick.com]
> Sent:	Monday, June 07, 1999 12:37 AM
> To:	Fomichev Michael
> Cc:	pgsql-sql@postgreSQL.org
> Subject:	Re: [SQL] Mail about duplicate rows
> 
> 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>|                                               |
> > @------------------+-----------------------------------------------@
> 



view thread (6+ messages)  latest in thread

Message-ID: <D05EF808F2DFD211AE4A00105AA1B5D21F24D9@cpsmail>
Permalink:  ../D05EF808F2DFD211AE4A00105AA1B5D21F24D9@cpsmail/
Also on:    postgresql.org/message-id/D05EF808F2DFD211AE4A00105AA1B5D21F24D9@cpsmail

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: djackson@cpsgroup.com, fomichev@null.ru
  Subject: Re: [SQL] Mail about duplicate rows
  In-Reply-To: <D05EF808F2DFD211AE4A00105AA1B5D21F24D9@cpsmail>
  References: <D05EF808F2DFD211AE4A00105AA1B5D21F24D9@cpsmail>

* 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