Debian Codegraph @

src/backend/catalog/system_functions.sql

raw
1 /*
2 * PostgreSQL System Functions
3 *
4 * Copyright (c) 1996-2025, PostgreSQL Global Development Group
5 *
6 * src/backend/catalog/system_functions.sql
7 *
8 * This file redefines certain built-in functions that are impractical
9 * to fully define in pg_proc.dat. In most cases that's because they use
10 * SQL-standard function bodies and/or default expressions. The node
11 * tree representations of those are too unreadable, platform-dependent,
12 * and changeable to want to deal with them manually. Hence, we put stub
13 * definitions of such functions into pg_proc.dat and then replace them
14 * here. The stub definitions would be unnecessary were it not that we'd
15 * like these functions to have stable OIDs, the same as other built-in
16 * functions.
17 *
18 * This file also takes care of adjusting privileges for those functions
19 * that should not have the default public-EXECUTE privileges. (However,
20 * a small number of functions that exist mainly to underlie system views
21 * are dealt with in system_views.sql, instead.)
22 *
23 * Note: this file is read in single-user -j mode, which means that the
24 * command terminator is semicolon-newline-newline; whenever the backend
25 * sees that, it stops and executes what it's got. If you write a lot of
26 * statements without empty lines between, they'll all get quoted to you
27 * in any error message about one of them, so don't do that. Also, you
28 * cannot write a semicolon immediately followed by an empty line in a
29 * string literal (including a function body!) or a multiline comment.
30 */
31
32
33 CREATE OR REPLACE FUNCTION lpad(text, integer)
34 RETURNS text
35 LANGUAGE sql
36 IMMUTABLE PARALLEL SAFE STRICT COST 1
37 RETURN lpad($1, $2, ' ');
38
39 CREATE OR REPLACE FUNCTION rpad(text, integer)
40 RETURNS text
41 LANGUAGE sql
42 IMMUTABLE PARALLEL SAFE STRICT COST 1
43 RETURN rpad($1, $2, ' ');
44
45 CREATE OR REPLACE FUNCTION "substring"(text, text, text)
46 RETURNS text
47 LANGUAGE sql
48 IMMUTABLE PARALLEL SAFE STRICT COST 1
49 RETURN substring($1, similar_to_escape($2, $3));
50
51 CREATE OR REPLACE FUNCTION bit_length(bit)
52 RETURNS integer
53 LANGUAGE sql
54 IMMUTABLE PARALLEL SAFE STRICT COST 1
55 RETURN length($1);
56
57 CREATE OR REPLACE FUNCTION bit_length(bytea)
58 RETURNS integer
59 LANGUAGE sql
60 IMMUTABLE PARALLEL SAFE STRICT COST 1
61 RETURN octet_length($1) * 8;
62
63 CREATE OR REPLACE FUNCTION bit_length(text)
64 RETURNS integer
65 LANGUAGE sql
66 IMMUTABLE PARALLEL SAFE STRICT COST 1
67 RETURN octet_length($1) * 8;
68
69 CREATE OR REPLACE FUNCTION
70 random_normal(mean float8 DEFAULT 0, stddev float8 DEFAULT 1)
71 RETURNS float8
72 LANGUAGE internal
73 VOLATILE PARALLEL RESTRICTED STRICT COST 1
74 AS 'drandom_normal';
75
76 CREATE OR REPLACE FUNCTION log(numeric)
77 RETURNS numeric
78 LANGUAGE sql
79 IMMUTABLE PARALLEL SAFE STRICT COST 1
80 RETURN log(10, $1);
81
82 CREATE OR REPLACE FUNCTION log10(numeric)
83 RETURNS numeric
84 LANGUAGE sql
85 IMMUTABLE PARALLEL SAFE STRICT COST 1
86 RETURN log(10, $1);
87
88 CREATE OR REPLACE FUNCTION round(numeric)
89 RETURNS numeric
90 LANGUAGE sql
91 IMMUTABLE PARALLEL SAFE STRICT COST 1
92 RETURN round($1, 0);
93
94 CREATE OR REPLACE FUNCTION trunc(numeric)
95 RETURNS numeric
96 LANGUAGE sql
97 IMMUTABLE PARALLEL SAFE STRICT COST 1
98 RETURN trunc($1, 0);
99
100 CREATE OR REPLACE FUNCTION numeric_pl_pg_lsn(numeric, pg_lsn)
101 RETURNS pg_lsn
102 LANGUAGE sql
103 IMMUTABLE PARALLEL SAFE STRICT COST 1
104 RETURN $2 + $1;
105
106 CREATE OR REPLACE FUNCTION path_contain_pt(path, point)
107 RETURNS boolean
108 LANGUAGE sql
109 IMMUTABLE PARALLEL SAFE STRICT COST 1
110 RETURN on_ppath($2, $1);
111
112 CREATE OR REPLACE FUNCTION polygon(circle)
113 RETURNS polygon
114 LANGUAGE sql
115 IMMUTABLE PARALLEL SAFE STRICT COST 1
116 RETURN polygon(12, $1);
117
118 CREATE OR REPLACE FUNCTION age(timestamptz)
119 RETURNS interval
120 LANGUAGE sql
121 STABLE PARALLEL SAFE STRICT COST 1
122 RETURN age(cast(current_date as timestamptz), $1);
123
124 CREATE OR REPLACE FUNCTION age(timestamp)
125 RETURNS interval
126 LANGUAGE sql
127 STABLE PARALLEL SAFE STRICT COST 1
128 RETURN age(cast(current_date as timestamp), $1);
129
130 CREATE OR REPLACE FUNCTION date_part(text, date)
131 RETURNS double precision
132 LANGUAGE sql
133 IMMUTABLE PARALLEL SAFE STRICT COST 1
134 RETURN date_part($1, cast($2 as timestamp));
135
136 CREATE OR REPLACE FUNCTION timestamptz(date, time)
137 RETURNS timestamptz
138 LANGUAGE sql
139 STABLE PARALLEL SAFE STRICT COST 1
140 RETURN cast(($1 + $2) as timestamptz);
141
142 CREATE OR REPLACE FUNCTION timedate_pl(time, date)
143 RETURNS timestamp
144 LANGUAGE sql
145 IMMUTABLE PARALLEL SAFE STRICT COST 1
146 RETURN $2 + $1;
147
148 CREATE OR REPLACE FUNCTION timetzdate_pl(timetz, date)
149 RETURNS timestamptz
150 LANGUAGE sql
151 IMMUTABLE PARALLEL SAFE STRICT COST 1
152 RETURN $2 + $1;
153
154 CREATE OR REPLACE FUNCTION interval_pl_time(interval, time)
155 RETURNS time
156 LANGUAGE sql
157 IMMUTABLE PARALLEL SAFE STRICT COST 1
158 RETURN $2 + $1;
159
160 CREATE OR REPLACE FUNCTION interval_pl_date(interval, date)
161 RETURNS timestamp
162 LANGUAGE sql
163 IMMUTABLE PARALLEL SAFE STRICT COST 1
164 RETURN $2 + $1;
165
166 CREATE OR REPLACE FUNCTION interval_pl_timetz(interval, timetz)
167 RETURNS timetz
168 LANGUAGE sql
169 IMMUTABLE PARALLEL SAFE STRICT COST 1
170 RETURN $2 + $1;
171
172 CREATE OR REPLACE FUNCTION interval_pl_timestamp(interval, timestamp)
173 RETURNS timestamp
174 LANGUAGE sql
175 IMMUTABLE PARALLEL SAFE STRICT COST 1
176 RETURN $2 + $1;
177
178 CREATE OR REPLACE FUNCTION interval_pl_timestamptz(interval, timestamptz)
179 RETURNS timestamptz
180 LANGUAGE sql
181 STABLE PARALLEL SAFE STRICT COST 1
182 RETURN $2 + $1;
183
184 CREATE OR REPLACE FUNCTION integer_pl_date(integer, date)
185 RETURNS date
186 LANGUAGE sql
187 IMMUTABLE PARALLEL SAFE STRICT COST 1
188 RETURN $2 + $1;
189
190 CREATE OR REPLACE FUNCTION "overlaps"(timestamptz, timestamptz,
191 timestamptz, interval)
192 RETURNS boolean
193 LANGUAGE sql
194 STABLE PARALLEL SAFE COST 1
195 RETURN ($1, $2) overlaps ($3, ($3 + $4));
196
197 CREATE OR REPLACE FUNCTION "overlaps"(timestamptz, interval,
198 timestamptz, interval)
199 RETURNS boolean
200 LANGUAGE sql
201 STABLE PARALLEL SAFE COST 1
202 RETURN ($1, ($1 + $2)) overlaps ($3, ($3 + $4));
203
204 CREATE OR REPLACE FUNCTION "overlaps"(timestamptz, interval,
205 timestamptz, timestamptz)
206 RETURNS boolean
207 LANGUAGE sql
208 STABLE PARALLEL SAFE COST 1
209 RETURN ($1, ($1 + $2)) overlaps ($3, $4);
210
211 CREATE OR REPLACE FUNCTION "overlaps"(timestamp, timestamp,
212 timestamp, interval)
213 RETURNS boolean
214 LANGUAGE sql
215 IMMUTABLE PARALLEL SAFE COST 1
216 RETURN ($1, $2) overlaps ($3, ($3 + $4));
217
218 CREATE OR REPLACE FUNCTION "overlaps"(timestamp, interval,
219 timestamp, timestamp)
220 RETURNS boolean
221 LANGUAGE sql
222 IMMUTABLE PARALLEL SAFE COST 1
223 RETURN ($1, ($1 + $2)) overlaps ($3, $4);
224
225 CREATE OR REPLACE FUNCTION "overlaps"(timestamp, interval,
226 timestamp, interval)
227 RETURNS boolean
228 LANGUAGE sql
229 IMMUTABLE PARALLEL SAFE COST 1
230 RETURN ($1, ($1 + $2)) overlaps ($3, ($3 + $4));
231
232 CREATE OR REPLACE FUNCTION "overlaps"(time, interval,
233 time, interval)
234 RETURNS boolean
235 LANGUAGE sql
236 IMMUTABLE PARALLEL SAFE COST 1
237 RETURN ($1, ($1 + $2)) overlaps ($3, ($3 + $4));
238
239 CREATE OR REPLACE FUNCTION "overlaps"(time, time,
240 time, interval)
241 RETURNS boolean
242 LANGUAGE sql
243 IMMUTABLE PARALLEL SAFE COST 1
244 RETURN ($1, $2) overlaps ($3, ($3 + $4));
245
246 CREATE OR REPLACE FUNCTION "overlaps"(time, interval,
247 time, time)
248 RETURNS boolean
249 LANGUAGE sql
250 IMMUTABLE PARALLEL SAFE COST 1
251 RETURN ($1, ($1 + $2)) overlaps ($3, $4);
252
253 CREATE OR REPLACE FUNCTION int8pl_inet(bigint, inet)
254 RETURNS inet
255 LANGUAGE sql
256 IMMUTABLE PARALLEL SAFE STRICT COST 1
257 RETURN $2 + $1;
258
259 CREATE OR REPLACE FUNCTION xpath(text, xml)
260 RETURNS xml[]
261 LANGUAGE sql
262 IMMUTABLE PARALLEL SAFE STRICT COST 1
263 RETURN xpath($1, $2, '{}'::text[]);
264
265 CREATE OR REPLACE FUNCTION xpath_exists(text, xml)
266 RETURNS boolean
267 LANGUAGE sql
268 IMMUTABLE PARALLEL SAFE STRICT COST 1
269 RETURN xpath_exists($1, $2, '{}'::text[]);
270
271 CREATE OR REPLACE FUNCTION pg_sleep_for(interval)
272 RETURNS void
273 LANGUAGE sql
274 PARALLEL SAFE STRICT COST 1
275 RETURN pg_sleep(extract(epoch from clock_timestamp() + $1) -
276 extract(epoch from clock_timestamp()));
277
278 CREATE OR REPLACE FUNCTION pg_sleep_until(timestamptz)
279 RETURNS void
280 LANGUAGE sql
281 PARALLEL SAFE STRICT COST 1
282 RETURN pg_sleep(extract(epoch from $1) -
283 extract(epoch from clock_timestamp()));
284
285 CREATE OR REPLACE FUNCTION pg_relation_size(regclass)
286 RETURNS bigint
287 LANGUAGE sql
288 PARALLEL SAFE STRICT COST 1
289 RETURN pg_relation_size($1, 'main');
290
291 CREATE OR REPLACE FUNCTION obj_description(oid, name)
292 RETURNS text
293 LANGUAGE sql
294 STABLE PARALLEL SAFE STRICT
295 BEGIN ATOMIC
296 select description from pg_description
297 where objoid = $1 and
298 classoid = (select oid from pg_class where relname = $2 and
299 relnamespace = 'pg_catalog'::regnamespace) and
300 objsubid = 0;
301 END;
302
303 CREATE OR REPLACE FUNCTION shobj_description(oid, name)
304 RETURNS text
305 LANGUAGE sql
306 STABLE PARALLEL SAFE STRICT
307 BEGIN ATOMIC
308 select description from pg_shdescription
309 where objoid = $1 and
310 classoid = (select oid from pg_class where relname = $2 and
311 relnamespace = 'pg_catalog'::regnamespace);
312 END;
313
314 CREATE OR REPLACE FUNCTION obj_description(oid)
315 RETURNS text
316 LANGUAGE sql
317 STABLE PARALLEL SAFE STRICT
318 BEGIN ATOMIC
319 select description from pg_description where objoid = $1 and objsubid = 0;
320 END;
321
322 CREATE OR REPLACE FUNCTION col_description(oid, integer)
323 RETURNS text
324 LANGUAGE sql
325 STABLE PARALLEL SAFE STRICT
326 BEGIN ATOMIC
327 select description from pg_description
328 where objoid = $1 and classoid = 'pg_class'::regclass and objsubid = $2;
329 END;
330
331 CREATE OR REPLACE FUNCTION ts_debug(config regconfig, document text,
332 OUT alias text,
333 OUT description text,
334 OUT token text,
335 OUT dictionaries regdictionary[],
336 OUT dictionary regdictionary,
337 OUT lexemes text[])
338 RETURNS SETOF record
339 LANGUAGE sql
340 STABLE PARALLEL SAFE STRICT
341 BEGIN ATOMIC
342 select
343 tt.alias AS alias,
344 tt.description AS description,
345 parse.token AS token,
346 ARRAY ( SELECT m.mapdict::regdictionary
347 FROM pg_ts_config_map AS m
348 WHERE m.mapcfg = $1 AND m.maptokentype = parse.tokid
349 ORDER BY m.mapseqno )
350 AS dictionaries,
351 ( SELECT mapdict::regdictionary
352 FROM pg_ts_config_map AS m
353 WHERE m.mapcfg = $1 AND m.maptokentype = parse.tokid
354 ORDER BY ts_lexize(mapdict, parse.token) IS NULL, m.mapseqno
355 LIMIT 1
356 ) AS dictionary,
357 ( SELECT ts_lexize(mapdict, parse.token)
358 FROM pg_ts_config_map AS m
359 WHERE m.mapcfg = $1 AND m.maptokentype = parse.tokid
360 ORDER BY ts_lexize(mapdict, parse.token) IS NULL, m.mapseqno
361 LIMIT 1
362 ) AS lexemes
363 FROM ts_parse(
364 (SELECT cfgparser FROM pg_ts_config WHERE oid = $1 ), $2
365 ) AS parse,
366 ts_token_type(
367 (SELECT cfgparser FROM pg_ts_config WHERE oid = $1 )
368 ) AS tt
369 WHERE tt.tokid = parse.tokid;
370 END;
371
372 CREATE OR REPLACE FUNCTION ts_debug(document text,
373 OUT alias text,
374 OUT description text,
375 OUT token text,
376 OUT dictionaries regdictionary[],
377 OUT dictionary regdictionary,
378 OUT lexemes text[])
379 RETURNS SETOF record
380 LANGUAGE sql
381 STABLE PARALLEL SAFE STRICT
382 BEGIN ATOMIC
383 SELECT * FROM ts_debug(get_current_ts_config(), $1);
384 END;
385
386 CREATE OR REPLACE FUNCTION
387 pg_backup_start(label text, fast boolean DEFAULT false)
388 RETURNS pg_lsn STRICT VOLATILE LANGUAGE internal AS 'pg_backup_start'
389 PARALLEL RESTRICTED;
390
391 CREATE OR REPLACE FUNCTION pg_backup_stop (
392 wait_for_archive boolean DEFAULT true, OUT lsn pg_lsn,
393 OUT labelfile text, OUT spcmapfile text)
394 RETURNS record STRICT VOLATILE LANGUAGE internal as 'pg_backup_stop'
395 PARALLEL RESTRICTED;
396
397 CREATE OR REPLACE FUNCTION
398 pg_promote(wait boolean DEFAULT true, wait_seconds integer DEFAULT 60)
399 RETURNS boolean STRICT VOLATILE LANGUAGE INTERNAL AS 'pg_promote'
400 PARALLEL SAFE;
401
402 CREATE OR REPLACE FUNCTION
403 pg_terminate_backend(pid integer, timeout int8 DEFAULT 0)
404 RETURNS boolean STRICT VOLATILE LANGUAGE INTERNAL AS 'pg_terminate_backend'
405 PARALLEL SAFE;
406
407 -- legacy definition for compatibility with 9.3
408 CREATE OR REPLACE FUNCTION
409 json_populate_record(base anyelement, from_json json, use_json_as_text boolean DEFAULT false)
410 RETURNS anyelement LANGUAGE internal STABLE AS 'json_populate_record' PARALLEL SAFE;
411
412 -- legacy definition for compatibility with 9.3
413 CREATE OR REPLACE FUNCTION
414 json_populate_recordset(base anyelement, from_json json, use_json_as_text boolean DEFAULT false)
415 RETURNS SETOF anyelement LANGUAGE internal STABLE ROWS 100 AS 'json_populate_recordset' PARALLEL SAFE;
416
417 CREATE OR REPLACE FUNCTION pg_logical_slot_get_changes(
418 IN slot_name name, IN upto_lsn pg_lsn, IN upto_nchanges int, VARIADIC options text[] DEFAULT '{}',
419 OUT lsn pg_lsn, OUT xid xid, OUT data text)
420 RETURNS SETOF RECORD
421 LANGUAGE INTERNAL
422 VOLATILE ROWS 1000 COST 1000
423 AS 'pg_logical_slot_get_changes';
424
425 CREATE OR REPLACE FUNCTION pg_logical_slot_peek_changes(
426 IN slot_name name, IN upto_lsn pg_lsn, IN upto_nchanges int, VARIADIC options text[] DEFAULT '{}',
427 OUT lsn pg_lsn, OUT xid xid, OUT data text)
428 RETURNS SETOF RECORD
429 LANGUAGE INTERNAL
430 VOLATILE ROWS 1000 COST 1000
431 AS 'pg_logical_slot_peek_changes';
432
433 CREATE OR REPLACE FUNCTION pg_logical_slot_get_binary_changes(
434 IN slot_name name, IN upto_lsn pg_lsn, IN upto_nchanges int, VARIADIC options text[] DEFAULT '{}',
435 OUT lsn pg_lsn, OUT xid xid, OUT data bytea)
436 RETURNS SETOF RECORD
437 LANGUAGE INTERNAL
438 VOLATILE ROWS 1000 COST 1000
439 AS 'pg_logical_slot_get_binary_changes';
440
441 CREATE OR REPLACE FUNCTION pg_logical_slot_peek_binary_changes(
442 IN slot_name name, IN upto_lsn pg_lsn, IN upto_nchanges int, VARIADIC options text[] DEFAULT '{}',
443 OUT lsn pg_lsn, OUT xid xid, OUT data bytea)
444 RETURNS SETOF RECORD
445 LANGUAGE INTERNAL
446 VOLATILE ROWS 1000 COST 1000
447 AS 'pg_logical_slot_peek_binary_changes';
448
449 CREATE OR REPLACE FUNCTION pg_logical_emit_message(
450 transactional boolean,
451 prefix text,
452 message text,
453 flush boolean DEFAULT false)
454 RETURNS pg_lsn
455 LANGUAGE INTERNAL
456 STRICT VOLATILE
457 AS 'pg_logical_emit_message_text';
458
459 CREATE OR REPLACE FUNCTION pg_logical_emit_message(
460 transactional boolean,
461 prefix text,
462 message bytea,
463 flush boolean DEFAULT false)
464 RETURNS pg_lsn
465 LANGUAGE INTERNAL
466 STRICT VOLATILE
467 AS 'pg_logical_emit_message_bytea';
468
469 CREATE OR REPLACE FUNCTION pg_create_physical_replication_slot(
470 IN slot_name name, IN immediately_reserve boolean DEFAULT false,
471 IN temporary boolean DEFAULT false,
472 OUT slot_name name, OUT lsn pg_lsn)
473 RETURNS RECORD
474 LANGUAGE INTERNAL
475 STRICT VOLATILE
476 AS 'pg_create_physical_replication_slot';
477
478 CREATE OR REPLACE FUNCTION pg_create_logical_replication_slot(
479 IN slot_name name, IN plugin name,
480 IN temporary boolean DEFAULT false,
481 IN twophase boolean DEFAULT false,
482 IN failover boolean DEFAULT false,
483 OUT slot_name name, OUT lsn pg_lsn)
484 RETURNS RECORD
485 LANGUAGE INTERNAL
486 STRICT VOLATILE
487 AS 'pg_create_logical_replication_slot';
488
489 CREATE OR REPLACE FUNCTION
490 make_interval(years int4 DEFAULT 0, months int4 DEFAULT 0, weeks int4 DEFAULT 0,
491 days int4 DEFAULT 0, hours int4 DEFAULT 0, mins int4 DEFAULT 0,
492 secs double precision DEFAULT 0.0)
493 RETURNS interval
494 LANGUAGE INTERNAL
495 STRICT IMMUTABLE PARALLEL SAFE
496 AS 'make_interval';
497
498 CREATE OR REPLACE FUNCTION
499 jsonb_set(jsonb_in jsonb, path text[] , replacement jsonb,
500 create_if_missing boolean DEFAULT true)
501 RETURNS jsonb
502 LANGUAGE INTERNAL
503 STRICT IMMUTABLE PARALLEL SAFE
504 AS 'jsonb_set';
505
506 CREATE OR REPLACE FUNCTION
507 jsonb_set_lax(jsonb_in jsonb, path text[] , replacement jsonb,
508 create_if_missing boolean DEFAULT true,
509 null_value_treatment text DEFAULT 'use_json_null')
510 RETURNS jsonb
511 LANGUAGE INTERNAL
512 CALLED ON NULL INPUT IMMUTABLE PARALLEL SAFE
513 AS 'jsonb_set_lax';
514
515 CREATE OR REPLACE FUNCTION
516 parse_ident(str text, strict boolean DEFAULT true)
517 RETURNS text[]
518 LANGUAGE INTERNAL
519 STRICT IMMUTABLE PARALLEL SAFE
520 AS 'parse_ident';
521
522 CREATE OR REPLACE FUNCTION
523 jsonb_insert(jsonb_in jsonb, path text[] , replacement jsonb,
524 insert_after boolean DEFAULT false)
525 RETURNS jsonb
526 LANGUAGE INTERNAL
527 STRICT IMMUTABLE PARALLEL SAFE
528 AS 'jsonb_insert';
529
530 CREATE OR REPLACE FUNCTION
531 jsonb_path_exists(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
532 silent boolean DEFAULT false)
533 RETURNS boolean
534 LANGUAGE INTERNAL
535 STRICT IMMUTABLE PARALLEL SAFE
536 AS 'jsonb_path_exists';
537
538 CREATE OR REPLACE FUNCTION
539 jsonb_path_match(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
540 silent boolean DEFAULT false)
541 RETURNS boolean
542 LANGUAGE INTERNAL
543 STRICT IMMUTABLE PARALLEL SAFE
544 AS 'jsonb_path_match';
545
546 CREATE OR REPLACE FUNCTION
547 jsonb_path_query(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
548 silent boolean DEFAULT false)
549 RETURNS SETOF jsonb
550 LANGUAGE INTERNAL
551 STRICT IMMUTABLE PARALLEL SAFE
552 AS 'jsonb_path_query';
553
554 CREATE OR REPLACE FUNCTION
555 jsonb_path_query_array(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
556 silent boolean DEFAULT false)
557 RETURNS jsonb
558 LANGUAGE INTERNAL
559 STRICT IMMUTABLE PARALLEL SAFE
560 AS 'jsonb_path_query_array';
561
562 CREATE OR REPLACE FUNCTION
563 jsonb_path_query_first(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
564 silent boolean DEFAULT false)
565 RETURNS jsonb
566 LANGUAGE INTERNAL
567 STRICT IMMUTABLE PARALLEL SAFE
568 AS 'jsonb_path_query_first';
569
570 CREATE OR REPLACE FUNCTION
571 jsonb_path_exists_tz(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
572 silent boolean DEFAULT false)
573 RETURNS boolean
574 LANGUAGE INTERNAL
575 STRICT STABLE PARALLEL SAFE
576 AS 'jsonb_path_exists_tz';
577
578 CREATE OR REPLACE FUNCTION
579 jsonb_path_match_tz(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
580 silent boolean DEFAULT false)
581 RETURNS boolean
582 LANGUAGE INTERNAL
583 STRICT STABLE PARALLEL SAFE
584 AS 'jsonb_path_match_tz';
585
586 CREATE OR REPLACE FUNCTION
587 jsonb_path_query_tz(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
588 silent boolean DEFAULT false)
589 RETURNS SETOF jsonb
590 LANGUAGE INTERNAL
591 STRICT STABLE PARALLEL SAFE
592 AS 'jsonb_path_query_tz';
593
594 CREATE OR REPLACE FUNCTION
595 jsonb_path_query_array_tz(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
596 silent boolean DEFAULT false)
597 RETURNS jsonb
598 LANGUAGE INTERNAL
599 STRICT STABLE PARALLEL SAFE
600 AS 'jsonb_path_query_array_tz';
601
602 CREATE OR REPLACE FUNCTION
603 jsonb_path_query_first_tz(target jsonb, path jsonpath, vars jsonb DEFAULT '{}',
604 silent boolean DEFAULT false)
605 RETURNS jsonb
606 LANGUAGE INTERNAL
607 STRICT STABLE PARALLEL SAFE
608 AS 'jsonb_path_query_first_tz';
609
610 CREATE OR REPLACE FUNCTION
611 jsonb_strip_nulls(target jsonb, strip_in_arrays boolean DEFAULT false)
612 RETURNS jsonb
613 LANGUAGE INTERNAL
614 STRICT IMMUTABLE PARALLEL SAFE
615 AS 'jsonb_strip_nulls';
616
617 CREATE OR REPLACE FUNCTION
618 json_strip_nulls(target json, strip_in_arrays boolean DEFAULT false)
619 RETURNS json
620 LANGUAGE INTERNAL
621 STRICT IMMUTABLE PARALLEL SAFE
622 AS 'json_strip_nulls';
623
624 -- default normalization form is NFC, per SQL standard
625 CREATE OR REPLACE FUNCTION
626 "normalize"(text, text DEFAULT 'NFC')
627 RETURNS text
628 LANGUAGE internal
629 STRICT IMMUTABLE PARALLEL SAFE
630 AS 'unicode_normalize_func';
631
632 CREATE OR REPLACE FUNCTION
633 is_normalized(text, text DEFAULT 'NFC')
634 RETURNS boolean
635 LANGUAGE internal
636 STRICT IMMUTABLE PARALLEL SAFE
637 AS 'unicode_is_normalized';
638
639 CREATE OR REPLACE FUNCTION
640 pg_stat_reset_shared(target text DEFAULT NULL)
641 RETURNS void
642 LANGUAGE INTERNAL
643 CALLED ON NULL INPUT VOLATILE PARALLEL SAFE
644 AS 'pg_stat_reset_shared';
645
646 CREATE OR REPLACE FUNCTION
647 pg_stat_reset_slru(target text DEFAULT NULL)
648 RETURNS void
649 LANGUAGE INTERNAL
650 CALLED ON NULL INPUT VOLATILE PARALLEL SAFE
651 AS 'pg_stat_reset_slru';
652
653 --
654 -- The default permissions for functions mean that anyone can execute them.
655 -- A number of functions shouldn't be executable by just anyone, but rather
656 -- than use explicit 'superuser()' checks in those functions, we use the GRANT
657 -- system to REVOKE access to those functions at initdb time. Administrators
658 -- can later change who can access these functions, or leave them as only
659 -- available to superuser / cluster owner, if they choose.
660 --
661
662 REVOKE EXECUTE ON FUNCTION pg_backup_start(text, boolean) FROM public;
663
664 REVOKE EXECUTE ON FUNCTION pg_backup_stop(boolean) FROM public;
665
666 REVOKE EXECUTE ON FUNCTION pg_create_restore_point(text) FROM public;
667
668 REVOKE EXECUTE ON FUNCTION pg_switch_wal() FROM public;
669
670 REVOKE EXECUTE ON FUNCTION pg_log_standby_snapshot() FROM public;
671
672 REVOKE EXECUTE ON FUNCTION pg_wal_replay_pause() FROM public;
673
674 REVOKE EXECUTE ON FUNCTION pg_wal_replay_resume() FROM public;
675
676 REVOKE EXECUTE ON FUNCTION pg_rotate_logfile() FROM public;
677
678 REVOKE EXECUTE ON FUNCTION pg_reload_conf() FROM public;
679
680 REVOKE EXECUTE ON FUNCTION pg_current_logfile() FROM public;
681
682 REVOKE EXECUTE ON FUNCTION pg_current_logfile(text) FROM public;
683
684 REVOKE EXECUTE ON FUNCTION pg_promote(boolean, integer) FROM public;
685
686 REVOKE EXECUTE ON FUNCTION pg_stat_reset() FROM public;
687
688 REVOKE EXECUTE ON FUNCTION pg_stat_reset_shared(text) FROM public;
689
690 REVOKE EXECUTE ON FUNCTION pg_stat_reset_slru(text) FROM public;
691
692 REVOKE EXECUTE ON FUNCTION pg_stat_reset_single_table_counters(oid) FROM public;
693
694 REVOKE EXECUTE ON FUNCTION pg_stat_reset_single_function_counters(oid) FROM public;
695
696 REVOKE EXECUTE ON FUNCTION pg_stat_reset_backend_stats(integer) FROM public;
697
698 REVOKE EXECUTE ON FUNCTION pg_stat_reset_replication_slot(text) FROM public;
699
700 REVOKE EXECUTE ON FUNCTION pg_stat_have_stats(text, oid, int8) FROM public;
701
702 REVOKE EXECUTE ON FUNCTION pg_stat_reset_subscription_stats(oid) FROM public;
703
704 REVOKE EXECUTE ON FUNCTION lo_import(text) FROM public;
705
706 REVOKE EXECUTE ON FUNCTION lo_import(text, oid) FROM public;
707
708 REVOKE EXECUTE ON FUNCTION lo_export(oid, text) FROM public;
709
710 REVOKE EXECUTE ON FUNCTION pg_ls_logdir() FROM public;
711
712 REVOKE EXECUTE ON FUNCTION pg_ls_waldir() FROM public;
713
714 REVOKE EXECUTE ON FUNCTION pg_ls_archive_statusdir() FROM public;
715
716 REVOKE EXECUTE ON FUNCTION pg_ls_summariesdir() FROM public;
717
718 REVOKE EXECUTE ON FUNCTION pg_ls_tmpdir() FROM public;
719
720 REVOKE EXECUTE ON FUNCTION pg_ls_tmpdir(oid) FROM public;
721
722 REVOKE EXECUTE ON FUNCTION pg_read_file(text) FROM public;
723
724 REVOKE EXECUTE ON FUNCTION pg_read_file(text,boolean) FROM public;
725
726 REVOKE EXECUTE ON FUNCTION pg_read_file(text,bigint,bigint) FROM public;
727
728 REVOKE EXECUTE ON FUNCTION pg_read_file(text,bigint,bigint,boolean) FROM public;
729
730 REVOKE EXECUTE ON FUNCTION pg_read_binary_file(text) FROM public;
731
732 REVOKE EXECUTE ON FUNCTION pg_read_binary_file(text,boolean) FROM public;
733
734 REVOKE EXECUTE ON FUNCTION pg_read_binary_file(text,bigint,bigint) FROM public;
735
736 REVOKE EXECUTE ON FUNCTION pg_read_binary_file(text,bigint,bigint,boolean) FROM public;
737
738 REVOKE EXECUTE ON FUNCTION pg_replication_origin_advance(text, pg_lsn) FROM public;
739
740 REVOKE EXECUTE ON FUNCTION pg_replication_origin_create(text) FROM public;
741
742 REVOKE EXECUTE ON FUNCTION pg_replication_origin_drop(text) FROM public;
743
744 REVOKE EXECUTE ON FUNCTION pg_replication_origin_oid(text) FROM public;
745
746 REVOKE EXECUTE ON FUNCTION pg_replication_origin_progress(text, boolean) FROM public;
747
748 REVOKE EXECUTE ON FUNCTION pg_replication_origin_session_is_setup() FROM public;
749
750 REVOKE EXECUTE ON FUNCTION pg_replication_origin_session_progress(boolean) FROM public;
751
752 REVOKE EXECUTE ON FUNCTION pg_replication_origin_session_reset() FROM public;
753
754 REVOKE EXECUTE ON FUNCTION pg_replication_origin_session_setup(text) FROM public;
755
756 REVOKE EXECUTE ON FUNCTION pg_replication_origin_xact_reset() FROM public;
757
758 REVOKE EXECUTE ON FUNCTION pg_replication_origin_xact_setup(pg_lsn, timestamp with time zone) FROM public;
759
760 REVOKE EXECUTE ON FUNCTION pg_show_replication_origin_status() FROM public;
761
762 REVOKE EXECUTE ON FUNCTION pg_stat_file(text) FROM public;
763
764 REVOKE EXECUTE ON FUNCTION pg_stat_file(text,boolean) FROM public;
765
766 REVOKE EXECUTE ON FUNCTION pg_ls_dir(text) FROM public;
767
768 REVOKE EXECUTE ON FUNCTION pg_ls_dir(text,boolean,boolean) FROM public;
769
770 REVOKE EXECUTE ON FUNCTION pg_log_backend_memory_contexts(integer) FROM PUBLIC;
771
772 REVOKE EXECUTE ON FUNCTION pg_ls_logicalsnapdir() FROM PUBLIC;
773
774 REVOKE EXECUTE ON FUNCTION pg_ls_logicalmapdir() FROM PUBLIC;
775
776 REVOKE EXECUTE ON FUNCTION pg_ls_replslotdir(text) FROM PUBLIC;
777
778 --
779 -- We also set up some things as accessible to standard roles.
780 --
781
782 GRANT EXECUTE ON FUNCTION pg_ls_logdir() TO pg_monitor;
783
784 GRANT EXECUTE ON FUNCTION pg_ls_waldir() TO pg_monitor;
785
786 GRANT EXECUTE ON FUNCTION pg_ls_archive_statusdir() TO pg_monitor;
787
788 GRANT EXECUTE ON FUNCTION pg_ls_summariesdir() TO pg_monitor;
789
790 GRANT EXECUTE ON FUNCTION pg_ls_tmpdir() TO pg_monitor;
791
792 GRANT EXECUTE ON FUNCTION pg_ls_tmpdir(oid) TO pg_monitor;
793
794 GRANT EXECUTE ON FUNCTION pg_ls_logicalsnapdir() TO pg_monitor;
795
796 GRANT EXECUTE ON FUNCTION pg_ls_logicalmapdir() TO pg_monitor;
797
798 GRANT EXECUTE ON FUNCTION pg_ls_replslotdir(text) TO pg_monitor;
799
800 GRANT EXECUTE ON FUNCTION pg_current_logfile() TO pg_monitor;
801
802 GRANT EXECUTE ON FUNCTION pg_current_logfile(text) TO pg_monitor;
803
804 GRANT pg_read_all_settings TO pg_monitor;
805
806 GRANT pg_read_all_stats TO pg_monitor;
807
808 GRANT pg_stat_scan_tables TO pg_monitor;