Thread: SQL function and composite types

SQL function and composite types

From
"Ron Sofrin"
Date:
Hi all,

having this simple table:

create table foo (attribute text);

and this simple function:

create function f()
returns foo
as'   select  ' 'test' '::text'
langauge 'sql' ;

When I execute (though psql) select f();

I get the following result

f
----------------
136411800

instead  of the expected:

f
-----------------
test



Any ideas?