How to pass a parameter in a query to postgreSQL 11

From: Hassan Camacho Cadre <hccadre(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: How to pass a parameter in a query to postgreSQL 11
Date: 2021-06-09 10:30:15
Message-ID: CAK=f0zmA+AXYA==WTH9p7K4jg7PckVU1wTRrOAHS9PcrdvcdRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

I recently migrated from version 8.3 of postgreSQL to v11, previously in
all my queries for passing parameters I used the character :

Example
Where id =: searched

In the new version when I try to make this query it sends me an error

ERROR syntax error at or near ":"

Could someone help me to know how I can configure the parameter passing
character or, failing that, how I should pass the parameters in this new
version.

Greetings

--
Atentamente Msc. Hassan Camacho.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2021-06-09 10:30:17 Re: postgres_fdw batching vs. (re)creating the tuple slots
Previous Message Tomas Vondra 2021-06-09 10:23:45 Re: Fdw batch insert error out when set batch_size > 65535