From:
Alexey Klyukin <alexk(at)commandprompt(dot)com>
To:
Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc:
Alex Hunsaker <badalex(at)gmail(dot)com>,
"David E(dot) Wheeler" <david(at)kineticode(dot)com>,
pgsql-hackers(at)postgresql(dot)org
Subject:
Re: arrays as pl/perl input arguments [PATCH]
Date:
2011-02-10 21:26:58
Message-ID:
353B1A8D-2AB5-460F-8DF7-E51632FA8A0B@commandprompt.com (view raw or flat )
Thread:
2011-01-11 22:25:35 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-01-11 23:07:53 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-11 23:44:53 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-01-12 00:17:05 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-12 00:55:49 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-01-12 02:06:09 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-12 04:45:51 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-01-12 13:34:06 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-01-12 19:22:55 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-12 19:27:05 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-12 19:27:46 from David Fetter <david(at)fetter(dot)org>
2011-01-12 19:36:17 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-01-12 19:39:56 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-12 19:51:43 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-01-12 19:55:17 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-12 20:17:08 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-01-12 20:13:25 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-01-12 21:22:03 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-12 21:45:05 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-01-12 23:29:28 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-01-12 23:37:34 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-13 07:28:54 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-13 04:57:20 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-12 13:14:17 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-01-12 18:52:42 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-01-12 20:04:56 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-01-15 22:48:28 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-26 18:45:52 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-26 19:44:26 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-01-26 20:08:03 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-26 20:35:06 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-01-26 22:44:05 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-27 07:31:47 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-27 10:38:53 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-01-28 22:27:06 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-31 08:34:23 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-01 17:04:47 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-04 01:29:59 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-04 17:29:59 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-04 18:43:34 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-06 07:43:51 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-08 15:18:22 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-08 17:33:37 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-08 18:31:25 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-09 01:44:00 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-09 15:24:23 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-09 19:28:21 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-10 13:15:59 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-10 19:44:09 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-10 21:26:58 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-12 00:17:12 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-12 07:53:14 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-15 14:39:07 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-15 17:45:22 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-02-15 17:49:17 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-15 17:52:26 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-02-16 22:54:07 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-02-16 22:57:13 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-18 02:12:29 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-02-17 23:18:27 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-02-18 00:36:45 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-02-16 17:08:11 from Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
2011-02-16 19:21:58 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-02-17 06:12:46 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-13 05:12:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-01-13 07:06:33 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-13 08:06:45 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2011-01-13 16:55:44 from Alex Hunsaker <badalex(at)gmail(dot)com>
2011-01-14 00:15:29 from "Stephen J(dot) Butler" <stephen(dot)butler(at)gmail(dot)com>
2011-01-14 00:22:31 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-02-02 17:16:00 from Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
2011-02-03 12:23:32 from Alexey Klyukin <alexk(at)commandprompt(dot)com>
2011-02-03 16:52:50 from "David E(dot) Wheeler" <david(at)kineticode(dot)com>
2011-02-03 18:01:16 from Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
2011-02-03 18:20:48 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-08 14:40:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-02-09 19:16:35 from Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
2011-02-03 18:24:47 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2011-02-03 20:21:42 from Alex Hunsaker <badalex(at)gmail(dot)com>
Lists:
pgsql-hackers
On Feb 10, 2011, at 9:44 PM, Andrew Dunstan wrote:
>
>
> On 02/10/2011 08:15 AM, Alexey Klyukin wrote:
>> On Feb 9, 2011, at 9:28 PM, Alex Hunsaker wrote:
>>
>>> On Wed, Feb 9, 2011 at 08:24, Alexey Klyukin<alexk(at)commandprompt(dot)com> wrote:
>>>> What was actually broken in encode_array_literal support of composite types
>>>> (it converted perl hashes to the literal composite-type constants, expanding
>>>> nested arrays along the way) ? I think it would be a useful extension of the
>>>> existing encode_array_literal.
>>> Yeah, It does not work because it did not take into account the order
>>> of composite columns. It always put them alphabetically by column
>>> name. To do it properly we would need to pass in a typid or a column
>>> order or something. Ideally we could expose the new
>>> plperl_array_to_datum() to plperl functions in some manner.
>> Damn, right. Each perl hash corresponds to multiple composite types, different
>> by the order of the type elements. Passing the typid sounds like a fair
>> requirement (and if it's missing we could assume that the order of columns in
>> composites doesn't matter to the caller).
>>
>> Let me try implementing that as an XS interface to plperl_array_to_datum.
>
>
> Are you intending this as a completion of the current patch or as 9.2 work? If the former you need to send it in real fast.
I'd like to extend the current patch, going to post the update by tomorrow.
/A
--
Alexey Klyukin
The PostgreSQL Company - Command Prompt, Inc.
In response to
Responses
pgsql-hackers by date
Next :From: Dimitri FontaineDate: 2011-02-10 21:32:07Subject : Re: ALTER EXTENSION UPGRADE, v3Previous :From : Steve SingerDate : 2011-02-10 21:26:13Subject : Re: pl/python custom exceptions for SPI
