Hi, Armul, On Thu, Jan 6, 2022 at 12:46 AM Amul Sul <sulamul@xxxxxxxxx> wrote: > > See prepare statement : https://www.postgresql.org/docs/current/sql-prepare.html The documentation is talking about a way to do it like: SELECT a, b, c FROM foo WHERE id = $1, which is equivalent to the SELECT a, b, c FROM foo WHERE id = ?; i.e. using unnamed parameter. Thank you. > > On Thu, Jan 6, 2022 at 12:10 PM Igor Korot <ikorot01@xxxxxxxxx> 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. > > > >
