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
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 |