I am attempting to use a variable in the WHERE clause of a SELECT
statement.
How would one pass a value for an IN statement, ie.
SELECT *
FROM inventory
WHERE color IN ('red','green')
If I replaced the last line with
WHERE color IN (v_color)
How would I set it?
v_color := '"red","green"'
doesn't work.
