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

Hi Mark,

On Sun, Feb 24, 2008 at 10:21 PM, Mark Mielke <mark@mark.mielke.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