čt 17. 12. 2020 v 17:45 odesílatel hubert depesz lubaczewski < dep...@depesz.com> napsal:
> On Thu, Dec 17, 2020 at 03:32:09PM +0100, Joel Jacobson wrote: > > Hi, > > Is there a way to raise an exception with a message, > > without having to add your own plpgsql helper-function? > > Currently this is what I have: > > Well, you can: > DO $$ begin raise notice 'zz'; END; $$; > It's cheating though, as it still needs plpgsql. > > Best regards, > Some years there was discussion about this possibility https://www.postgresql-archive.org/How-to-raise-error-from-PostgreSql-SQL-statement-if-some-condition-is-met-td5719585.html There was another thread, but I cannot to find it Regards Pavel > depesz > > > >
