| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "A B" <gentosaker(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem with FOUND |
| Date: | 2008-06-27 17:57:00 |
| Message-ID: | 162867790806271057hb731c27v87ab42cfa3caaafa@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2008/6/27 A B <gentosaker(at)gmail(dot)com>:
> Thanks for the suggestion on GET DIAGNOSTICS.
>
> But concerning EXECUTE, if I do
>
> BEGIN
> EXECUTE QueryA
> EXCEPTION WHEN OTHERS THEN
> QueryB
> END;
>
>
> will it execute QueryB if QueryA fails?
yes, but it's not preferable way. It creates subtransaction with some
(less) overhead.
Regards
Pavel
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2008-06-27 18:01:20 | Re: Nice to have: reverse() function in the core |
| Previous Message | Richard Broersma | 2008-06-27 17:28:01 | Re: IF ROW( NEW ) <> ROW( OLD ) |