Re: cannot use result of (insert..returning)

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: dvs <dvs(at)fon(dot)kamchatka(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: cannot use result of (insert..returning)
Date: 2008-06-12 00:50:04
Message-ID: 200806120050.m5C0o4O22459@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas wrote:
> dvs wrote:
> > Hello,
> >
> > I need to use query like:
> > select (insert into test (a) values (x) returning b),c from anytable
> > where condition
> > but it say
> > ERROR: syntax error at or near "into"
> >
> > Is this a bug?
>
> No, it's a known limitation.

Is there a TODO item for this? I don't see one, do you?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-06-12 00:54:40 Re: Overhauling GUCS
Previous Message Josh Berkus 2008-06-12 00:37:40 Re: Overhauling GUCS