Database Reference
In-Depth Information
city,
state,
zip
)
VALUES
(
2,
'Bill & Co',
2014,
'Lilly Road',
'New London',
'CT',
4321
);
UPDATE table SET column = expression [, ...] [WHERE condition]
UPDATE warehouse_tbl SET street_address = 'Tulip Road' WHERE
street_address='Lilly Road';
Evaluation of expressions is actually done by the PostgreSQL server and not
PL/pgSQL. All PL/pgSQL expressions are prepared only once during the lifetime
of a PostgreSQL backend process.
Control structures
The strength of a programming language can also be judged by the means it
provides to control the low of a program. It's a structural organization of statements
in such a way that it should determine the order of execution. Conditional statements
and loops are one of those options. PL/pgSQL is fortunate to have these features as
well, thus giving its users the freedom to code and control.
Conditional statements
Conditional statements execute in true sense of their literal meanings. It means
that they perform a speciied operation only when a certain deined condition is
met. Hence, in this way, the logical resolution of the condition decides the low
of the program.
Let's dissect the conditional statements of PL/pgSQL one by one and see how
much versatility each statement depicts.
