Undocumented functions

From: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Undocumented functions
Date: 2024-09-07 18:58:00
Message-ID: CAB-JLwaxe2WuyuKVjUz_puTWsXQOF7EwW-6+Yjf=hYv2=iVc6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 are not documented ? Why ?
Then if I get all functions from pg_catalog
select string_agg(distinct format('"%s"',proname),',') from pg_proc where
pronamespace::regnamespace::text = 'pg_catalog'

using PowerShell declare a variable, on the SGML folder I use ...

$vv = (result of that select)
foreach ($v in $vv) {if (!((Get-Content . | %{$_ -match $v}) -contains
$true)) {
Write-Host $v}}

I'll get all functions which are on pg_catalog but not on SGML files, so
are not documented.

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 ?
select elem_contained_by_range(2,'[1,3]'::int4range);

And what other functions are cool to use but are not documented ?

regards
Marcos

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2024-09-07 19:51:44 Re: Undocumented functions
Previous Message Maciek Sakrejda 2024-09-07 18:57:00 Re: [PATCH] Add roman support for to_number function