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

From David G. Johnston
Subject Re: How to write such a query?
Date
Msg-id CAKFQuwZEMUZJ55rFR=8UB-AzHccEPGUin6QjtgnWb3B4dXbVmw@mail.gmail.com
Whole thread Raw
In response to How to write such a query?  (Igor Korot <ikorot01@gmail.com>)
Responses Re: How to write such a query?
List pgsql-general
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 different extended capabilities.  For instance, psql and its variables feature.

David J.

pgsql-general by date:

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