Postgres Pro
Downloads
Home   >   mailing lists

Re: Searching GIN-index (FTS) and sort by timestamp-column - Mailing list pgsql-performance

From Andreas Joseph Krogh
Subject Re: Searching GIN-index (FTS) and sort by timestamp-column
Date
Msg-id VisenaEmail.ea.7101c678aa3b84c3.153859f7473@tc7-visena
Whole thread Raw
In response to Re: Searching GIN-index (FTS) and sort by timestamp-column  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Searching GIN-index (FTS) and sort by timestamp-column
List pgsql-performance
Tree view
På torsdag 17. mars 2016 kl. 18:20:23, skrev Tom Lane <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
 
Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Searching GIN-index (FTS) and sort by timestamp-column
Next
From: Tom Lane
Date:
Subject: Re: Searching GIN-index (FTS) and sort by timestamp-column