Re: initialize and use variable in query

Thanks!

On Sat, Dec 29, 2018 at 10:06 AM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Saturday, December 29, 2018, Ray O'Donnell <ray(at)rodonnell(dot)ie> 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 assignment in the DO should probably be:
>>
>> select max(fctrdt) into startdate from fnmloan;
>>
>
> The original form is perfectly valid plpgsql;
>
> The DO block worked just fine. It’s just that everything it did was
> discarded at the end of it because nothing that permanently affected the
> parent SQL session happened.
>
> David J.
>
>