Thread: Re: Mathematical Functions and Operators

Re: Mathematical Functions and Operators

From
Marcos Pegoraro
Date:
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 

Re: Mathematical Functions and Operators

From
"David G. Johnston"
Date:
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. 

Re: Mathematical Functions and Operators

From
Marcos Pegoraro
Date:
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