problem with function

From: smauroz(at)libero(dot)it <smauroz(at)libero(dot)it>
To: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: problem with function
Date: 2003-03-20 14:14:22
Message-ID: HC1WVY$6FE1C8D5A7C183D0E59C90C2BA395805@libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

tbl_prova:

prova | prova2
---------------
sma | sma2
sma3 | sma4

Hi,
i'm using this function:

create fct_prova() returns setof tbl_prova as'
select * from tbl_prova;
' language sql;

When i recall this function with:
select fct_prova();
I see only 2 rows with (probably) the oid.

If i select i have this problem:
select * from fct_prova() ;
parser: parse error at or near "("

How can i see the real text in the cols when i use the function ftc_prova()? (i must specify more argtype? where?).
Tnx a lot.
Smauroz

Browse pgsql-novice by date

  From Date Subject
Next Message Ennio Iannucci 2003-03-20 15:39:16 [NOVICE] Extended display and extended ascii characters
Previous Message Ben Clewett 2003-03-20 13:12:44 User check