james.sewell wrote > Hello all, > > Let's say I'm running the following SQL script via psql -f > > BEGIN > \set ON_ERROR_STOP > SELECT myFunction(); > CREATE TABLE x(id int); > END; > > Is there anything I can do in myFunction which will: > > a) Stop execution of the script so that x will not be created > b) Not throw an error (return value of 0, no ERROR in output) > > I am currently using an EXCEPTION, which satisfies a, but not b.
No. To accomplish that kind of flow control requires that you use a procedural language. pl/pgsql can serve that purpose. You can use a function or a DO block to implement. Or code a shell script. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Stop-execution-without-ERROR-tp5774688p5774689.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
