Re: Problem with text_pattern_ops

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with text_pattern_ops
Date: 2005-07-26 23:50:26
Message-ID: 42E6CC42.3060400@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephan Szabo wrote:

> It is for the operators ~<~, ~<=~, ~=~, ~>=~, ~>~ (for like optimization).
> The docs seem to say that it does a character by character comparison
> rather than one using the collation thus being better for pattern
> matching. I'd think letting it do <, <=, =, >=, > would have it giving the
> wrong results for such queries (well, in non-C locales).

Well maybe queries of > < shouldn't be allowed because they would return
the wrong results, but surely equals is equals.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message DracKewl 2005-07-27 00:46:27 Re: Select Stament Issue??
Previous Message Roman Neuhauser 2005-07-26 23:21:56 Re: Rules vs Triggers