Just refactor DO block to function that returns row set and put SELECT inside.
> 29 дек. 2018 г., в 18:40, Glenn Schultz написал(а):
>
> All,
>
> I need to initialize a variable and then use it in query. Ultimately this
> will part of a recursive CTE but for now I just need to work this out.
Thanks!
On Sat, Dec 29, 2018 at 10:06 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Saturday, December 29, 2018, Ray O'Donnell wrote:
>>
>> A couple of things off the top of my head:
>
>
> Sorry but, no.
>
>>
>> (i) I think you need "language plpgsql" (or whatever) after the DO
On Saturday, December 29, 2018, Ray O'Donnell wrote:
>
> A couple of things off the top of my head:
Sorry but, no.
>
> (i) I think you need "language plpgsql" (or whatever) after the DO block.
As the docs state plpgsql is the default for a DO block lacking a language
specifier.
> (ii) That
On Saturday, December 29, 2018, Glenn Schultz wrote:
> All,
>
> I need to initialize a variable and then use it in query. Ultimately this
> will part of a recursive CTE but for now I just need to work this out. I
> followed the docs and thought I needed something like this. But does not
> work
On 29/12/2018 15:40, Glenn Schultz wrote:
All,
I need to initialize a variable and then use it in query.
Ultimately this will part of a recursive CTE but for now I just need to
work this out. I followed the docs and thought I needed something like
this. But does not work-maybe I have misun
All,
I need to initialize a variable and then use it in query. Ultimately this
will part of a recursive CTE but for now I just need to work this out. I
followed the docs and thought I needed something like this. But does not
work-maybe I have misunderstood. Is this possible?
SET max_parallel_
