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

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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: plpgsql: support identif%TYPE[], (from ToDo)
Date: 2009-07-29 15:30:08
Message-ID: 162867790907290830p7a0d81f0g67c30c5ffd807f6d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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-----
>
>

In response to

pgsql-hackers by date

Next:From: Brendan JurdDate: 2009-07-29 15:36:15
Subject: Re: WIP: to_char, support for EEEE format
Previous:From: Pavel StehuleDate: 2009-07-29 15:25:53
Subject: Re: plpgsql: support identif%TYPE[], (from ToDo)

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