Gossamer Forum
Home : General : Databases and SQL :

function [POSTGRES]

Quote Reply
function [POSTGRES]
I create this function:
create fct_prova() returns setof tbl_prova as'
select * from tbl_prova;
' language sql;

when i select i have this problem:

select * from fct_prova() ;

parser: parse error at or near "("

If i use select fct_prova();

returns only the oid rows (i suppose)

how can i do?