Timeline for Viewing the statement in EXECUTE with USING
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 30, 2021 at 7:20 | comment | added | Laurenz Albe |
You could use replace as in my updated answer. If you want to do that in a generic fashion, you'll have to loop through the parameters, and you won't be able to retain the type information, so the resulting query might not be a runnable SQL statement.
|
|
| Jun 30, 2021 at 7:18 | history | edited | Laurenz Albe | CC BY-SA 4.0 |
added 207 characters in body
|
| Jun 30, 2021 at 7:11 | comment | added | bluk |
Thanks, I see it can print out the arguments. I wonder if there is any way to substitute the $1, $2 etc inside the EXECUTE statement and print it out though?
|
|
| Jun 30, 2021 at 6:50 | review | Low quality posts | |||
| Jun 30, 2021 at 7:25 | |||||
| Jun 30, 2021 at 6:27 | history | answered | Laurenz Albe | CC BY-SA 4.0 |