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

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Quan Zongliang <quanzongliang(at)yeah(dot)net>
Cc: Daniel Gustafsson <daniel(at)yesql(dot)se>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PL/pgSQL: Incomplete item Allow handling of %TYPE arrays, e.g. tab.col%TYPE[]
Date: 2023-10-17 18:04:34
Message-ID: CAFj8pRCZ46+1MM8q=JD9pyCU4uyBYdx67vSBvTOVcsx2LhTO4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
> > >
> > >
> > >
> >
>
>

In response to

Browse pgsql-hackers by date

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