Re: BUG #14205: Weird cast long int values to numeric leading to seq scan - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14205: Weird cast long int values to numeric leading to seq scan
Date
Msg-id 10149.1466520580@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14205: Weird cast long int values to numeric leading to seq scan  (maxim.boguk@gmail.com)
List pgsql-bugs
maxim.boguk@gmail.com writes:
> If an input value of the field=value goes over bigint range, the database
> switches to the field::numeric=value::numeric plan, which leads to the seq
> scan as result.

This is not a bug.  If you want to force inputs to be bigint, try using a
cast.

            regards, tom lane

pgsql-bugs by date:

Previous
From: maxim.boguk@gmail.com
Date:
Subject: BUG #14205: Weird cast long int values to numeric leading to seq scan
Next
From: Stephen Thomas
Date:
Subject: Re: BUG #14203: pgindent requires pg_bsd_indent 1.2, but only 1.3 available for download