Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL does CAST implicitely between int and a domain derived from int - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: PostgreSQL does CAST implicitely between int and a domain derived from int
Date
Msg-id 200908291516.n7TFG3L18260@momjian.us
Whole thread Raw
In response to Re: PostgreSQL does CAST implicitely between int and a domain derived from int  (Jean-Michel Pouré <jm@poure.com>)
Responses Re: PostgreSQL does CAST implicitely between int and a domain derived from int
List pgsql-performance
Tree view 
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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: What exactly is postgres doing during INSERT/UPDATE ?
Next
From: Jean-Michel Pouré
Date:
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int