[GENERAL] Positional parameters and question mark notation

2014-01-20 Thread Andreas Lubensky
Hi, Is there any way to make PostgreSQL support the question mark (?) notation instead of the dollar sign ($1, $2...) for prepared statements? Most databases use the question mark notation and we have a set of simple queries that are supposed to be portable across different database systems. So

Re: [GENERAL] Positional parameters and question mark notation

2014-01-20 Thread Dmitriy Igrishin
Hey Andreas, 2014/1/20 Andreas Lubensky luben...@cognitec.com Hi, Is there any way to make PostgreSQL support the question mark (?) notation instead of the dollar sign ($1, $2...) for prepared statements? Most databases use the question mark notation and we have a set of simple queries

Re: [GENERAL] Positional parameters and question mark notation

2014-01-20 Thread Andreas Lubensky
Hi Dmitriy, I considered just doing a string replacement, however this might be potentially dangerous because in theory a query might contain a question mark as part of a string or similar. Although I'm certain it would work for us at the moment, it looks like a problem waiting to happen. Doing a