Function x returns opaque in error typeidTypeRelid - Mailing list pgsql-sql

From Sondaar Roelof
Subject Function x returns opaque in error typeidTypeRelid
Date
Msg-id F28A2B83DFE0D411A7B3006097487147468FEE@sv7007.scania.se
Whole thread Raw
List pgsql-sql
Hello,

I am a bit at a loss here.
If I create a function  which returns something it works fine.
If it returns opaque I get the following: ERROR:  typeidTypeRelid: Invalid
type - oid = 0
What am I doing wrong ?

Thanks in advance.
Best regards,
Roelof Sondaar

dhcp=# drop function lalala();
DROP
dhcp=# create function lalala() returns opaque as '
dhcp'# declare
dhcp'#     sname       text;
dhcp'# begin
dhcp'#     sname:= ''lalala'';
dhcp'# end;
dhcp'# ' language 'plpgsql';
CREATE
dhcp=#
dhcp=# select lalala();
ERROR:  typeidTypeRelid: Invalid type - oid = 0
dhcp=#
dhcp=# drop function lalala2();
DROP
dhcp=# create function lalala2() returns text as '
dhcp'# declare
dhcp'#     sname       text;
dhcp'# begin
dhcp'#     sname:= ''lalala'';
dhcp'#     return sname;
dhcp'# end;
dhcp'# ' language 'plpgsql';
CREATE
dhcp=#
dhcp=# select lalala2();lalala2
---------lalala
(1 row)



pgsql-sql by date:

Previous
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: serial type; race conditions
Next
From: edipoelder@ig.com.br
Date:
Subject: Help with 'now', now(), timestamp 'now', ...