database:functions:pears_hashtoiqxid



pears.hashToIqxId

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."hashToIqxId"( 
  IN "source" CHAR(255) ) 
RETURNS CHAR(20)
deterministic
BEGIN
  RETURN "upper"("left"("IQXDBID"+"hash"("source"),20))
END
  • database/functions/pears_hashtoiqxid.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1