Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group