Re: Need help on a troublesome query plan - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Need help on a troublesome query plan
Date
Msg-id 20020716132924.X52161-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Need help on a troublesome query plan  ("Alain Lavigne" <alavigne@zaq.com>)
List pgsql-sql
On Tue, 16 Jul 2002, Alain Lavigne wrote:

> Thanks that worked, but why does that happen or maybe you could point
> to the proper thread so I read up on it.

It's an issue that the numeric constant gets cast to int4 somewhat
prematurely.  I don't have a pointer to a thread off hand, but if you
search the archives you should find a couple.




pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Indexing UNIONs
Next
From: Josh Berkus
Date:
Subject: Re: datatype matrix (was: Re: Sorry..)