Re: DELETE & INSERT in a function

From: "Vishal Kashyap (at) [SaiHertz]" <vishalonlist(at)gmail(dot)com>
To: KeithW(at)narrowpathinc(dot)com
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: DELETE & INSERT in a function
Date: 2005-01-11 19:17:46
Message-ID: 77b69d2105011111172377fba2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Keith ,

>
> If I have a DELETE operation and an INSERT operation in a function will the
> DELETE operation be performed after the INSERT regardless of the order inside
> the function?
They must work in the order specified.

> I am seeing some behavior using PostgreSQL v7.3.6 that I do not
> understand.

Please do let us know more.

--
With Best Regards,
Vishal Kashyap.
http://vishalkashyap.tk

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Keith Worthington 2005-01-11 19:49:31 Re: Writing to dependent tables in a function
Previous Message Tom Lane 2005-01-11 19:08:09 Re: Writing to dependent tables in a function