> Could we see the complete context for this? Sure. dealermade=# CREATE OR REPLACE TEMP VIEW chrome_vinmatch_best_match AS dealermade-# SELECT DISTINCT ON (v.vin) v.vin, vd.* dealermade-# FROM inventory.view_in_stock_vehicles AS v dealermade-# JOIN chrome_vinmatch.view_vin_decode AS vd dealermade-# ON substring(v.vin FROM 0 FOR 9) = substring(vd.pattern FROM 0 FOR 9) dealermade-# AND v.vin LIKE vd.pattern dealermade-# ORDER BY vin, length(pattern) DESC dealermade-# ; ERROR: no collation was derived for column "vin" with collatable type citext HINT: Use the COLLATE clause to set the collation explicitly. v.vin is the column with the custom DOMAIN. -- Evan Carroll - me@xxxxxxxxxxxxxxx System Lord of the Internets web: http://www.evancarroll.com ph: 281.901.0011 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
