unable to use parameters in POSTGRES sql statements

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.

1 comment
Comment actions Permalink

Could you provide a screenshot of your "Database -> User Parameters" settings?

E.g.:

In your case, DG invokes parameter substitution popup:

0

Please sign in to leave a comment.