|
1446 | 1446 | { oid => '752', descr => 'substitute portion of string',
|
1447 | 1447 | proname => 'overlay', prorettype => 'bytea',
|
1448 | 1448 | proargtypes => 'bytea bytea int4', prosrc => 'byteaoverlay_no_len' },
|
1449 |
| -{ oid => '8436', descr => 'number of set bits', |
| 1449 | +{ oid => '6163', descr => 'number of set bits', |
1450 | 1450 | proname => 'bit_count', prorettype => 'int8', proargtypes => 'bytea',
|
1451 | 1451 | prosrc => 'bytea_bit_count' },
|
1452 | 1452 |
|
|
1570 | 1570 | { oid => '376', descr => 'split delimited text, with null string',
|
1571 | 1571 | proname => 'string_to_array', proisstrict => 'f', prorettype => '_text',
|
1572 | 1572 | proargtypes => 'text text text', prosrc => 'text_to_array_null' },
|
1573 |
| -{ oid => '8432', descr => 'split delimited text', |
| 1573 | +{ oid => '6160', descr => 'split delimited text', |
1574 | 1574 | proname => 'string_to_table', prorows => '1000', proisstrict => 'f',
|
1575 | 1575 | proretset => 't', prorettype => 'text', proargtypes => 'text text',
|
1576 | 1576 | prosrc => 'text_to_table' },
|
1577 |
| -{ oid => '8433', descr => 'split delimited text, with null string', |
| 1577 | +{ oid => '6161', descr => 'split delimited text, with null string', |
1578 | 1578 | proname => 'string_to_table', prorows => '1000', proisstrict => 'f',
|
1579 | 1579 | proretset => 't', prorettype => 'text', proargtypes => 'text text text',
|
1580 | 1580 | prosrc => 'text_to_table_null' },
|
|
1666 | 1666 | proname => 'width_bucket', prorettype => 'int4',
|
1667 | 1667 | proargtypes => 'anycompatible anycompatiblearray',
|
1668 | 1668 | prosrc => 'width_bucket_array' },
|
1669 |
| -{ oid => '8819', descr => 'remove last N elements of array', |
| 1669 | +{ oid => '6172', descr => 'remove last N elements of array', |
1670 | 1670 | proname => 'trim_array', prorettype => 'anyarray',
|
1671 | 1671 | proargtypes => 'anyarray int4', prosrc => 'trim_array' },
|
1672 | 1672 | { oid => '3816', descr => 'array typanalyze',
|
|
2339 | 2339 | { oid => '1171', descr => 'extract field from timestamp with time zone',
|
2340 | 2340 | proname => 'date_part', provolatile => 's', prorettype => 'float8',
|
2341 | 2341 | proargtypes => 'text timestamptz', prosrc => 'timestamptz_part' },
|
2342 |
| -{ oid => '9983', descr => 'extract field from timestamp with time zone', |
| 2342 | +{ oid => '6203', descr => 'extract field from timestamp with time zone', |
2343 | 2343 | proname => 'extract', provolatile => 's', prorettype => 'numeric',
|
2344 | 2344 | proargtypes => 'text timestamptz', prosrc => 'extract_timestamptz' },
|
2345 | 2345 | { oid => '1172', descr => 'extract field from interval',
|
2346 | 2346 | proname => 'date_part', prorettype => 'float8',
|
2347 | 2347 | proargtypes => 'text interval', prosrc => 'interval_part' },
|
2348 |
| -{ oid => '9984', descr => 'extract field from interval', |
| 2348 | +{ oid => '6204', descr => 'extract field from interval', |
2349 | 2349 | proname => 'extract', prorettype => 'numeric', proargtypes => 'text interval',
|
2350 | 2350 | prosrc => 'extract_interval' },
|
2351 | 2351 | { oid => '1174', descr => 'convert date to timestamp with time zone',
|
|
2495 | 2495 | { oid => '1273', descr => 'extract field from time with time zone',
|
2496 | 2496 | proname => 'date_part', prorettype => 'float8', proargtypes => 'text timetz',
|
2497 | 2497 | prosrc => 'timetz_part' },
|
2498 |
| -{ oid => '9981', descr => 'extract field from time with time zone', |
| 2498 | +{ oid => '6201', descr => 'extract field from time with time zone', |
2499 | 2499 | proname => 'extract', prorettype => 'numeric', proargtypes => 'text timetz',
|
2500 | 2500 | prosrc => 'extract_timetz' },
|
2501 | 2501 | { oid => '1274',
|
|
2842 | 2842 | { oid => '1384', descr => 'extract field from date',
|
2843 | 2843 | proname => 'date_part', prolang => 'sql', prorettype => 'float8',
|
2844 | 2844 | proargtypes => 'text date', prosrc => 'see system_functions.sql' },
|
2845 |
| -{ oid => '9979', descr => 'extract field from date', |
| 2845 | +{ oid => '6199', descr => 'extract field from date', |
2846 | 2846 | proname => 'extract', prorettype => 'numeric', proargtypes => 'text date',
|
2847 | 2847 | prosrc => 'extract_date' },
|
2848 | 2848 | { oid => '1385', descr => 'extract field from time',
|
2849 | 2849 | proname => 'date_part', prorettype => 'float8', proargtypes => 'text time',
|
2850 | 2850 | prosrc => 'time_part' },
|
2851 |
| -{ oid => '9980', descr => 'extract field from time', |
| 2851 | +{ oid => '6200', descr => 'extract field from time', |
2852 | 2852 | proname => 'extract', prorettype => 'numeric', proargtypes => 'text time',
|
2853 | 2853 | prosrc => 'extract_time' },
|
2854 | 2854 | { oid => '1386',
|
|
3670 | 3670 | proname => 'pg_get_statisticsobjdef', provolatile => 's',
|
3671 | 3671 | prorettype => 'text', proargtypes => 'oid',
|
3672 | 3672 | prosrc => 'pg_get_statisticsobjdef' },
|
3673 |
| -{ oid => '8887', descr => 'extended statistics columns', |
| 3673 | +{ oid => '6174', descr => 'extended statistics columns', |
3674 | 3674 | proname => 'pg_get_statisticsobjdef_columns', provolatile => 's',
|
3675 | 3675 | prorettype => 'text', proargtypes => 'oid',
|
3676 | 3676 | prosrc => 'pg_get_statisticsobjdef_columns' },
|
3677 |
| -{ oid => '8886', descr => 'extended statistics expressions', |
| 3677 | +{ oid => '6173', descr => 'extended statistics expressions', |
3678 | 3678 | proname => 'pg_get_statisticsobjdef_expressions', provolatile => 's',
|
3679 | 3679 | prorettype => '_text', proargtypes => 'oid',
|
3680 | 3680 | prosrc => 'pg_get_statisticsobjdef_expressions' },
|
|
3715 | 3715 | proname => 'pg_get_function_arg_default', provolatile => 's',
|
3716 | 3716 | prorettype => 'text', proargtypes => 'oid int4',
|
3717 | 3717 | prosrc => 'pg_get_function_arg_default' },
|
3718 |
| -{ oid => '9704', descr => 'function SQL body', |
| 3718 | +{ oid => '6197', descr => 'function SQL body', |
3719 | 3719 | proname => 'pg_get_function_sqlbody', provolatile => 's',
|
3720 | 3720 | prorettype => 'text', proargtypes => 'oid',
|
3721 | 3721 | prosrc => 'pg_get_function_sqlbody' },
|
|
3728 | 3728 | proargnames => '{word,catcode,barelabel,catdesc,baredesc}',
|
3729 | 3729 | prosrc => 'pg_get_keywords' },
|
3730 | 3730 |
|
3731 |
| -{ oid => '8103', descr => 'list of catalog foreign key relationships', |
| 3731 | +{ oid => '6159', descr => 'list of catalog foreign key relationships', |
3732 | 3732 | proname => 'pg_get_catalog_foreign_keys', procost => '10', prorows => '250',
|
3733 | 3733 | proretset => 't', provolatile => 's', prorettype => 'record',
|
3734 | 3734 | proargtypes => '',
|
|
3904 | 3904 | { oid => '3033', descr => 'set bit',
|
3905 | 3905 | proname => 'set_bit', prorettype => 'bit', proargtypes => 'bit int4 int4',
|
3906 | 3906 | prosrc => 'bitsetbit' },
|
3907 |
| -{ oid => '8435', descr => 'number of set bits', |
| 3907 | +{ oid => '6162', descr => 'number of set bits', |
3908 | 3908 | proname => 'bit_count', prorettype => 'int8', proargtypes => 'bit',
|
3909 | 3909 | prosrc => 'bit_bit_count' },
|
3910 | 3910 |
|
|
5309 | 5309 | proargmodes => '{o,o,o,o,o,o,o,o,o,o,o,o,o,o,o}',
|
5310 | 5310 | proargnames => '{pid,status,receive_start_lsn,receive_start_tli,written_lsn,flushed_lsn,received_tli,last_msg_send_time,last_msg_receipt_time,latest_end_lsn,latest_end_time,slot_name,sender_host,sender_port,conninfo}',
|
5311 | 5311 | prosrc => 'pg_stat_get_wal_receiver' },
|
5312 |
| -{ oid => '8595', descr => 'statistics: information about replication slot', |
| 5312 | +{ oid => '6169', descr => 'statistics: information about replication slot', |
5313 | 5313 | proname => 'pg_stat_get_replication_slot', prorows => '1', proisstrict => 'f',
|
5314 | 5314 | proretset => 't', provolatile => 's', proparallel => 'r',
|
5315 | 5315 | prorettype => 'record', proargtypes => 'text',
|
|
5483 | 5483 | proname => 'pg_stat_get_db_blk_write_time', provolatile => 's',
|
5484 | 5484 | proparallel => 'r', prorettype => 'float8', proargtypes => 'oid',
|
5485 | 5485 | prosrc => 'pg_stat_get_db_blk_write_time' },
|
5486 |
| -{ oid => '9575', descr => 'statistics: session time, in milliseconds', |
| 5486 | +{ oid => '6185', descr => 'statistics: session time, in milliseconds', |
5487 | 5487 | proname => 'pg_stat_get_db_session_time', provolatile => 's',
|
5488 | 5488 | proparallel => 'r', prorettype => 'float8', proargtypes => 'oid',
|
5489 | 5489 | prosrc => 'pg_stat_get_db_session_time' },
|
5490 |
| -{ oid => '9576', descr => 'statistics: session active time, in milliseconds', |
| 5490 | +{ oid => '6186', descr => 'statistics: session active time, in milliseconds', |
5491 | 5491 | proname => 'pg_stat_get_db_active_time', provolatile => 's',
|
5492 | 5492 | proparallel => 'r', prorettype => 'float8', proargtypes => 'oid',
|
5493 | 5493 | prosrc => 'pg_stat_get_db_active_time' },
|
5494 |
| -{ oid => '9577', |
| 5494 | +{ oid => '6187', |
5495 | 5495 | descr => 'statistics: session idle in transaction time, in milliseconds',
|
5496 | 5496 | proname => 'pg_stat_get_db_idle_in_transaction_time', provolatile => 's',
|
5497 | 5497 | proparallel => 'r', prorettype => 'float8', proargtypes => 'oid',
|
5498 | 5498 | prosrc => 'pg_stat_get_db_idle_in_transaction_time' },
|
5499 |
| -{ oid => '9578', descr => 'statistics: total number of sessions', |
| 5499 | +{ oid => '6188', descr => 'statistics: total number of sessions', |
5500 | 5500 | proname => 'pg_stat_get_db_sessions', provolatile => 's', proparallel => 'r',
|
5501 | 5501 | prorettype => 'int8', proargtypes => 'oid',
|
5502 | 5502 | prosrc => 'pg_stat_get_db_sessions' },
|
5503 |
| -{ oid => '9579', |
| 5503 | +{ oid => '6189', |
5504 | 5504 | descr => 'statistics: number of sessions disconnected by the client closing the network connection',
|
5505 | 5505 | proname => 'pg_stat_get_db_sessions_abandoned', provolatile => 's',
|
5506 | 5506 | proparallel => 'r', prorettype => 'int8', proargtypes => 'oid',
|
5507 | 5507 | prosrc => 'pg_stat_get_db_sessions_abandoned' },
|
5508 |
| -{ oid => '9580', |
| 5508 | +{ oid => '6190', |
5509 | 5509 | descr => 'statistics: number of sessions disconnected by fatal errors',
|
5510 | 5510 | proname => 'pg_stat_get_db_sessions_fatal', provolatile => 's',
|
5511 | 5511 | proparallel => 'r', prorettype => 'int8', proargtypes => 'oid',
|
5512 | 5512 | prosrc => 'pg_stat_get_db_sessions_fatal' },
|
5513 |
| -{ oid => '9581', |
| 5513 | +{ oid => '6191', |
5514 | 5514 | descr => 'statistics: number of sessions killed by administrative action',
|
5515 | 5515 | proname => 'pg_stat_get_db_sessions_killed', provolatile => 's',
|
5516 | 5516 | proparallel => 'r', prorettype => 'int8', proargtypes => 'oid',
|
|
5699 | 5699 | descr => 'statistics: reset collected statistics for a single SLRU',
|
5700 | 5700 | proname => 'pg_stat_reset_slru', proisstrict => 'f', provolatile => 'v',
|
5701 | 5701 | prorettype => 'void', proargtypes => 'text', prosrc => 'pg_stat_reset_slru' },
|
5702 |
| -{ oid => '8596', |
| 5702 | +{ oid => '6170', |
5703 | 5703 | descr => 'statistics: reset collected statistics for a single replication slot',
|
5704 | 5704 | proname => 'pg_stat_reset_replication_slot', proisstrict => 'f',
|
5705 | 5705 | provolatile => 'v', prorettype => 'void', proargtypes => 'text',
|
|
5825 | 5825 | { oid => '2015', descr => 'trim selected bytes from both ends of string',
|
5826 | 5826 | proname => 'btrim', prorettype => 'bytea', proargtypes => 'bytea bytea',
|
5827 | 5827 | prosrc => 'byteatrim' },
|
5828 |
| -{ oid => '9612', descr => 'trim selected bytes from left end of string', |
| 5828 | +{ oid => '6195', descr => 'trim selected bytes from left end of string', |
5829 | 5829 | proname => 'ltrim', prorettype => 'bytea', proargtypes => 'bytea bytea',
|
5830 | 5830 | prosrc => 'bytealtrim' },
|
5831 |
| -{ oid => '9613', descr => 'trim selected bytes from right end of string', |
| 5831 | +{ oid => '6196', descr => 'trim selected bytes from right end of string', |
5832 | 5832 | proname => 'rtrim', prorettype => 'bytea', proargtypes => 'bytea bytea',
|
5833 | 5833 | prosrc => 'byteartrim' },
|
5834 | 5834 |
|
|
5839 | 5839 | proname => 'date_trunc', prorettype => 'timestamp',
|
5840 | 5840 | proargtypes => 'text timestamp', prosrc => 'timestamp_trunc' },
|
5841 | 5841 |
|
5842 |
| -{ oid => '8990', descr => 'bin timestamp into specified interval', |
| 5842 | +{ oid => '6177', descr => 'bin timestamp into specified interval', |
5843 | 5843 | proname => 'date_bin', prorettype => 'timestamp',
|
5844 | 5844 | proargtypes => 'interval timestamp timestamp', prosrc => 'timestamp_bin' },
|
5845 |
| -{ oid => '8993', |
| 5845 | +{ oid => '6178', |
5846 | 5846 | descr => 'bin timestamp with time zone into specified interval',
|
5847 | 5847 | proname => 'date_bin', prorettype => 'timestamptz',
|
5848 | 5848 | proargtypes => 'interval timestamptz timestamptz',
|
|
5851 | 5851 | { oid => '2021', descr => 'extract field from timestamp',
|
5852 | 5852 | proname => 'date_part', prorettype => 'float8',
|
5853 | 5853 | proargtypes => 'text timestamp', prosrc => 'timestamp_part' },
|
5854 |
| -{ oid => '9982', descr => 'extract field from timestamp', |
| 5854 | +{ oid => '6202', descr => 'extract field from timestamp', |
5855 | 5855 | proname => 'extract', prorettype => 'numeric',
|
5856 | 5856 | proargtypes => 'text timestamp', prosrc => 'extract_timestamp' },
|
5857 | 5857 | { oid => '2024', descr => 'convert date to timestamp',
|
|
6076 | 6076 | prorettype => 'timestamptz', proargtypes => 'xid',
|
6077 | 6077 | prosrc => 'pg_xact_commit_timestamp' },
|
6078 | 6078 |
|
6079 |
| -{ oid => '8456', |
| 6079 | +{ oid => '6168', |
6080 | 6080 | descr => 'get commit timestamp and replication origin of a transaction',
|
6081 | 6081 | proname => 'pg_xact_commit_timestamp_origin', provolatile => 'v',
|
6082 | 6082 | prorettype => 'record', proargtypes => 'xid',
|
|
8058 | 8058 | { oid => '2237', descr => 'bitwise-or smallint aggregate',
|
8059 | 8059 | proname => 'bit_or', prokind => 'a', proisstrict => 'f', prorettype => 'int2',
|
8060 | 8060 | proargtypes => 'int2', prosrc => 'aggregate_dummy' },
|
8061 |
| -{ oid => '8452', descr => 'bitwise-xor smallint aggregate', |
| 8061 | +{ oid => '6164', descr => 'bitwise-xor smallint aggregate', |
8062 | 8062 | proname => 'bit_xor', prokind => 'a', proisstrict => 'f',
|
8063 | 8063 | prorettype => 'int2', proargtypes => 'int2', prosrc => 'aggregate_dummy' },
|
8064 | 8064 | { oid => '2238', descr => 'bitwise-and integer aggregate',
|
|
8067 | 8067 | { oid => '2239', descr => 'bitwise-or integer aggregate',
|
8068 | 8068 | proname => 'bit_or', prokind => 'a', proisstrict => 'f', prorettype => 'int4',
|
8069 | 8069 | proargtypes => 'int4', prosrc => 'aggregate_dummy' },
|
8070 |
| -{ oid => '8453', descr => 'bitwise-xor integer aggregate', |
| 8070 | +{ oid => '6165', descr => 'bitwise-xor integer aggregate', |
8071 | 8071 | proname => 'bit_xor', prokind => 'a', proisstrict => 'f',
|
8072 | 8072 | prorettype => 'int4', proargtypes => 'int4', prosrc => 'aggregate_dummy' },
|
8073 | 8073 | { oid => '2240', descr => 'bitwise-and bigint aggregate',
|
|
8076 | 8076 | { oid => '2241', descr => 'bitwise-or bigint aggregate',
|
8077 | 8077 | proname => 'bit_or', prokind => 'a', proisstrict => 'f', prorettype => 'int8',
|
8078 | 8078 | proargtypes => 'int8', prosrc => 'aggregate_dummy' },
|
8079 |
| -{ oid => '8454', descr => 'bitwise-xor bigint aggregate', |
| 8079 | +{ oid => '6166', descr => 'bitwise-xor bigint aggregate', |
8080 | 8080 | proname => 'bit_xor', prokind => 'a', proisstrict => 'f',
|
8081 | 8081 | prorettype => 'int8', proargtypes => 'int8', prosrc => 'aggregate_dummy' },
|
8082 | 8082 | { oid => '2242', descr => 'bitwise-and bit aggregate',
|
|
8085 | 8085 | { oid => '2243', descr => 'bitwise-or bit aggregate',
|
8086 | 8086 | proname => 'bit_or', prokind => 'a', proisstrict => 'f', prorettype => 'bit',
|
8087 | 8087 | proargtypes => 'bit', prosrc => 'aggregate_dummy' },
|
8088 |
| -{ oid => '8455', descr => 'bitwise-xor bit aggregate', |
| 8088 | +{ oid => '6167', descr => 'bitwise-xor bit aggregate', |
8089 | 8089 | proname => 'bit_xor', prokind => 'a', proisstrict => 'f', prorettype => 'bit',
|
8090 | 8090 | proargtypes => 'bit', prosrc => 'aggregate_dummy' },
|
8091 | 8091 |
|
|
9323 | 9323 | proname => 'ts_lexize', prorettype => '_text',
|
9324 | 9324 | proargtypes => 'regdictionary text', prosrc => 'ts_lexize' },
|
9325 | 9325 |
|
9326 |
| -{ oid => '9531', descr => 'debug function for text search configuration', |
| 9326 | +{ oid => '6183', descr => 'debug function for text search configuration', |
9327 | 9327 | proname => 'ts_debug', prolang => 'sql', prorows => '1000', proretset => 't',
|
9328 | 9328 | provolatile => 's', prorettype => 'record', proargtypes => 'regconfig text',
|
9329 | 9329 | proallargtypes => '{regconfig,text,text,text,text,_regdictionary,regdictionary,_text}',
|
9330 | 9330 | proargmodes => '{i,i,o,o,o,o,o,o}',
|
9331 | 9331 | proargnames => '{config,document,alias,description,token,dictionaries,dictionary,lexemes}',
|
9332 | 9332 | prosrc => 'see system_functions.sql' },
|
9333 | 9333 |
|
9334 |
| -{ oid => '9532', |
| 9334 | +{ oid => '6184', |
9335 | 9335 | descr => 'debug function for current text search configuration',
|
9336 | 9336 | proname => 'ts_debug', prolang => 'sql', prorows => '1000', proretset => 't',
|
9337 | 9337 | provolatile => 's', prorettype => 'record', proargtypes => 'text',
|
|
9939 | 9939 | proname => 'btrecordcmp', prorettype => 'int4',
|
9940 | 9940 | proargtypes => 'record record', prosrc => 'btrecordcmp' },
|
9941 | 9941 |
|
9942 |
| -{ oid => '9609', descr => 'hash', |
| 9942 | +{ oid => '6192', descr => 'hash', |
9943 | 9943 | proname => 'hash_record', prorettype => 'int4', proargtypes => 'record',
|
9944 | 9944 | prosrc => 'hash_record' },
|
9945 |
| -{ oid => '9610', descr => 'hash', |
| 9945 | +{ oid => '6193', descr => 'hash', |
9946 | 9946 | proname => 'hash_record_extended', prorettype => 'int8',
|
9947 | 9947 | proargtypes => 'record int8', prosrc => 'hash_record_extended' },
|
9948 | 9948 |
|
@@ -10172,11 +10172,11 @@
|
10172 | 10172 | { oid => '3881', descr => 'GiST support',
|
10173 | 10173 | proname => 'range_gist_same', prorettype => 'internal',
|
10174 | 10174 | proargtypes => 'anyrange anyrange internal', prosrc => 'range_gist_same' },
|
10175 |
| -{ oid => '8017', descr => 'GiST support', |
| 10175 | +{ oid => '6154', descr => 'GiST support', |
10176 | 10176 | proname => 'multirange_gist_consistent', prorettype => 'bool',
|
10177 | 10177 | proargtypes => 'internal anymultirange int2 oid internal',
|
10178 | 10178 | prosrc => 'multirange_gist_consistent' },
|
10179 |
| -{ oid => '8019', descr => 'GiST support', |
| 10179 | +{ oid => '6156', descr => 'GiST support', |
10180 | 10180 | proname => 'multirange_gist_compress', prorettype => 'internal',
|
10181 | 10181 | proargtypes => 'internal', prosrc => 'multirange_gist_compress' },
|
10182 | 10182 | { oid => '3902', descr => 'hash a range',
|
@@ -11501,10 +11501,10 @@
|
11501 | 11501 | prosrc => 'pg_control_init' },
|
11502 | 11502 |
|
11503 | 11503 | # subscripting support for built-in types
|
11504 |
| -{ oid => '9255', descr => 'standard array subscripting support', |
| 11504 | +{ oid => '6179', descr => 'standard array subscripting support', |
11505 | 11505 | proname => 'array_subscript_handler', prorettype => 'internal',
|
11506 | 11506 | proargtypes => 'internal', prosrc => 'array_subscript_handler' },
|
11507 |
| -{ oid => '9256', descr => 'raw array subscripting support', |
| 11507 | +{ oid => '6180', descr => 'raw array subscripting support', |
11508 | 11508 | proname => 'raw_array_subscript_handler', prorettype => 'internal',
|
11509 | 11509 | proargtypes => 'internal', prosrc => 'raw_array_subscript_handler' },
|
11510 | 11510 | # type subscripting support
|
|
11586 | 11586 | proname => 'is_normalized', prorettype => 'bool', proargtypes => 'text text',
|
11587 | 11587 | prosrc => 'unicode_is_normalized' },
|
11588 | 11588 |
|
11589 |
| -{ oid => '9822', descr => 'unescape Unicode characters', |
| 11589 | +{ oid => '6198', descr => 'unescape Unicode characters', |
11590 | 11590 | proname => 'unistr', prorettype => 'text', proargtypes => 'text',
|
11591 | 11591 | prosrc => 'unistr' },
|
11592 | 11592 |
|
|
0 commit comments