Re: sql function returning composite type

From: Ivan <Ivan-Sun1(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: sql function returning composite type
Date: 2004-09-21 16:22:25
Message-ID: 1637288277.20040921202225@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Attachment Content-Type Size
bug.sql text/plain 1.6 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-09-21 16:44:03 Re: sql function returning composite type
Previous Message Tom Lane 2004-09-21 14:17:37 Re: sql function returning composite type