Hello all!<br /> Trying to emulate "named" user defined exception with:<br /> CREATE OR REPLACE FUNCTION exception_aaa
() RETURNS text AS $body$<br /> BEGIN<br /> return 31234; <br /> END;<br /> $body$<br /> LANGUAGE PLPGSQL<br />
SECURITYDEFINER<br /> ;<br /><br /> do $$<br /> begin<br /> raise exception using errcode=exception_aaa();<br />
exception<br /> when sqlstate exception_aaa()<br /> then<br /> raise notice 'got exception %',sqlstate;<br
/>end;<br /> $$<br /> <br /> Got:<br /><br /> ERROR: syntax error at or near "exception_aaa"<br /> LINE 20: sqlstate
exception_aaa()<br/><br /> I looks like "when sqlstate exception_aaa()" doesn't work. <br /><br /> How can I catch
exceptionin this case?<br /><pre class="moz-signature" cols="72">--
Alex Ignatov
Postgres Professional: <a class="moz-txt-link-freetext"
href="http://www.postgrespro.com">http://www.postgrespro.com</a>
The Russian Postgres Company
</pre><br /><br /><hr style="border:none; color:#909090; background-color:#B0B0B0; height: 1px; width: 99%;" /><table
style="border-collapse:collapse;border:none;"><tr><tdstyle="border:none;padding:0px 15px 0px 8px"><a
href="https://www.avast.com/antivirus"><img alt="Avast logo" border="0"
src="http://static.avast.com/emails/avast-mail-stamp.png"/> </a></td><td><p style="color:#3d4d5a;
font-family:"Calibri","Verdana","Arial","Helvetica";font-size:12pt;"> This email has been checked for viruses by Avast
antivirussoftware. <br /><a href="https://www.avast.com/antivirus">www.avast.com</a></td></tr></table><br />