Re: Anonymous Code Blocks as Lambdas? - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Anonymous Code Blocks as Lambdas?
Date
Msg-id 162867790910261553r7d3703e8x82e08feba9553b3a@mail.gmail.com
Whole thread Raw
In response to Re: Anonymous Code Blocks as Lambdas?  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: Anonymous Code Blocks as Lambdas?
List pgsql-hackers
2009/10/26 David E. Wheeler <david@kineticode.com>:
> On Oct 26, 2009, at 2:12 PM, Pavel Stehule wrote:
>
>> it should be light relation. 'DO' should be parametrised, and psql can
>> use own variables as 'DO' parameters.
>
> I see, because `DO` is a statement, not an expression. Thus arguments don't
> really make much sense (I wish it was an expression!).

uff. How you would to write scripts? How you would to join client side
and server side? What I know, statements in PostgreSQL are
parametrised - INSERT, SELECT and others.

>
> I don't think it's a good idea to tie SQL syntax to a feature of a client,
> though.
>

DO should have any syntax. Other than I wrote. It isn't important in
this moment. Do without parametrsation has not full power. It is like
EXECUTE without USING clause. Sure. You can live without it, but the
live with it is much more confortable. So now we have isolated PL
fragment without any outer inputs.

Regards

Pavel
> Best,
>
> David
>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: GROUP BY bug or feature?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: table corrupted