Re: How to write such a query? - Mailing list pgsql-general

From Igor Korot
Subject Re: How to write such a query?
Date
Msg-id CA+FnnTzcdREPXasv_23AGysSG1J3zFZpOZvV1qcukJoOjOm7pQ@mail.gmail.com
Whole thread Raw
In response to Re: How to write such a query?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: How to write such a query?
List pgsql-general
Hi, David,

On Thu, Jan 6, 2022 at 1:00 AM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Wednesday, January 5, 2022, Igor Korot <ikorot01@gmail.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
differentextended capabilities.  For instance, psql and its variables feature. 

It looks like your answer contradicts with Ron...

Thank you.

>
> David J.
>



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Re: How to write such a query?
Next
From: Ron
Date:
Subject: Re: How to write such a query?