On Fri, Oct 29, 2021 at 10:04:31AM -0400, Tom Lane wrote: > <to...@tuxteam.de> writes: > > In plpgsql, i'm trying to use a variable initialised in a DECLARE in > > a later initialisation expression whithin the same DECLARE: > > > DECLARE > > x int := 23; > > y int := x + 4 > > BEGIN > > ... > > > Experiments suggest that it works, but the docs are silent about that. > > Is this a good idea, or should I be more careful and do it in a nested > > block? > > I don't see any reason to foresee that it would break.
Thanks :) > However, I notice that we don't actually have any regression tests > checking this. scope_test() in plpgsql.sql checks an adjacent > question, but not exactly this one. I'm a bit inclined now to go > add such a test. Even more thanks. After a long hiatus I have the luck to play again with PostgreSQL. Let me say: you folks rock, seriously. Cheers - t
signature.asc
Description: Digital signature
