| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | tango ward <tangoward15(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Insert data if it is not existing |
| Date: | 2018-05-24 04:39:12 |
| Message-ID: | CAKFQuwZmEWd7A6n0pbKRFm2XPPUOFeM9qVUphs_P8FwhNDwarQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday, May 23, 2018, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
>> '''INSERT INTO my_table(name, age)
>> SELECT %s, %s
>> WHERE NOT EXISTS(SELECT name FROM my_table WHERE name=%s)''', ('Scott',
>> 23)
>>
>>
> I doubt that worked, you have three parameter markers(%s) and two
> parameter values. Not only that two of the markers are for identifiers.
>
>
The count is indeed off but the two markers after the main select are
literals, not identifiers. As is the one being compared to name.
SELECT 'Scott', 23;
is a valid query.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrey Borodin | 2018-05-24 06:30:05 | Re: Error on vacuum: xmin before relfrozenxid |
| Previous Message | Adrian Klaver | 2018-05-24 04:11:48 | Re: Insert data if it is not existing |