SETOF nomTable
.create FUNCTION selectTitres(varchar) RETURNS SETOF livre AS $$
SELECT * FROM livre WHERE liv_titre like $1;
$$ LANGUAGE SQL;
SELECT * FROM selectTitres('Les %') AS t1;
TABLE(cols)
CREATE OR REPLACE FUNCTION selectTitres(debut int, fin int)
RETURNS TABLE(numero int, titre VARCHAR) AS $$
SELECT liv_num, liv_titre FROM livre WHERE liv_num BETWEEN $1 AND $2;
$$ LANGUAGE SQL;
SELECT * FROM selectTitres(1,5) AS t1;