Mathematical Functions and Operators

Em qua., 9 de out. de 2024 às 16:16, Marcos Pegoraro <marcos@f10.com.br>
escreveu:

Exponentiation, Square root and Cube root operators are not formatted with
<replaceable> tag like others.

Paying more attention, there is no standard on any of those Comparison,
String, Math, Date/Time and so on functions and operators tables. What
format should it be ?
Only datatypes should use <replaceable> ?
Shouldn't function names use <replaceable> too ?

regards
marcos

On Wednesday, October 9, 2024, Marcos Pegoraro <marcos@f10.com.br> wrote:

Shouldn't function names use <replaceable> too ?

Replaceable means the user is expected to substitute an expression in that
location. One cannot specify a function name using an expression.

David J.

Em qua., 9 de out. de 2024 às 18:23, David G. Johnston <
david.g.johnston@gmail.com> escreveu:

Replaceable means the user is expected to substitute an expression in that
location. One cannot specify a function name using an expression.

Sorry, I thought function parameters but said names. So, function params
should have <replaceable> too ?
If you see JSON functions there are functions that their params have
<replaceable> tag

json_array ( [ *query_expression* ] [ RETURNING *data_type* [ FORMAT
JSON [ ENCODING
UTF8 ] ] ])
json_scalar ( *expression* )
json_serialize ( *expression* [ FORMAT JSON [ ENCODING UTF8 ] ] [ RETURNING
*data_type* [ FORMAT JSON [ ENCODING UTF8 ] ] ] )

they are fine, but a lot of others don't

to_json ( anyelement ) → json
json_object ( text[] ) → json

regars
Marcos