Postgres Pro
Downloads
Home   >   mailing lists

Re: Array comparison - Mailing list pgsql-performance

From Rui Carvalho
Subject Re: Array comparison
Date
Msg-id 4cb7e1b21001080806o443d6e2bxbccc2f6b820395d3@mail.gmail.com
Whole thread Raw
In response to Array comparison  ("ramasubramanian" <ramasubramanian.g@renaissance-it.com>)
Responses Re: Array comparison
List pgsql-performance
Tree view
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@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
 

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Massive table (500M rows) update nightmare
Next
From: Merlin Moncure
Date:
Subject: Re: Array comparison