plperl arginfo

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Cc: Tim Bunce <Tim(dot)Bunce(at)pobox(dot)com>
Subject: plperl arginfo
Date: 2010-10-28 15:24:50
Message-ID: 4CC995C2.3000704@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

While we were discussing allowing generic record type arguments to
plperl functions, Tom suggested that we should expose the type
information about the record members to plperl. I think if we do that we
should probably expand it somewhat to all arguments, so that for
non-trigger functions, we'd have $_ARG_INFO while could look something
like this:

{
names => ['arg1', undef, 'arg3' ] , # no name was supplied for arg2
modes => ['in', 'in', 'in' ], # do we support anything other
than IN ?
types => ['integer', 'text', { name => 'somecomposite', fields
=> [ 'field1', 'field2' ], types => ['date', 'numeric' ] } ],
}

Maybe we should also pass in type Oid info, too.

I don't think this would be terribly difficult to do.

thoughts?

cheers

andrew

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jesper Krogh 2010-10-28 15:28:53 Re: Postgres insert performance and storage requirement compared to Oracle
Previous Message Alvaro Herrera 2010-10-28 14:50:40 Re: add label to enum syntax