From: Joe <dev@freedomcircle.net>
To: Gurjeet Singh <singh.gurjeet@gmail.com>
Cc: Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: Select into
Date: Thu, 20 Mar 2008 09:38:23 -0400
Message-ID: <47E268CF.3040604@freedomcircle.net> (raw)
In-Reply-To: <65937bea0803200613k4593da12hd62233f8a745309@mail.gmail.com>
References: <94F93C0F-DA95-4435-B253-57C90961DF34@eclinic.com.au>
<20080320104922.GB18935@a-kretschmer.de>
<65937bea0803200358i290bdc87hdeca777b593b5df1@mail.gmail.com>
<786D2B38-CE0A-41BF-9E70-4DEB22F8D9EF@eclinic.com.au>
<47E25447.6040109@freedomcircle.net>
<65937bea0803200613k4593da12hd62233f8a745309@mail.gmail.com>
Gurjeet Singh wrote:
> Except that it doesn't work... Did you try to execute that query; I am
> assuming not.
Of course I did, do you think I create results by editing them into my
email?
The script:
delete from t1;
insert into t1 values (1, 123, 'first record');
insert into t1 values (2, 456, 'second record');
insert into t1 values (3, 789, 'third record');
select * from t1;
update t1 set col2 = t1copy.col2, col3 = t1copy.col3
from t1 as t1copy
where t1.col1 = 1 and t1copy.col1 = 3;
select * from t1;
select version();
The output:
DELETE 3
INSERT 0 1
INSERT 0 1
INSERT 0 1
col1 | col2 | col3
------+------+---------------
1 | 123 | first record
2 | 456 | second record
3 | 789 | third record
(3 rows)
UPDATE 1
col1 | col2 | col3
------+------+---------------
2 | 456 | second record
3 | 789 | third record
1 | 789 | third record
(3 rows)
version
------------------------------------------------------------------------
PostgreSQL 8.1.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.0.3
(1 row)
And BTW, I also tried your UPDATE SET (salary, name) but that only
works on PG 8.2 and above. I don't see why my query would fail in
subsequent releases.
Joe
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-sql@postgresql.org
Cc: dev@freedomcircle.net, singh.gurjeet@gmail.com, gavinb@eclinic.com.au
Subject: Re: Select into
In-Reply-To: <47E268CF.3040604@freedomcircle.net>
* 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