Using string variables in Select statements

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. Received on Thu May 01 2008 - 10:07:03 CDT