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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Le samedi 29 août 2009 à 11:16 -0400, Bruce Momjian a écrit :
> > Why is the query planner displaying ::integer
> > What does it mean?
> 
> ::integer casts a data type to INTEGER.  It is the same as CAST().

In Drupal database, we have two types:

integer
int_unsigned

CREATE DOMAIN int_unsigned
  AS integer
CONSTRAINT int_unsigned_check CHECK ((VALUE >= 0));

Why do queries cast between integer and int_unsigned?

Kind regards,
Jean-Michel

Attachment: signature.asc
Description: Ceci est une partie de message =?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e?=


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux