Skip site navigation (1) Skip section navigation (2)

Re: Select into

From: Gavin 'Beau' Baumanis <gavinb(at)eclinic(dot)com(dot)au>
To: "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com>
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 11:09:49
Message-ID: 786D2B38-CE0A-41BF-9E70-4DEB22F8D9EF@eclinic.com.au (view raw or flat)
Thread:
Lists: pgsql-sql
HI Gurjeet,

You're right.

But what information do you need to know?

The copy is inside the same table, so I don't understand why it (the  
required query ) would require any joins.

Ie. I want to copy the contents of a row (but for the id column - of  
course) into a record in the same table.

I am happy enough to give you a table schema, if that's required...  
but I just don't see why it would be needed - but of course am happy  
to be told something new!

Thanks again.

Gavin Baumanis



On 20/03/2008, at 9:58 PM, Gurjeet Singh wrote:

> 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
>
> http://gurjeet.frihost.net
>
> Mail sent from my BlackLaptop device

In response to

Responses

pgsql-sql by date

Next:From: Greg Sabino MullaneDate: 2008-03-20 11:39:12
Subject: Re: Select into
Previous:From: Gurjeet SinghDate: 2008-03-20 10:58:07
Subject: Re: Select into

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group