Re: How to write such a query?

From: Dmitry Igrishin <dmitigr(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 08:17:07
Message-ID: CAAfz9KP2oBZDBPX4BNM554AdQvHi2C_K_5135+Ex7474sqdGGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 6, 2022, 09:40 Igor Korot <ikorot01(at)gmail(dot)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?
>
Named parameters of prepared statements are implemented in my C++ library
Pgfe.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2022-01-06 08:20:27 Re: md5 issues Postgres14 on OL7
Previous Message Ron 2022-01-06 07:14:36 Re: How to write such a query?