Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query

Jean-Michel Pouré wrote:
> Dear friends,
>
> Thank you for your previous answers. I am running into a systemic
> problem using Drupal under PostgreSQL 8.4
>
> Drupal relies heavily on a domain derived from int:
>
> CREATE DOMAIN int_unsigned
>   AS integer
>    CONSTRAINT int_unsigned_check CHECK ((VALUE >= 0));
>
> Analysing slow queries, I noticed that PostgreSQL 8.4 would cast data
> from int4 to int_unsigned.
>
>
>   

Isn't that cast effectively a no-op?

cheers

andrew