Re: sql function returning composite type - Mailing list pgsql-bugs

From Ivan
Subject Re: sql function returning composite type
Date
Msg-id 1637288277.20040921202225@mail.ru
Whole thread Raw
In response to Re: sql function returning composite type  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: sql function returning composite type
Re: sql function returning composite type
List pgsql-bugs
Hello Tom,

Tuesday, September 21, 2004, 6:17:37 PM, you wrote:

TL> Ivan <Ivan-Sun1@mail.ru> writes:
>> Suppose we have sql function which returns composite type.
>> When such function's last select statement doesn't return any row
>> error occurs -
>> ERROR:  function returning row cannot return null value.

TL> Works for me (tested in 7.4.5 and CVS tip).

I've just (an hour ago) get latest version from CVS.

"PostgreSQL 8.0.0beta2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3 (mingw special 20030504-1)"

Still have the same error - ERROR:  function returning row cannot return null value

I attached sql file.
Error occurs when do

select * from "test"('secon')

--
Best regards,
 Ivan                            mailto:Ivan-Sun1@mail.ru
Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: sql function returning composite type
Next
From: Tom Lane
Date:
Subject: Re: sql function returning composite type