... or not (I'm not quite sure)
Hello,
I have the following tables:
CREATE TABLE orders (info text, ....);
CREATE TABLE keywords (phrase text, .....);
And I need to find all the ORDERS rows, which conain a PHRASE present in
the info column ... like so:
SELECT o.* from orders o join keywords k on (o.info ~~ '%' || k.phrase
|| '%');
... only this does not work, since:
ERROR: argument of JOIN/ON must be type boolean, not type text
is this possible in SQL? Or may be this a job for "ts_something()"
(havent' learned to use them, yet)???
-R
