unable to use parameters in POSTGRES sql statements Follow
Answered
Given this:
SELECT a, b
FROM p
WHERE (:param IS NULL OR p.a like :param)
Parameters don't seem to work at all.
ERROR Column (paramter value) does not exist?
Why is datagrip using textual replacements instead of actual parameters. I keep having to comment out the parameters all the time.
Please sign in to leave a comment.
Could you provide a screenshot of your "Database -> User Parameters" settings?
E.g.:
In your case, DG invokes parameter substitution popup:
