From: Andreas Joseph Krogh <andreas@visena.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Evgeniy Shishkin <itparanoia@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Searching GIN-index (FTS) and sort by timestamp-column
Date: Thu, 17 Mar 2016 18:30:12 +0100 (CET)
Message-ID: <VisenaEmail.ea.7101c678aa3b84c3.153859f7473@tc7-visena> (raw)
In-Reply-To: <2279.1458235223@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
På torsdag 17. mars 2016 kl. 18:20:23, skrev Tom Lane <tgl@sss.pgh.pa.us
<mailto:tgl@sss.pgh.pa.us>>:
Evgeniy Shishkin <itparanoia@gmail.com> writes:
> Uh, it works if i cast to bigint explicitly
FWIW, the reason for that is that the int8_ops operator class that
btree_gin creates doesn't contain any cross-type operators. Probably
wouldn't be that hard to fix if somebody wanted to put in the work.
regards, tom lane
Thanks for info.
Can you explain why it works when using prepared statement without casting?
Does the machinary then know the type so the "setParameter"-call uses the
correct type?
Thanks.
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@visena.com <mailto:andreas@visena.com>
www.visena.com <https://www.visena.com;
<https://www.visena.com;
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andreas@visena.com, tgl@sss.pgh.pa.us, itparanoia@gmail.com
Subject: Re: Searching GIN-index (FTS) and sort by timestamp-column
In-Reply-To: <VisenaEmail.ea.7101c678aa3b84c3.153859f7473@tc7-visena>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox