Re: How to write such a query?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Igor Korot <ikorot01(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:00:53
Message-ID: CAKFQuwZEMUZJ55rFR=8UB-AzHccEPGUin6QjtgnWb3B4dXbVmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2022-01-06 07:06:31 Re: How to write such a query?
Previous Message Amul Sul 2022-01-06 06:46:16 Re: How to write such a query?