Jean-Michel =?ISO-8859-1?Q?Pour=E9?= <jm@xxxxxxxxx> writes: > In Drupal database, we have two types: > CREATE DOMAIN int_unsigned > AS integer > CONSTRAINT int_unsigned_check CHECK ((VALUE >= 0)); > Why do queries cast between integer and int_unsigned? That domain doesn't have any operators of its own. To compare to another value, or use an index, you have to cast it to integer which does have operators. It's a no-op cast, but logically necessary. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
