Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> writes:
> I think a common use for this would be doing multiple inserts or updates on
> one go. Like, insert into a parent table, then more details into child
> tables. You don't care about getting the results back in that case, as long
> as you get an error on failure.
As of 9.1 you can use WITH to achieve that in many cases.
wCTE and INSERT|UPDATE|DELETE … RETURNING are pretty cool combined :)
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
In response to
pgsql-hackers by date
|Next:||From: Robert Treat||Date: 2011-10-31 21:43:08|
|Subject: Re: unite recovery.conf and postgresql.conf|
|Previous:||From: Scott Mead||Date: 2011-10-31 21:37:33|
|Subject: IDLE in transaction introspection|