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: | Whole Thread | Raw Message | 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
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 |