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:
CREATE DOMAIN int_unsigned
CONSTRAINT int_unsigned_check CHECK ((VALUE >= 0));
Why do queries cast between integer and int_unsigned?
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2009-08-29 17:44:08|
|Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int |
|Previous:||From: Bruce Momjian||Date: 2009-08-29 15:16:03|
|Subject: Re: PostgreSQL does CAST implicitely between int
and a domain derived from int|