Re: Why can't I have a "language sql" anonymous block? - Mailing list pgsql-general

From Tom Lane
Subject Re: Why can't I have a "language sql" anonymous block?
Date
Msg-id 872342.1639428817@sss.pgh.pa.us
Whole thread Raw
In response to Why can't I have a "language sql" anonymous block?  (Bryn Llewellyn <bryn@yugabyte.com>)
Responses Re: Why can't I have a "language sql" anonymous block?
List pgsql-general
Bryn Llewellyn <bryn@yugabyte.com> writes:
> Was there a deliberate decision not to allow a “language sql” anonymous block? Or is it just that nobody thought that
itwould be useful? 

I think nobody thought it'd be useful.  What's the difference from
just executing the contained SQL statements?

(If DO blocks had parameters, the conclusion might be different,
but they don't so far.)

            regards, tom lane



pgsql-general by date:

Previous
From: Bryn Llewellyn
Date:
Subject: Why can't I have a "language sql" anonymous block?
Next
From: Matt Magoffin
Date:
Subject: Properly handling aggregate in nested function call