Pavel Stehule: > The session variables can be used in queries, but should be used in > PL/pgSQL expressions, and then the mandatory usage in FROM clause will > do lot of problems and unreadable code like > > DO $$ > BEGIN > RAISE NOTICE '% %', (SELECT x FROM x), (SELECT a,b FROM y); > > END > $$ > > This requirement does variables unusable in PL
I already proposed earlier to only require listing them in FROM when there is actually a related FROM.
but there is technical problem - plpgsql expression are internally SQL queries. Isn't possible to cleanly to parse queries and expressions differently.