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.