Postgres Pro
Downloads
Home   >   mailing lists

How to pass a parameter in a query to postgreSQL 11 - Mailing list pgsql-hackers

From Hassan Camacho Cadre
Subject How to pass a parameter in a query to postgreSQL 11
Date
Msg-id CAK=f0zmA+AXYA==WTH9p7K4jg7PckVU1wTRrOAHS9PcrdvcdRA@mail.gmail.com
Whole thread Raw
Responses Re: How to pass a parameter in a query to postgreSQL 11 (offtopic)
List pgsql-hackers
Tree view
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.

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Fdw batch insert error out when set batch_size > 65535
Next
From: Tomas Vondra
Date:
Subject: Re: postgres_fdw batching vs. (re)creating the tuple slots