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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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