Re: Undocumented functions

2024-09-09 Thread Marcos Pegoraro
Em sáb., 7 de set. de 2024 às 17:18, Tom Lane escreveu Functions that are primarily meant to implement operators are normally not documented separately: we feel it would bloat the docs without adding a lot Those two functions, elem_contained_by_range and pg_relation_is_updatable were only example

Re: Undocumented functions

2024-09-07 Thread Tom Lane
Marcos Pegoraro writes: > Example, elem_contained_by_range is not documented. I know I can use > select 2 <@ '[1,3]'::int4range > But why is that function not documented ? Functions that are primarily meant to implement operators are normally not documented separately: we feel it would bloat the

Re: Undocumented functions

2024-09-07 Thread Pavel Stehule
select elem_contained_by_range(2,'[1,3]'::int4range); > > And what other functions are cool to use but are not documented ? > there are lot of useful undocumented functions - see queries from https://github.com/postgres/postgres/blob/master/src/bin/psql/describe.c I see the mai

Undocumented functions

2024-09-07 Thread Marcos Pegoraro
Some days ago Tom Lane said ... SELECT events & 4 != 0 AS can_upd, events & 8 != 0 AS can_ins, events & 16 != 0 AS can_del FROM pg_catalog.pg_relation_is_updatable('_pessoa'::regclass, false) t(events); Well, I didn't find that function on DOCs and then I thought, are there other functions which