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

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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-hackers(at)postgresql(dot)org>, Jean-Michel Pouré <jm(at)poure(dot)com>
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query
Date: 2009-08-26 14:25:10
Message-ID: 4A94FF76020000250002A252@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackers
Jean-Michel Pouré<jm(at)poure(dot)com> wrote:
>Le mercredi 26 août 2009 à 10:07 -0400, Andrew Dunstan a écrit :
>> 
>> Isn't that cast effectively a no-op?
> 
> What is no-op 
 
It's short for "no operation" -- meaning it doesn't really result in
anything being done.  You are probably way off base in your
assumptions about why these queries aren't running faster, but have
not provided enough information to determine the actual reason.
 
-Kevin

In response to

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2009-08-26 14:26:54
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query
Previous:From: Jean-Michel PouréDate: 2009-08-26 14:20:23
Subject: Re: PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query

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