Re: Simplifying Text Search - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Simplifying Text Search
Date
Msg-id 20071112203520.GB22963@alvh.no-ip.org
Whole thread Raw
In response to Re: Simplifying Text Search  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas wrote:

> Granted, @@ is a bit awkward until you get used to it. "x LIKE y" would 
> read out better, but unfortunately that's already taken ;-).

Actually LIKE does not make much sense when you have 'hay & needle'.
Probably MATCHES would be a better term ... but then, MySQL defines a
strange thing called MATCH/AGAINST; so apparently you use "MATCH (column
list) AGAINST (pattern spec)"

None of this is standard though ...

-- 
Alvaro Herrera                 http://www.amazon.com/gp/registry/CTMLCN8V17R4
"Everybody understands Mickey Mouse. Few understand Hermann Hesse.
Hardly anybody understands Einstein. And nobody understands Emperor Norton."


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Proposal: Select ... AS OF Savepoint
Next
From: Aidan Van Dyk
Date:
Subject: Re: Simplifying Text Search