Inconsistency with LIKE and SIMILAR TO

From: Rosiński Krzysztof 2 - Detal TP <Krzysztof(dot)Rosinski2(at)telekomunikacja(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Inconsistency with LIKE and SIMILAR TO
Date: 2010-06-15 14:33:23
Message-ID: 49857FC121242345B2EFF3AAE4DA1B8E013AD608@OPEXCN10.tp.gk.corp.tepenet
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

Operators LIKE and SIMILAR TO work differently
This query works ok.:

SELECT *
FROM www.test
WHERE expr like any (ARRAY['a','b']);

But this not work:

SELECT *
FROM www.test
WHERE expr similar to any (ARRAY['a','b']);

ERROR: syntax error at or near "any"
LINE 3: WHERE expr similar to any (ARRAY['a','b']);

Is this shouldn't works ?

pasman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-06-15 14:43:45 Re: Inconsistency with LIKE and SIMILAR TO
Previous Message Bruce Momjian 2010-06-15 14:26:08 Re: Does enterprisedb.com down?