Re: Schema variables - new implementation for Postgres 15 - Mailing list pgsql-hackers

From Wolfgang Walther
Subject Re: Schema variables - new implementation for Postgres 15
Date
Msg-id 143925f8-8fb3-4e98-8452-93a7e9e94d18@technowledgy.de
Whole thread Raw
In response to Re: Schema variables - new implementation for Postgres 15  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Schema variables - new implementation for Postgres 15
List pgsql-hackers
Pavel Stehule:
> When you write RAISE NOTICE '%', x, then PLpgSQL parser rewrite it to 
> RAISE NOTICE '%', SELECT $1
> 
> There is no parser just for expressions.

That's why my suggestion in [1] already made a difference between:

SELECT var;

and

SELECT col, var FROM table, var;

So the "only require variable-in-FROM if FROM is used" should extend to 
the SQL level.

That should be possible, right?

Best,

Wolfgang

[1]: 
https://www.postgresql.org/message-id/e7faf42f-62b8-47f4-af5c-cb8efa3e0e20%40technowledgy.de



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Schema variables - new implementation for Postgres 15
Next
From: David Christensen
Date:
Subject: Re: Add memory context type to pg_backend_memory_contexts view