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

Jean-Michel Pouré 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 in English (I am French, pardon my English). I will update table definition in 5 minutes. see cheers

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

Jean-Michel Pouré 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 in English (I am French, pardon my English). “no-op” means “an operation which does nothing”. -- Alvaro Herrera

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

Jean-Michel Pouré 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 a

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

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 in English (I am French, pardon my English). I will update table definition in 5 minutes. Stay tuned. Kind regards, Jean-Michel signature.asc Description: Ceci est une parti

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

Jean-Michel =?ISO-8859-1?Q?Pour=E9?= writes: > Analysing slow queries, I noticed that PostgreSQL 8.4 would cast data > from int4 to int_unsigned. > Details and query plan: http://drupal.org/node/559986 > Some queries range between 400ms and 700ms. I see no reason whatever to think that that doma

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

Jean-Michel Pouré wrote: Dear friends, Thank you for your previous answers. I am running into a systemic problem using Drupal under PostgreSQL 8.4 Drupal relies heavily on a domain derived from int: CREATE DOMAIN int_unsigned AS integer CONSTRAINT int_unsigned_check CHECK ((VALUE >= 0))

[HACKERS] PostgreSQL does CAST implicitely between int and a domain derived from int during SELECT query

Dear friends, Thank you for your previous answers. I am running into a systemic problem using Drupal under PostgreSQL 8.4 Drupal relies heavily on a domain derived from int: CREATE DOMAIN int_unsigned AS integer CONSTRAINT int_unsigned_check CHECK ((VALUE >= 0)); Analysing slow queries, I