Database Reference
In-Depth Information
Acting on function results
The previous example showed one way to retrieve and further process function res-
ults. The following are a few more useful ways to call a function:
SELECT fib(55);
SELECT
(flatten_application_settings('9.08.97')).*
SELECT * FROM
flatten_application_settings('9.08.97');
Any of the previous methods will create a legal field list in PostgreSQL, which in turn
can be used in any way that fields in a simple
SELECT
statement on a table are used.
The example from the previous section used the results of the
flat-
ten_application_settings()
function, a source of data for an
INSERT
state-
ment. The following is an example of how to use the same function as a data source
for
UPDATE
:
UPDATE application_settings_new
SET full_name = flat.full_name,
description = flat.description,
print_certificate =
flat.print_certificate,
show_advertisements =
flat.show_advertisements,
show_splash_screen =
flat.show_splash_screen
FROM flatten_application_settings('9.08.97')
flat;
