Contents

/* Fake CRC32 */

CREATE FUNCTION crc32(text)
RETURNS bigint AS $$
  DECLARE
    tmp bigint;
  BEGIN
    tmp = (hex_to_int(SUBSTRING(MD5($1) FROM 1 FOR 8))::bigint);
    IF tmp < 0 THEN
      tmp = 4294967296 + tmp;
    END IF;
    return tmp;
  END
$$ IMMUTABLE STRICT LANGUAGE plpgsql;

Version data entries

3 entries across 3 versions & 2 rubygems

Version	Path
pager-ultrasphinx-1.0.20080510	lib/ultrasphinx/postgresql/crc32.sql
pager-ultrasphinx-1.0.20080514	lib/ultrasphinx/postgresql/crc32.sql
ultrasphinx-1.11	lib/ultrasphinx/postgresql/crc32.sql