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

From Amul Sul
Subject Re: How to write such a query?
Date
Msg-id CAAJ_b95B-6McpV8OjfreEnqUCirP-Yp4hyXx617f=fokbmQBsQ@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?  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
See prepare statement : https://www.postgresql.org/docs/current/sql-prepare.html

On Thu, Jan 6, 2022 at 12:10 PM Igor Korot <ikorot01@gmail.com> wrote:
>
> Hi, ALL,
> In SQLite you can write:
>
> SELECT a, b, c FROM foo WHERE id = :id;
>
> where ":id" is the named parameter.
>
> The query above is similar to
>
> SELECT a,b,c FROM foo WHERE id = ?;
>
> except that the parameter has a name.
>
> Is there a way to write such a SELECT statement with the
> named parameter in PostgreSQL?
>
> Thank you.
>
>



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: How to write such a query?
Next
From: "David G. Johnston"
Date:
Subject: Re: How to write such a query?