On Wed, Jun 09, 2021 at 05:30:15AM -0500, Hassan Camacho Cadre wrote: > 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
I guess you migrated to a whole new environment, with many new package versions, not just postgres ? We don't know how you're issuing queries, but I'm guessing some other application is what changed. Postgres uses $1 for query parameters, in both v8.3 and in v11. https://www.postgresql.org/docs/8.3/libpq-exec.html BTW, this is the list for development of postgres itself. It's much too busy to also answer other questions. Please raise the question on the -general list, with information about your environment. https://www.postgresql.org/list/ Thanks, -- Justin > 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.
