From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: How to write such a query? |
Date: | 2022-01-06 07:00:53 |
Message-ID: | 489abaea-2a4b-8137-3366-ec6228656242@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 1/6/22 12:39 AM, Igor Korot 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?
Absolutely. Of course, the exact method depends on the client. Are you
referring to psql?
If so, then here's an example:
$ psql12 -v S=456789012 test
psql (12.8 (Ubuntu 12.8-1.pgdg18.04+1))
Type "help" for help.
test=# select * from employee where ssn = :'S';
ssn | name | ssn_int
-----------+-----------------+-----------
456789012 | Fred Flintstone | 456789012
(1 row)
In this case, column ssn is of type varchar(9).
--
Angular momentum makes the world go 'round.
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2022-01-06 07:06:31 | Re: How to write such a query? |
Previous Message | Amul Sul | 2022-01-06 06:46:16 | Re: How to write such a query? |