Thread: Re: 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 ?
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 ) → jsonjson_object ( text[] ) → json
regarsMarcos