Re: PL/pgSQL 2 - Mailing list pgsql-hackers

From Joel Jacobson
Subject Re: PL/pgSQL 2
Date
Msg-id CAASwCXfWZ1O+vepmQScCPTL5oUuy_0=6RncOVMHidbU3DT=vMA@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL 2  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: PL/pgSQL 2  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Re: PL/pgSQL 2  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: PL/pgSQL 2  (Craig Ringer <craig@2ndquadrant.com>)
Re: PL/pgSQL 2  (David G Johnston <david.g.johnston@gmail.com>)
Re: PL/pgSQL 2  (Jan Wieck <jan@wi3ck.info>)
List pgsql-hackers
On Mon, Sep 1, 2014 at 4:26 PM, Craig Ringer <craig@2ndquadrant.com> wrote:
> Well, the idiom:
>
>   EXECUTE format("SELECT %I FROM %I WHERE $1", col, tbl) USING val;
>
> is not lovely. It works, but it's clumsy.

This is exactly why we need a new language.
All the clumsy stuff we cannot fix in plpgsql, can easily be fixed in
plpgsql2, with the most beautiful syntax we can come up with.

I guess it's a question if we want to support things like this. If we
want to, then we also want a new language.



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: PL/pgSQL 2
Next
From: Heikki Linnakangas
Date:
Subject: Re: PL/pgSQL 2