A table is defined as follows:

CREATE TABLE t (id INT, val TEXT); Select two correct statements from below about the function "get_head" defined below. CREATE FUNCTION get_head(BOOLEAN) RETURNS TEXT LANGUAGE sql CALLED ON NULL INPUT AS 'SELECT val FROM t WHERE $1 OR id > 0 ORDER BY id LIMIT 1;';

Question

A table is defined as follows:

CREATE TABLE t (id INT, val TEXT); Select two correct statements from below about the function "get_head" defined below. CREATE FUNCTION get_head(BOOLEAN) RETURNS TEXT LANGUAGE sql CALLED ON NULL INPUT AS 'SELECT val FROM t WHERE $1 OR id > 0 ORDER BY id LIMIT 1;';

Accepted Answer

D. Even if this function is passed the same parameter value and executed multiple times, the E. If a function with the same name and with type BOOLEAN as the parameter is already defined,

Answer

A. This function is defined using PL/pgSQL.

Answer

B. There are cases where this function returns multiple lines.

Answer

C. When NULL is passed for the argument and the function is executed, NULL is returned.

A table is defined as follows: CREATE TABLE t (id INT, val TEXT); Select two correct statements from below about the function "get_head" defined below. CREATE FUNCTION get_head(BOOLEAN) RETURNS TEXT…

Question

Options

How the community answered

Community Discussion