Postgres Pro
Downloads
Home   >   mailing lists

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

From Keith Worthington
Subject DELETE & INSERT in a function
Date
Msg-id 20050111183818.M30378@narrowpathinc.com
Whole thread Raw
Responses Re: DELETE & INSERT in a function
List pgsql-novice
Tree view 
Hi All,

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?  I am seeing some behavior using PostgreSQL v7.3.6 that I do not
understand.

Kind Regards,
Keith

______________________________________________
99main Internet Services http://www.99main.com

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Major Problems with pg_dump
Next
From: Tom Lane
Date:
Subject: Re: Writing to dependent tables in a function