Is it possible to build a psql query using param placeholders i.e. "SELECT * from issues WHERE state=$1;" ?
e.g. `PREPARE myquery AS SELECT * FROM issues WHERE state = $1; EXECUTE myquery('TX')`
-
-
thanks! will this work with EXPLAIN and friends?
-
The SELECT part will. EXPLAIN has the “Planning” and “Execution” times. Planning is covered by PREPARE, so EXECUTE should be Execution time.
- 5 more replies
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.