BloGroonga

2024-07-04

PGroonga (fast full text search module for PostgreSQL) 3.2.1 has been released

PGroonga 3.2.1 has been released! PGroonga makes PostgreSQL fast full text search for all languages.

Improvements

Fixes

  • [&@~ operator] Fixed a crash bug with multiple conditions including blank only query condition.

    An error will occur if any of the multiple conditions have a blank space condition as below.

      CREATE TABLE memos (
    id integer,
    content text
  );
  INSERT INTO memos VALUES (1, 'PostgreSQL is a RDBMS.');
  INSERT INTO memos VALUES (2, 'Groonga is fast full text search engine.');
  INSERT INTO memos VALUES (3, 'PGroonga is a PostgreSQL extension that uses Groonga.');
  CREATE INDEX grnindex ON memos USING pgroonga (content);
  SELECT id, content
    FROM memos
   WHERE content &@~ pgroonga_condition('PGroonga') AND
         content &@~ pgroonga_condition(' ');

How to upgrade

If you're using PGroonga 2.0.0 or later, you can upgrade by steps in "Compatible case" in Upgrade document.

If you're using PGroonga 1.Y.Z, you can upgrade by steps in "Incompatible case" in Upgrade document.

Support service

If you need commercial support for PGroonga, contact us.

Conclusion

Try PGroonga when you want to perform fast full text search against all languages on PostgreSQL!