DELETE & INSERT in a function

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: DELETE & INSERT in a function
Date: 2005-01-11 18:38:18
Message-ID: 20050111183818.M30378@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-01-11 19:08:09 Re: Writing to dependent tables in a function
Previous Message Tom Lane 2005-01-11 17:57:16 Re: Major Problems with pg_dump