Postgres Pro
Downloads
Home   >   mailing lists

Re: DELETE & INSERT in a function - Mailing list pgsql-novice

From Vishal Kashyap @ [SaiHertz]
Subject Re: DELETE & INSERT in a function
Date
Msg-id 77b69d2105011111172377fba2@mail.gmail.com
Whole thread Raw
In response to DELETE & INSERT in a function  ("Keith Worthington" <keithw@narrowpathinc.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Writing to dependent tables in a function
Next
From: "Keith Worthington"
Date:
Subject: Re: Writing to dependent tables in a function