From: | Rémi Cura <remi(dot)cura(at)gmail(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Missing table from in INSERT RETURNING |
Date: | 2015-02-17 16:18:46 |
Message-ID: | CAJvUf_v0G+8MzG8Dp7v7iizh00wb6gDCDZQmBY6jTPjhQRUohQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello dear list,
I would appreciate some help on a small matter that has been bothering me
for a long time :
CREATE TABLE test_insert_returning(
gid SERIAL
,some_value int
);
WITH serie AS (
select s, s*10 as computing
from generate_series(1,10) as s
)
INSERT INTO test_insert_returning (some_value)
SELECT computing
FROM serie
RETURNING gid, serie.s
doesn't work.
The only workaround I found was to create a plpgsql function that doesan
idnividual insert
so that :
WITH serie AS (
select s, s*10 as computing
from generate_series(1,10) as s
)
SELECT serie.s, my_inserting_function(computing)
FROM serie ;
But it is very annoying and potentially bad for performance because many
insert may be fired.
Any solution?
(postgres 9.3)
Cheers,
Rémi-C
From | Date | Subject | |
---|---|---|---|
Next Message | Daniel LaMotte | 2015-02-17 16:43:30 | Re: Issue dumping schema using readonly user |
Previous Message | Adrian Klaver | 2015-02-17 15:25:14 | Re: Issue dumping schema using readonly user |