| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How to write such a query? |
| Date: | 2022-01-06 07:07:56 |
| Message-ID: | CA+FnnTzcdREPXasv_23AGysSG1J3zFZpOZvV1qcukJoOjOm7pQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi, David,
On Thu, Jan 6, 2022 at 1:00 AM David G. Johnston
<david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Wednesday, January 5, 2022, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
>>
>>
>> Is there a way to write such a SELECT statement with the
>> named parameter in PostgreSQL?
>
>
> The server, and its prepared SQL capability, doesn’t understand named parameters. Only numbered ones.
>
> That said, there are a number of different ways to write and execute SQL available to you and each of those provides different extended capabilities. For instance, psql and its variables feature.
It looks like your answer contradicts with Ron...
Thank you.
>
> David J.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2022-01-06 07:11:26 | Re: How to write such a query? |
| Previous Message | Igor Korot | 2022-01-06 07:06:31 | Re: How to write such a query? |