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: (view raw or whole 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:

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



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

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-2015 The PostgreSQL Global Development Group