2014-09-18 22:35 GMT+02:00 Josh Berkus <j...@agliodbs.com>: > On 09/18/2014 01:29 PM, Vik Fearing wrote: > > On 09/18/2014 10:16 PM, Hannu Krosing wrote: > >>> WITH > >>> FUNCTION f1(a int) RETURNS int AS $$ .. $$ LANGUAGE plpgsql, > >>> FUNCTION f2(a int) RETURNS SETOF int AS $$ .. $$ LANGUAGE > >>> plpgsql, > >>> SELECT f1(x) FROM f2(z) LATERAL .... > >>> > >>> We can generalize WITH clause, so there SEQENCES, VIEWS, .. can be > >>> defined for "single usage" > >> +2 > >> > >> I just proposed the same thing in another branch of this discussion > >> before reading this :) > >> > >> I guess it proves (a little) that WITH is the right place to do these > >> kind of things ... > > > > I've been wanting this syntax for a few years now, so I certainly vote > > for it. > > > > Just to clarify: I want the WITH syntax for different purposes. > However, I *also* want DO $$ ... $$ USING ( ). Those are two separate, > different features with different use-cases. >
+1 as parametrized (read only) DO statement > > -- > Josh Berkus > PostgreSQL Experts Inc. > http://pgexperts.com > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >
