Re: DO ... RETURNING - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: DO ... RETURNING
Date
Msg-id CAFj8pRBntWdE=vmUbsvj6K1J6fgW_V7BMSojUb3oE-O2D1+yTQ@mail.gmail.com
Whole thread Raw
In response to Re: DO ... RETURNING  (Hannu Krosing <hannu@2ndQuadrant.com>)
Responses Re: DO ... RETURNING  (David Fetter <david@fetter.org>)
Re: DO ... RETURNING  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
Hello
>
> The current situation is akin to not being able to use queries
> directly but always requiring you to create a view first and
> then do "select ... from myview"
>

ok

probably we can allow using DO in CTE without impact on other SQL
statements, and for this purpose we need to know returned
TupleDescriptor early.

so I am able accept it, although I am thinking so we are going in
strange direction. We are not able do simply tasks simply (we cannot
execute SQL script on server side simply) :(. But it is not problem of
Hannu design.

other question - can we find some readable and intuitive syntax for DO
parametrization?

Regards

Pavel



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Parallell Optimizer
Next
From: David Fetter
Date:
Subject: Re: DO ... RETURNING