Array comparison

From: "ramasubramanian" <ramasubramanian(dot)g(at)renaissance-it(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Array comparison
Date: 2010-01-08 05:00:50
Message-ID: 10E4D065260941509531A32BDC0AB647@ramasubramanian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Carlo Stonebanks 2010-01-08 06:02:25 Re: Massive table (500M rows) update nightmare
Previous Message Craig Ringer 2010-01-08 03:45:00 Re: Air-traffic benchmark