Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jean-Michel Pouré <jm(at)poure(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Date: 2009-08-29 15:16:03
Message-ID: 200908291516.n7TFG3L18260@momjian.us (view raw or flat)
Thread:
Lists: pgsql-performance
Jean-Michel Pour wrote:
-- Start of PGP signed section.
> Le jeudi 27 ao?t 2009 ? 14:05 -0400, Tom Lane a ?crit :
> > tom lane
> 
> Dear Tom, 
> 
> Why is the query planner displaying ::integer
> What does it mean?

::integer casts a data type to INTEGER.  It is the same as CAST().

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-performance by date

Next:From: Jean-Michel PouréDate: 2009-08-29 17:38:41
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Previous:From: Scott MarloweDate: 2009-08-29 13:59:33
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group