Re: Desirability of client-side expressions in psql? - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: Desirability of client-side expressions in psql?
Date
Msg-id alpine.DEB.2.21.1806241602570.1087@lancre
Whole thread Raw
In response to Re: Desirability of client-side expressions in psql?  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Desirability of client-side expressions in psql?
List pgsql-hackers
Hello Pavel,

>>> This is a discussion without actual patch intended for pg12, to be added
>>> to CF 2018-09. The expected end result is either "returned with feedback",
>>> meaning proceed to send some big patch(es), or "rejected", meaning the
>>> project does not want this, no point in submitting something.
>
> please, can you port expression evaluation from pgbench to psql? I miss a
> patch.

Indeed, I have not done it yet:-)

This is a pretty large series of patches, which would take a significant 
time for developing (me), rewiewing (not me) and committing (with overload 
committers). I would not like to end in the "we do not want this feature 
at all" state *after* the time has been spent, hence this pre-patch call 
for discussion about the feature itself, before diving into coding.

I take note that you are interested in actually having this feature.

> I am sure so psql expression evaluation has strong benefit - mainly for
> expressions like
>
> \if SERVER_VERSION_NUM >= xxxx
>  ...
> \endif

Note that this can already be done by relying on server-side expressions:

  SELECT :SERVER_VERSION_NUM >= 110000 AS "version_11_plus" \gset
  \if :version_11_plus
    ...
  \endif

Not very elegant, but functional. I'm not sure there is a compelling 
reason to have this feature beyond elegance.

-- 
Fabien.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Invisible Indexes
Next
From: Pavel Stehule
Date:
Subject: Re: Desirability of client-side expressions in psql?