public inbox for [email protected]
help / color / mirror / Atom feedFrom: Campbell, Lance <[email protected]>
To: [email protected] <[email protected]>
Subject: SQL issue after migrating from version 13 to 15
Date: Mon, 23 Oct 2023 15:19:35 +0000
Message-ID: <SJ0PR11MB562987A3390C885A8916E95ADED8A@SJ0PR11MB5629.namprd11.prod.outlook.com> (raw)
We migrated our PostgreSQL database from version 13 to 15. Absolutely no coding changes were made to our software.
table_column is a column in a table of type tsvector
The below segment of the where clause works fine if the value passed is a single value like "real":
AND to_tsvector('simple', CAST (table_column as text)) @@ to_tsquery('simple', 'real')
However, this no longer works when there are two values "real,impact". The only change was migrating from PostgreSQL 13 to 15:
AND to_tsvector('simple', CAST (table_column as text)) @@ to_tsquery('simple', 'real,impact')
No exception is being thrown.
Thanks for your help with this.
Lance Campbell
University of Illinois
view thread (3+ messages) latest in thread
reply
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: SQL issue after migrating from version 13 to 15
In-Reply-To: <SJ0PR11MB562987A3390C885A8916E95ADED8A@SJ0PR11MB5629.namprd11.prod.outlook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox