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

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: plpgsql: support identif%TYPE[], (from ToDo)
Date: 2009-07-28 21:11:13
Message-ID: 20090728211113.GB22289@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2009-07-28 21:16:28 Re: Deferred uniqueness versus foreign keys
Previous Message Dean Rasheed 2009-07-28 21:10:54 Re: Deferred uniqueness versus foreign keys