pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Andreas <maps.on@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: Use select and update together
Date: Sat, 17 Sep 2011 16:56:56 +0200
Message-ID: <4E74B538.8080902@gmx.net> (raw)
In-Reply-To: <CAOWY8=bpkoexYaoqGJf42Fo4Zprj6TwmV6OukKvQkJSEg=Gqxw@mail.gmail.com>
References: <CAH4qf7Z=q0XVF-2bPL0Ag3mQREUqCLHgJEGcdPP66XMTd6n_7A@mail.gmail.com>
	<CAOWY8=bpkoexYaoqGJf42Fo4Zprj6TwmV6OukKvQkJSEg=Gqxw@mail.gmail.com>

Am 13.09.2011 07:50, schrieb pasman pasmański:
> In 8.4 this syntax is not implemented.

select * from (
update tbl set val = 1 where key in ( 1, 2, 3, 4, 5 ) returning *
) as x

wouldn't work even in PG 9.1.
So what data structure is coming out of an "update ... returning *" 
statement?
It obviously doesn't work like a subquery.

view thread (6+ messages)  latest in thread

Message-ID: <4E74B538.8080902@gmx.net>
Permalink:  ../4E74B538.8080902@gmx.net/
Also on:    postgresql.org/message-id/4E74B538.8080902@gmx.net

copy link · copy postgr.es

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: maps.on@gmx.net
  Subject: Re: Use select and update together
  In-Reply-To: <4E74B538.8080902@gmx.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