Re: arrays as pl/perl input arguments [PATCH] - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: arrays as pl/perl input arguments [PATCH]
Date
Msg-id E79E2CC9-2A2C-46EF-81E3-7DF25794B0C0@kineticode.com
Whole thread Raw
In response to Re: arrays as pl/perl input arguments [PATCH]  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: arrays as pl/perl input arguments [PATCH]  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Jan 12, 2011, at 11:36 AM, Alvaro Herrera wrote:

>> [ Id actually vote for _not_ having a compatibility option at all, we
>> change more major things than this IMHO every major release. (And even
>> then some major things in minor releases, for example the removal of
>> Safe.pm) ]
>
> I think the main question here is: how loudly is existing code going to
> break?  If the breakage is silent, it's going to be very problematic.
> If functions fail to run at all, then we can live without the
> compatibility option.

I suspect it'd be quiet, unfortunately, since there are a bazillion ad hoc implementations of a Perl SQL array parser,
andmany of them, I suspect, don't complain if the string doesn't look like an SQL array. They would just parse a string
like"ARRAY(0x118ee2a0)" and return an empty array, or a NULL. 

Best,

David

pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: pg_depend explained
Next
From: Robert Haas
Date:
Subject: Re: WIP: Range Types