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

Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: "Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>,Markus Bertheau <twanger(at)bluetwanger(dot)de>
Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}
Date: 2005-05-31 21:58:03
Message-ID: 7686.1117576683@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-sql
Joe Conway <mail(at)joeconway(dot)com> writes:
>> + 	Oid			element_type = planstate->ps_ResultTupleSlot->tts_tupleDescriptor->attrs[0]->atttypid;

Hmm, that makes me itch ... it seems like unwarranted familiarity with
the innards of the subplan; not only as to where it keeps things, but
when things have been initialized.  Perhaps we have no choice, but isn't
the datatype available on the current plan level?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Joe ConwayDate: 2005-05-31 22:02:00
Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp.
Previous:From: Joe ConwayDate: 2005-05-31 21:31:16
Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}

pgsql-patches by date

Next:From: Joe ConwayDate: 2005-05-31 22:02:00
Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp.
Previous:From: Joe ConwayDate: 2005-05-31 21:31:16
Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}

pgsql-sql by date

Next:From: Joe ConwayDate: 2005-05-31 22:02:00
Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp.
Previous:From: Joe ConwayDate: 2005-05-31 21:31:16
Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {}

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