From: | "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> |
---|---|
To: | "Gavin 'Beau' Baumanis" <gavinb(at)eclinic(dot)com(dot)au> |
Cc: | pgsql-sql(at)postgresql(dot)org, "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Subject: | Re: Select into |
Date: | 2008-03-20 10:58:07 |
Message-ID: | 65937bea0803200358i290bdc87hdeca777b593b5df1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Thu, Mar 20, 2008 at 4:19 PM, A. Kretschmer <
andreas(dot)kretschmer(at)schollglas(dot)com> wrote:
> am Thu, dem 20.03.2008, um 20:57:53 +1100 mailte Gavin 'Beau' Baumanis
> folgendes:
> > Hi Everyone,
> >
> > I have asked our DBA at work and h is not too sure either... so I
> > thought it best to on the list.
> >
> > Basically, what I am after is a way to copy the contents of one record
> > into another.
> > Something like select into; but where the destination record already
> > exists, as opposed to creating a new record.
>
> insert into <table> select from <table> where ...
>
>
He specifically asked for
<snip>
where the destination record already
exists, as opposed to creating a new record.
</snip>
I think an UPDATE with joins would be helpful. Though, it may become
lengthy if the tables have too many columns.
Can you post your exact requirement?
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad *
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco
Mail sent from my BlackLaptop device
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin 'Beau' Baumanis | 2008-03-20 11:09:49 | Re: Select into |
Previous Message | A. Kretschmer | 2008-03-20 10:49:22 | Re: Select into |