From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(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 07:06:31 |
Message-ID: | CA+FnnTyOxFyXWRh2rdqO_jybnyTdXrmpq2dHskoe7ZdBVfA5Cg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, Ron,
On Thu, Jan 6, 2022 at 1:01 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>
> 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).
Is the syntax available since 9.0+? Or later?
I'm writing C++.
Thank you.
>
> --
> Angular momentum makes the world go 'round.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Korot | 2022-01-06 07:07:56 | Re: How to write such a query? |
Previous Message | David G. Johnston | 2022-01-06 07:00:53 | Re: How to write such a query? |