sam <sam.mahindrakar@xxxxxxxxx> writes: > Ok i realised that the only way data can be committed within a > procedure is to use nested BEGIN......END. Nothing that you said in this message is correct. You can't "commit" anything within a function, and bare BEGIN/END don't do anything at all except create a syntactic grouping. BEGIN/EXCEPT/END can indeed be used to limit the scope of errors, but I don't think the way you've described it is a helpful way to think about it, even with that correction. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
