Tatsuo Ishii <is...@postgresql.org> writes: > STATEMENT: SELECT msg_sid, hdr_from, hdr_to, hdr_subject, msg_date, > folder_id, msgnum FROM msginfo LEFT JOIN msg_folderinfo USING (msg_sid) WHERE > plainto_tsquery(E'a') @@ body_index > NOTICE: text-search query contains only stop words or doesn't contain > lexemes, ignored > ERROR: unrecognized operator: -50
I found the cause of this one --- the new code for estimating the selectivity of @@ was not guarding against the possibility that the given TSQuery is empty, as it is in this example. I'm still unable to reproduce the "tuple offset out of range" errors. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers