Re: Bug #441: Index using INT8 data type is ignored

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mauro-flores(at)procergs(dot)rs(dot)gov(dot)br, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #441: Index using INT8 data type is ignored
Date: 2001-09-07 17:08:15
Message-ID: 27734.999882495@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Try coercing your constants to int8 explicitly:

... WHERE int8col = 42::int8;

See the archives for more info about this.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2001-09-07 17:11:23 Re: [BUGS] pgsql/src/backend/utils/mb encnames.c
Previous Message Bruce Momjian 2001-09-07 17:02:56 Re: [BUGS] pgsql/src/backend/utils/mb encnames.c