Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: bug.sql
Description: text/plain (1.6 KB)

In response to

Responses

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group