PostgreSQL equivalent of Oracle "member of"

[Vadi]

Hi all



I would like to know if there is any equivalent in PostgreSQL for the Oracle 
"member of" syntax.



The usage is as shown below:



I have used the Oracle sample HR schema for the below example:



CREATE OR REPLACE TYPE params as table of varchar2 (100);

/



CREATE OR REPLACE function in_list (in_list  in  varchar2) return params 
pipelined      as

            param_list  varchar2(4000) := in_list || ',';

            pos   number;

            begin

            loop

            pos := instr(param_list, ',');

            exit when nvl(pos, 0) = 0;

            pipe row (trim(substr(param_list, 1, pos - 1)));

            param_list := substr(param_list, pos + 1);

            end loop;



            return;

            end in_list;



/



CREATE TABLE tname as

SELECT listagg(first_name, ', ') within group (order by first_name) first_name 
FROM employees;



SELECT * FROM tname;



SELECT * FROM employees

WHERE first_name member of in_list(first_name);



Any help is much appreciated.



Thanks in advance.



Regards

Vadi