Hi well it's pretty simple
if you want to see if there are elements in common then instead of "any" use "&&" if you want to see if they are equal just use " = " that will five you true or false you can check array functions in here http://www.postgresql.org/docs/8.2/static/functions-array.html On Fri, Jan 8, 2010 at 5:00 AM, ramasubramanian < ramasubramania...@renaissance-it.com> wrote: > Hi all, > I want to compare the two arrys in sql, The below example is wrong. > But i want to know how to do that in postgres 8.2.5 > > SELECT 'x' WHERE string_to_array('the,quick,ram,fox', ',') any > (string_to_array('the,quick,lazy ,fox', ',')) > Regards, > Ram > > > >
