Re: Cannot find hstore operator - Mailing list pgsql-general

From Paul van der Linden
Subject Re: Cannot find hstore operator
Date
Msg-id CAEC-EqDzHDqd6T1NDKTHMYo23MQPYBBQZ=p8CZx-fGBeF1+Wcg@mail.gmail.com
Whole thread Raw
In response to Re: Cannot find hstore operator  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Thanks, works perfectly!

On Sun, Jan 23, 2022 at 4:22 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Paul van der Linden <paul.doskabouter@gmail.com> writes:
> Thanks for the clarification, but giving up performance is a no-go for us.
> Also I have my concerns about shemaqualifying each and every use of the ->
> operator, there are really a lot of them in my functions and it would
> severely impact readability.
> Are these the only 2 solutions possible?

As of v14 you could use SQL-style function definitions, so that the
operator is parsed at function definition time instead of runtime.

                        regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot find hstore operator
Next
From: Dominique Devienne
Date:
Subject: Re: Cannot find hstore operator