Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group