X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0EBC652974 for ; Tue, 31 May 2005 18:58:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31104-04 for ; Tue, 31 May 2005 21:58:06 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 995DB5280B for ; Tue, 31 May 2005 18:58:04 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j4VLw3PR007687; Tue, 31 May 2005 17:58:03 -0400 (EDT) To: Joe Conway Cc: "Patches (PostgreSQL)" , Markus Bertheau Subject: Re: [SQL] ARRAY() returning NULL instead of ARRAY[] resp. {} In-reply-to: <429CD7A4.7020702@joeconway.com> References: <1116873219.7306.0.camel@localhost.localdomain> <42923762.7010708@joeconway.com> <16774.1116907560@sss.pgh.pa.us> <42961E44.7040701@joeconway.com> <429CD7A4.7020702@joeconway.com> Comments: In-reply-to Joe Conway message dated "Tue, 31 May 2005 14:31:16 -0700" Date: Tue, 31 May 2005 17:58:03 -0400 Message-ID: <7686.1117576683@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/404 X-Sequence-Number: 15731 Joe Conway 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