Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[] - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
Date
Msg-id CAFj8pRCZ46+1MM8q=JD9pyCU4uyBYdx67vSBvTOVcsx2LhTO4Q@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]  (Quan Zongliang <quanzongliang@yeah.net>)
List pgsql-hackers
Tree view
Hi


Isn't this code a little ugly?

>
> I propose syntax xxx.yyy%ELEMENTTYPE and xxx%ELEMENTTYPE
>
> What do you think about it?
No other relational database can be found with such an implementation.
But it seems like a good idea. It can bring more convenience to write
stored procedure.

No other databases support arrays :-)
 
Regards

Pavel


>
> Regards
>
> Pavel
>
>
>      >
>      >     --
>      >     Daniel Gustafsson
>      >
>      >
>      >
>

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE
Next
From: "David G. Johnston"
Date:
Subject: Re: odd buildfarm failure - "pg_ctl: control file appears to be corrupt"