CREATE FUNCTION broken

From: jwieck(at)debis(dot)com (Jan Wieck)
To: pgsql-hackers(at)postgreSQL(dot)org (PostgreSQL HACKERS)
Subject: CREATE FUNCTION broken
Date: 1998-02-13 11:41:14
Message-ID: m0y3JUZ-000BFRC@orion.SAPserv.Hamburg.dsh.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Someone changed the parser to build a TypeName node on CREATE
FUNCTION in any case. As a side effect, ALL! functions
created got the proretset attribute to true. Thus for a
SELECT the parser wrapped an Iter node around the Expr and
since singleton functions set isDone the Iter returns no
tuple up.

Until later, Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #

*** define.c.orig Fri Feb 13 12:14:17 1998
--- define.c Fri Feb 13 12:14:38 1998
***************
*** 94,100 ****
TypeName *setType = (TypeName *) returnType;

*prorettype_p = setType->name;
! *returnsSet_p = true;
}
else
{
--- 94,100 ----
TypeName *setType = (TypeName *) returnType;

*prorettype_p = setType->name;
! *returnsSet_p = setType->setof;
}
else
{

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim B. Mikheev 1998-02-13 11:47:26 Re: [HACKERS] Memory leaks?
Previous Message Frederick W. Reimer 1998-02-13 11:24:12 Re: [PORTS] v6.3 release ToDo list and supported ports