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

From Igor Korot
Subject How to write such a query?
Date
Msg-id CA+FnnTzgQ3c75FE-eEPYVOa+F9N94jUpwW278ki_OeCJetovOA@mail.gmail.com
Whole thread Raw
Responses Re: How to write such a query?
Re: How to write such a query?
Re: How to write such a query?
Re: How to write such a query?
List pgsql-general
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: Adrian Klaver
Date:
Subject: Re: How best to create and use associative array type in Postgres?
Next
From: Amul Sul
Date:
Subject: Re: How to write such a query?