On Wed, Jan 18, 2017 at 3:15 PM, Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> Is this expected behavior ?
>
> ts=# SELECT * FROM t WHERE site_id=32768 LIMIT 1;
> (0 rows)
>
> ts=# PREPARE x AS SELECT * FROM t WHERE site_id=$1 LIMIT 1;
> PREPARE
> ts=# EXECUTE x(32768);
> ERROR: smallint out of range
>
Probably. If you show the definition of "t", or at least "t.site_id",
that can be confirmed.
And, IMO, this question is more in line with the purpose of the -general
list.
David J.