Re: plpgsql: support identif%TYPE[], (from ToDo)

[Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>]

2009/7/28 Martijn van Oosterhout <kleptog(at)svana(dot)org>:
> 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.
>

It's clean so a[0] means element of array, but why zero. PostgreSQL
array should to start from any int value :(. And this syntax is little
bit difficult parserable.

What do you thing about:

declare
  f array of a%type;
  x element of f%type;

??

regards
Pavel


> Have a nice day,
> --
> Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
>> Please line up in a tree and maintain the heap invariant while
>> boarding. Thank you for flying nlogn airlines.
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iD8DBQFKb2lxIB7bNG8LQkwRApwuAJ4snkAtixsMa2ju8r0jYYIH2hIJ6ACeOVQj
> /oiBdGmX8zQddwmwsvjLnOM=
> =xtg2
> -----END PGP SIGNATURE-----
>
>