Re: plpgsql: support identif%TYPE[], (from ToDo) - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: plpgsql: support identif%TYPE[], (from ToDo)
Date
Msg-id 20090728211113.GB22289@svana.org
Whole thread Raw
In response to plpgsql: support identif%TYPE[], (from ToDo)  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: plpgsql: support identif%TYPE[], (from ToDo)
List pgsql-hackers
On Tue, Jul 28, 2009 at 10:53:08PM +0200, Pavel Stehule wrote:
> Hello
>
> I would to solve some points from ToDo. I began with TYPE [] support.
> I thing, so this should be relative simple, but there are one issue.

<snip>

> My first idea is using word element:
>
> create or replace function x(a int[])
> ...
> declare f a%element;
> begin
> ...

I would have thought:

declare f a[0]%type;

as in: the type of a[0]. Perhaps a[]%type but that seems less natural.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: Deferred uniqueness versus foreign keys
Next
From: Jeff Davis
Date:
Subject: Re: Deferred uniqueness versus foreign keys