Re: Supporting NULL elements in arrays

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: Joe Conway <mail(at)joeconway(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Supporting NULL elements in arrays
Date: 2005-11-09 18:55:48
Message-ID: 18147.1131562548@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
> If we're going non-computable, would something that's a superset
> of the SQL Standard's array value constructor be useful;

I think you've confused ARRAY[] expressions with the I/O representation
for array values. There are many good reasons why those are not
identical, starting with the fact that string literals inside an ARRAY[]
would be subject to different escaping conventions than an I/O value is.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-09 19:01:16 Re: BUG #2033: Assertion Failure: File: "procarray.c",
Previous Message Ron Mayer 2005-11-09 18:32:31 Re: Supporting NULL elements in arrays