Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.litech.org!News.Dal.Ca!not-for-mail
From: tony <bigtoehere@hotmail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: psql commit
Date: Fri, 03 Mar 2006 11:00:03 -0400
Organization: ISINet, Nova Scotia
Lines: 20
Message-ID: <igig0255na98fbmu7abs6a9jtrb5v54pp7@4ax.com>
References: <nvke02lrkdh85onmbegjmihjp7v1e30hrk@4ax.com>
NNTP-Posting-Host: tslade.ucis.dal.ca
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: News.Dal.Ca 1141398003 26247 129.173.46.173 (3 Mar 2006 15:00:03 GMT)
X-Complaints-To: postmaster@Dal.Ca
NNTP-Posting-Date: Fri, 3 Mar 2006 15:00:03 +0000 (UTC)
X-Newsreader: Forte Free Agent 1.93/32.576 English (American)
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:125650

Thanks for the replies.  The subject should say plsql....it was the
end of a long day ; )  I'll try to explain my question more fully.

BEGIN
   IF X  = '1' THEN
      UPDATE mytable
      SET   myfield = 1
      WHERE id=idIn;
 
      htp.print('Thank you!); 
   ELSE
      htp.print('Operation failed')
   END IF;
END 

Does the commit occur after the WHERE clause or not until END? 

thanks again,
tony