Re: Array comparison

[Rui Carvalho <rui.hmcarvalho@xxxxxxxxx>]

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 <ramasubramanian.g@xxxxxxxxxxxxxxxxxx> 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