name[] = { JOHN , ALEX , TEST ,""} SQL : select name from table1 where 'TEST' = any (name) return: { JOHN , ALEX , TEST } in this sql command, how can i get the index of 'TEST' is 3 ? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general