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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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-----
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Brendan Jurd | 2009-07-29 15:36:15 | Re: WIP: to_char, support for EEEE format |
Previous Message | Pavel Stehule | 2009-07-29 15:25:53 | Re: plpgsql: support identif%TYPE[], (from ToDo) |