SQL function and composite types - Mailing list pgsql-sql

From Ron Sofrin
Subject SQL function and composite types
Date
Msg-id 94qdsf$7gr$1@news.tht.net
Whole thread Raw
List pgsql-sql
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?




pgsql-sql by date:

Previous
From: juerg.rietmann@pup.ch
Date:
Subject: how to query this ??
Next
From: "David J. R. Brook"
Date:
Subject: