Re: sql function returning composite type

Hello Tom,

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

TL> Ivan <Ivan-Sun1(at)mail(dot)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(at)mail(dot)ru