Re: How to write such a query?

On 1/6/22 1:07 AM, Igor Korot wrote:
> 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...

TIMTOWTDI

--
Angular momentum makes the world go 'round.