| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Max Ulidtko <ulidtko(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Getting error 42P02, despite query parameter being sent |
| Date: | 2024-11-17 17:18:22 |
| Message-ID: | CAKFQuwb+5Rxp_gV2ZD7w27xt_QV-Okn2veFg1zMDduGUQyUDiA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Nov 17, 2024 at 3:10 AM Max Ulidtko <ulidtko(at)gmail(dot)com> wrote:
> I assumed that $1 would get substituted *at query time*
>
The "select" portion of a "create view" query does not get executed during
processing of "create view" and it is the "select" execution part of the
executor code that performs parameter substitution. IOW, "at query time"
never actually happens, the query is only considered as a literal to be
parsed.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2024-11-17 19:44:01 | Re: Getting error 42P02, despite query parameter being sent |
| Previous Message | Adrian Klaver | 2024-11-17 17:05:46 | Re: Getting error 42P02, despite query parameter being sent |