SQL function and composite types

From: "Ron Sofrin" <rsofrin(at)entercept(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: SQL function and composite types
Date: 2001-01-25 23:47:47
Message-ID: 94qdsf$7gr$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-sql by date

  From Date Subject
Next Message Ron Peterson 2001-01-26 02:34:40 Re: Is there anything like DESCRIBE?
Previous Message Glen and Rosanne Eustace 2001-01-25 23:46:21 Re: Problem with Dates