On Thu, Sep 10, 2009 at 3:15 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> On Thu, Sep 10, 2009 at 2:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>>> 2. Come up with some way to do the equivalent of "variadic any[]",
>>> ie, a variable number of not-all-the-same-type arguments. (This isn't
>>> just a type-system problem, there's also the question of how the type
>>> information would be passed at runtime. IIRC we have a solution at the
>>> C level but not for PLs.)
>
>> This also seems like a good idea. Will pg_typeof() work for PL/pgsql?
>
> pg_typeof() applied to what? The existing approach assumes we can make
> an array out of the variadic parameters, which isn't going to be the
> case here.
Oh. For some reason I thought that would still be possible. I don't
think it's worth designing a whole new PL/pgsql language construct
just to support this feature. Given that this should be a relatively
unusual type of function, asking people to write them in C doesn't
seem unreasonable.
...Robert