On 11/12/23 09:32, Thiemo Kellner wrote:
Hi
Does PostgreSQL have something like Oracle's conditional compilation? This
is sort of an if then statement that gets evaluated on
compilation/installation time of PL/SQL code. If the condition is met, the
code until the $END gets compiled. It is even possible to switch on/off
parts of single statements. I suppose it is sort of a preprocessor that
removes the code part from $IF until $END if the condition is not met.
Pl/PgSQL is an interpreted language; there is no compilation. At
creation/installation, it just (I think) does syntax checks; it definitely
doesn't care if a table exists or not.
--
Born in Arizona, moved to Babylonia.