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

From Tom Lane
Subject Re: Cannot find hstore operator
Date
Msg-id 1585432.1642951326@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cannot find hstore operator  (Paul van der Linden <paul.doskabouter@gmail.com>)
Responses Re: Cannot find hstore operator  (Paul van der Linden <paul.doskabouter@gmail.com>)
Re: Cannot find hstore operator  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
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: "David G. Johnston"
Date:
Subject: Re: Cannot find hstore operator
Next
From: Paul van der Linden
Date:
Subject: Re: Cannot find hstore operator