Re: insert ... delete ... returning ... ?

Hi Mark,

On Sun, Feb 24, 2008 at 10:21 PM, Mark Mielke <mark(at)mark(dot)mielke(dot)cc> wrote:
> I'm at PostgreSQL 8.3 for my production database and everything is
> working great. I had no problems converting free text search from 8.2 to
> 8.3, and I really like the improvements.
>
> I tried using insert ... delete ... return ... and get a syntax error:
>
> > pccyber=# insert into product_manufacturer_archived (itemno,
> > manufacturer_id)

I would expect a semicolon here.

> > pccyber-# delete from product_manufacturer
> > pccyber-# where not exists (select * from icitem
> > pccyber(# where icitem.itemno =
> > product_manufacturer.itemno and
> > pccyber(# not inactive)
> > pccyber-# returning itemno, manufacturer_id;
> > ERROR: syntax error at or near "delete"
> > LINE 2: delete from product_manufacturer
> > ^

--
Guillaume