Function x returns opaque in error typeidTypeRelid

Поиск
Список
Период
Сортировка
От Sondaar Roelof
Тема Function x returns opaque in error typeidTypeRelid
Дата
Msg-id F28A2B83DFE0D411A7B3006097487147468FEE@sv7007.scania.se
обсуждение исходный текст
Список 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 по дате отправления: