行表达式函数白名单
func_oid_value |
func_name |
---|---|
56 |
boollt |
57 |
boolgt |
60 |
booleq |
61 |
chareq |
63 |
int2eq |
64 |
int2lt |
65 |
int4eq |
66 |
int4lt |
67 |
texteq |
70 |
charne |
72 |
charle |
73 |
chargt |
74 |
charge |
77 |
int4 |
78 |
char |
84 |
boolne |
111 |
numeric_fac |
141 |
int4mul |
144 |
int4ne |
145 |
int2ne |
146 |
int2gt |
147 |
int4gt |
148 |
int2le |
149 |
int4le |
150 |
int4ge |
151 |
int2ge |
152 |
int2mul |
153 |
int2div |
154 |
int4div |
155 |
int2mod |
156 |
int4mod |
157 |
textne |
158 |
int24eq |
159 |
int42eq |
160 |
int24lt |
161 |
int42lt |
162 |
int24gt |
163 |
int42gt |
164 |
int24ne |
165 |
int42ne |
166 |
int24le |
167 |
int42le |
168 |
int24ge |
169 |
int42ge |
170 |
int24mul |
171 |
int42mul |
172 |
int24div |
173 |
int42div |
176 |
int2pl |
177 |
int4pl |
178 |
int24pl |
179 |
int42pl |
180 |
int2mi |
181 |
int4mi |
182 |
int24mi |
183 |
int42mi |
202 |
float4mul |
203 |
float4div |
204 |
float4pl |
205 |
float4mi |
206 |
float4um |
207 |
float4abs |
209 |
float4larger |
211 |
float4smaller |
212 |
int4um |
213 |
int2um |
216 |
float8mul |
217 |
float8div |
218 |
float8pl |
219 |
float8mi |
220 |
float8um |
221 |
float8abs |
223 |
float8larger |
224 |
float8smaller |
228 |
dround |
229 |
dtrunc |
235 |
float8 |
236 |
float4 |
237 |
int2 |
238 |
int2 |
244 |
timepl |
245 |
timemi |
248 |
intinterval |
249 |
tintervalrel |
251 |
abstimeeq |
252 |
abstimene |
253 |
abstimelt |
254 |
abstimegt |
255 |
abstimele |
256 |
abstimege |
257 |
reltimeeq |
258 |
reltimene |
259 |
reltimelt |
260 |
reltimegt |
261 |
reltimele |
262 |
reltimege |
263 |
tintervalsame |
264 |
tintervalct |
265 |
tintervalov |
266 |
tintervalleneq |
267 |
tintervallenne |
268 |
tintervallenlt |
269 |
tintervallengt |
270 |
tintervallenle |
271 |
tintervallenge |
273 |
tintervalend |
275 |
isfinite |
279 |
float48mul |
280 |
float48div |
281 |
float48pl |
282 |
float48mi |
283 |
float84mul |
284 |
float84div |
285 |
float84pl |
286 |
float84mi |
287 |
float4eq |
288 |
float4ne |
289 |
float4lt |
290 |
float4le |
291 |
float4gt |
292 |
float4ge |
293 |
float8eq |
294 |
float8ne |
295 |
float8lt |
296 |
float8le |
297 |
float8gt |
298 |
float8ge |
299 |
float48eq |
300 |
float48ne |
301 |
float48lt |
302 |
float48le |
303 |
float48gt |
304 |
float48ge |
305 |
float84eq |
306 |
float84ne |
307 |
float84lt |
308 |
float84le |
309 |
float84gt |
310 |
float84ge |
311 |
float8 |
312 |
float4 |
313 |
int4 |
314 |
int2 |
316 |
float8 |
317 |
int4 |
318 |
float4 |
319 |
int4 |
350 |
btint2cmp |
351 |
btint4cmp |
354 |
btfloat4cmp |
355 |
btfloat8cmp |
357 |
btabstimecmp |
358 |
btcharcmp |
360 |
bttextcmp |
377 |
cash_cmp |
380 |
btreltimecmp |
381 |
bttintervalcmp |
385 |
regexp_count |
386 |
regexp_count |
387 |
regexp_count |
400 |
hashtext |
432 |
hash_numeric |
449 |
hashint2 |
450 |
hashint4 |
451 |
hashfloat4 |
452 |
hashfloat8 |
454 |
hashchar |
458 |
text_larger |
459 |
text_smaller |
461 |
int8out |
462 |
int8um |
463 |
int8pl |
464 |
int8mi |
465 |
int8mul |
466 |
int8div |
467 |
int8eq |
468 |
int8ne |
469 |
int8lt |
470 |
int8gt |
471 |
int8le |
472 |
int8ge |
474 |
int84eq |
475 |
int84ne |
476 |
int84lt |
477 |
int84gt |
478 |
int84le |
479 |
int84ge |
480 |
int4 |
481 |
int8 |
482 |
float8 |
483 |
int8 |
630 |
regexp_instr |
631 |
regexp_instr |
632 |
regexp_instr |
633 |
regexp_instr |
634 |
regexp_instr |
652 |
float4 |
654 |
hashint1_numeric |
665 |
hashint2_numeric |
667 |
hashint16 |
676 |
mktinterval |
682 |
hashint4_numeric |
714 |
int2 |
720 |
octet_length |
721 |
get_byte |
722 |
set_byte |
723 |
get_bit |
724 |
set_bit |
740 |
text_lt |
741 |
text_le |
742 |
text_gt |
743 |
text_ge |
754 |
int8 |
755 |
hashint8_numeric |
766 |
int4inc |
768 |
int4larger |
769 |
int4smaller |
770 |
int2larger |
771 |
int2smaller |
784 |
tintervaleq |
785 |
tintervalne |
786 |
tintervallt |
787 |
tintervalgt |
788 |
tintervalle |
789 |
tintervalge |
792 |
btint12cmp |
793 |
btint14cmp |
794 |
btint18cmp |
795 |
btint116cmp |
796 |
btint1numericcmp |
797 |
btint21cmp |
798 |
btint216cmp |
799 |
btint2numericcmp |
800 |
btint41cmp |
801 |
btint416cmp |
802 |
btint4numericcmp |
803 |
btint81cmp |
804 |
btint816cmp |
805 |
btint8numericcmp |
837 |
int82pl |
838 |
int82mi |
839 |
int82mul |
840 |
int82div |
841 |
int28pl |
842 |
btint8cmp |
846 |
cash_mul_flt4 |
847 |
cash_div_flt4 |
848 |
flt4_mul_cash |
849 |
position |
852 |
int48eq |
853 |
int48ne |
854 |
int48lt |
855 |
int48gt |
856 |
int48le |
857 |
int48ge |
860 |
bpchar |
862 |
int4_mul_cash |
863 |
int2_mul_cash |
864 |
cash_mul_int4 |
865 |
cash_div_int4 |
866 |
cash_mul_int2 |
867 |
cash_div_int2 |
868 |
strpos |
870 |
lower |
871 |
upper |
877 |
substr |
883 |
substr |
888 |
cash_eq |
889 |
cash_ne |
890 |
cash_lt |
891 |
cash_le |
892 |
cash_gt |
893 |
cash_ge |
894 |
cash_pl |
895 |
cash_mi |
896 |
cash_mul_flt8 |
897 |
cash_div_flt8 |
898 |
cashlarger |
899 |
cashsmaller |
919 |
flt8_mul_cash |
935 |
cash_words |
936 |
substring |
937 |
substring |
940 |
mod |
941 |
mod |
942 |
int28mi |
943 |
int28mul |
944 |
char |
945 |
int8mod |
947 |
mod |
948 |
int28div |
949 |
hashint8 |
1026 |
timezone |
1048 |
bpchareq |
1049 |
bpcharlt |
1050 |
bpcharle |
1051 |
bpchargt |
1052 |
bpcharge |
1053 |
bpcharne |
1063 |
bpchar_larger |
1064 |
bpchar_smaller |
1078 |
bpcharcmp |
1080 |
hashbpchar |
1102 |
time_lt |
1103 |
time_le |
1104 |
time_gt |
1105 |
time_ge |
1106 |
time_ne |
1107 |
time_cmp |
1116 |
regexp_replace |
1117 |
regexp_replace |
1118 |
regexp_replace |
1119 |
regexp_replace |
1145 |
time_eq |
1152 |
timestamptz_eq |
1153 |
timestamptz_ne |
1154 |
timestamptz_lt |
1155 |
timestamptz_le |
1156 |
timestamptz_ge |
1157 |
timestamptz_gt |
1158 |
to_timestamp |
1159 |
timezone |
1162 |
interval_eq |
1163 |
interval_ne |
1164 |
interval_lt |
1165 |
interval_le |
1166 |
interval_ge |
1167 |
interval_gt |
1168 |
interval_um |
1169 |
interval_pl |
1170 |
interval_mi |
1172 |
date_part |
1173 |
timestamptz |
1177 |
interval |
1180 |
abstime |
1188 |
timestamptz_mi |
1194 |
reltime |
1195 |
timestamptz_smaller |
1196 |
timestamptz_larger |
1197 |
interval_smaller |
1198 |
interval_larger |
1199 |
age |
1200 |
interval |
1218 |
date_trunc |
1219 |
int8inc |
1230 |
int8abs |
1236 |
int8larger |
1237 |
int8smaller |
1238 |
texticregexeq |
1239 |
texticregexne |
1246 |
charlt |
1251 |
int4abs |
1253 |
int2abs |
1254 |
textregexeq |
1256 |
textregexne |
1271 |
overlaps |
1273 |
date_part |
1274 |
int84pl |
1275 |
int84mi |
1276 |
int84mul |
1277 |
int84div |
1278 |
int48pl |
1279 |
int48mi |
1280 |
int48mul |
1281 |
int48div |
1282 |
quote_ident |
1283 |
quote_literal |
1289 |
quote_nullable |
1299 |
now |
1304 |
overlaps |
1308 |
overlaps |
1309 |
overlaps |
1310 |
overlaps |
1311 |
overlaps |
1314 |
timestamptz_cmp |
1315 |
interval_cmp |
1316 |
time |
1326 |
interval_div |
1342 |
round |
1343 |
trunc |
1352 |
timetz_eq |
1353 |
timetz_ne |
1354 |
timetz_lt |
1355 |
timetz_le |
1356 |
timetz_ge |
1357 |
timetz_gt |
1358 |
timetz_cmp |
1359 |
timestamptz |
1370 |
interval |
1373 |
isfinite |
1374 |
octet_length |
1375 |
octet_length |
1377 |
time_larger |
1378 |
time_smaller |
1379 |
timetz_larger |
1380 |
timetz_smaller |
1384 |
date_part |
1385 |
date_part |
1389 |
isfinite |
1390 |
isfinite |
1394 |
abs |
1395 |
abs |
1396 |
abs |
1397 |
abs |
1398 |
abs |
1419 |
time |
1481 |
tinterval |
1581 |
biteq |
1582 |
bitne |
1592 |
bitge |
1593 |
bitgt |
1594 |
bitle |
1595 |
bitlt |
1596 |
bitcmp |
1608 |
degrees |
1618 |
interval_mul |
1620 |
ascii |
1621 |
chr |
1622 |
repeat |
1623 |
similar_escape |
1624 |
mul_d_interval |
1633 |
texticlike |
1634 |
texticnlike |
1637 |
like_escape |
1656 |
bpcharicregexeq |
1657 |
bpcharicregexne |
1658 |
bpcharregexeq |
1659 |
bpcharregexne |
1660 |
bpchariclike |
1661 |
bpcharicnlike |
1666 |
varbiteq |
1667 |
varbitne |
1668 |
varbitge |
1669 |
varbitgt |
1670 |
varbitle |
1671 |
varbitlt |
1672 |
varbitcmp |
1673 |
bitand |
1674 |
bitor |
1675 |
bitxor |
1676 |
bitnot |
1677 |
bitshiftleft |
1678 |
bitshiftright |
1679 |
bitcat |
1680 |
substring |
1682 |
octet_length |
1683 |
bit |
1684 |
int4 |
1685 |
bit |
1687 |
varbit |
1688 |
time_hash |
1690 |
time_mi_time |
1691 |
boolle |
1692 |
boolge |
1693 |
btboolcmp |
1696 |
timetz_hash |
1697 |
interval_hash |
1698 |
position |
1699 |
substring |
1702 |
numeric_out |
1703 |
numeric |
1704 |
numeric_abs |
1705 |
abs |
1706 |
sign |
1707 |
round |
1709 |
trunc |
1710 |
trunc |
1711 |
ceil |
1712 |
floor |
1718 |
numeric_eq |
1719 |
numeric_ne |
1720 |
numeric_gt |
1721 |
numeric_ge |
1722 |
numeric_lt |
1723 |
numeric_le |
1724 |
numeric_add |
1725 |
numeric_sub |
1726 |
numeric_mul |
1727 |
numeric_div |
1728 |
mod |
1729 |
numeric_mod |
1740 |
numeric |
1742 |
numeric |
1743 |
numeric |
1744 |
int4 |
1745 |
float4 |
1746 |
float8 |
1747 |
time_pl_interval |
1748 |
time_mi_interval |
1749 |
timetz_pl_interval |
1750 |
timetz_mi_interval |
1752 |
trunc |
1753 |
trunc |
1764 |
numeric_inc |
1766 |
numeric_smaller |
1767 |
numeric_larger |
1769 |
numeric_cmp |
1771 |
numeric_uminus |
1781 |
numeric |
1782 |
numeric |
1783 |
int2 |
1810 |
bit_length |
1811 |
bit_length |
1812 |
bit_length |
1840 |
int2_sum |
1841 |
int4_sum |
1842 |
int8_sum |
1845 |
to_ascii |
1846 |
to_ascii |
1848 |
interval_pl_time |
1850 |
int28eq |
1851 |
int28ne |
1852 |
int28lt |
1853 |
int28gt |
1854 |
int28le |
1855 |
int28ge |
1856 |
int82eq |
1857 |
int82ne |
1858 |
int82lt |
1859 |
int82gt |
1860 |
int82le |
1861 |
int82ge |
1874 |
btint161cmp |
1875 |
btint162cmp |
1876 |
btint164cmp |
1877 |
btint168cmp |
1878 |
btnumericint1cmp |
1879 |
btnumericint2cmp |
1880 |
btnumericint4cmp |
1881 |
btnumericint8cmp |
1882 |
btint16cmp |
1892 |
int2and |
1893 |
int2or |
1894 |
int2xor |
1895 |
int2not |
1896 |
int2shl |
1897 |
int2shr |
1898 |
int4and |
1899 |
int4or |
1900 |
int4xor |
1901 |
int4not |
1902 |
int4shl |
1903 |
int4shr |
1904 |
int8and |
1905 |
int8or |
1906 |
int8xor |
1907 |
int8not |
1908 |
int8shl |
1909 |
int8shr |
1910 |
int8up |
1911 |
int2up |
1912 |
int4up |
1913 |
float4up |
1914 |
float8up |
1915 |
numeric_uplus |
1946 |
encode |
1961 |
timestamp |
1967 |
timestamptz |
1968 |
time |
1969 |
timetz |
1973 |
div |
1980 |
numeric_div_trunc |
2009 |
like_escape |
2012 |
substring |
2013 |
substring |
2014 |
position |
2020 |
date_trunc |
2021 |
date_part |
2024 |
timestamp |
2025 |
timestamp |
2031 |
timestamp_mi |
2032 |
timestamp_pl_interval |
2033 |
timestamp_mi_interval |
2035 |
timestamp_smaller |
2036 |
timestamp_larger |
2038 |
timezone |
2039 |
timestamp_hash |
2041 |
overlaps |
2042 |
overlaps |
2043 |
overlaps |
2044 |
overlaps |
2045 |
timestamp_cmp |
2046 |
time |
2048 |
isfinite |
2052 |
timestamp_eq |
2053 |
timestamp_ne |
2054 |
timestamp_lt |
2055 |
timestamp_le |
2056 |
timestamp_ge |
2057 |
timestamp_gt |
2058 |
age |
2069 |
timezone |
2070 |
timezone |
2073 |
substring |
2074 |
substring |
2075 |
bit |
2076 |
int8 |
2089 |
to_hex |
2090 |
to_hex |
2160 |
text_pattern_lt |
2161 |
text_pattern_le |
2163 |
text_pattern_ge |
2164 |
text_pattern_gt |
2166 |
bttext_pattern_cmp |
2167 |
ceiling |
2174 |
bpchar_pattern_lt |
2175 |
bpchar_pattern_le |
2177 |
bpchar_pattern_ge |
2178 |
bpchar_pattern_gt |
2180 |
btbpchar_pattern_cmp |
2188 |
btint48cmp |
2189 |
btint84cmp |
2190 |
btint24cmp |
2191 |
btint42cmp |
2192 |
btint28cmp |
2193 |
btint82cmp |
2194 |
btfloat48cmp |
2195 |
btfloat84cmp |
2308 |
ceil |
2309 |
floor |
2310 |
sign |
2320 |
ceiling |
2515 |
booland_statefunc |
2516 |
boolor_statefunc |
2547 |
interval_pl_timetz |
2548 |
interval_pl_timestamp |
2557 |
bool |
2558 |
int4 |
2765 |
regexp_split_to_table |
2766 |
regexp_split_to_table |
2805 |
int8inc_float8_float8 |
2906 |
timestamptypmodout |
2908 |
timestamptztypmodout |
2910 |
timetypmodout |
2912 |
timetztypmodout |
2996 |
int8_sum_to_int8 |
3032 |
get_bit |
3033 |
set_bit |
3062 |
reverse |
3167 |
instr |
3168 |
instr |
3169 |
instr |
3170 |
multiply |
3171 |
multiply |
3175 |
lengthb |
3176 |
lengthb |
3177 |
int8_bool |
3178 |
bool_int8 |
3180 |
int2_bool |
3181 |
bool_int2 |
3182 |
substring_inner |
3183 |
substring_inner |
3226 |
timestamp_diff |
3227 |
timestamp_diff |
3343 |
int8_mul_cash |
3344 |
cash_mul_int8 |
3345 |
cash_div_int8 |
3822 |
cash_div_cash |
3922 |
int4range_subdiff |
3923 |
int8range_subdiff |
3924 |
numrange_subdiff |
3925 |
daterange_subdiff |
3929 |
tsrange_subdiff |
3930 |
tstzrange_subdiff |
4162 |
varchar_date |
4163 |
bpchar_date |
4164 |
text_date |
4166 |
int2_text |
4167 |
int4_text |
4168 |
int8_text |
4169 |
float4_text |
4170 |
float8_text |
4171 |
numeric_text |
5580 |
smalldatetime_eq |
5581 |
smalldatetime_ne |
5582 |
smalldatetime_lt |
5583 |
smalldatetime_le |
5584 |
smalldatetime_ge |
5585 |
smalldatetime_gt |
5586 |
smalldatetime_cmp |
5587 |
smalldatetime_hash |
5809 |
b_db_last_day |
5810 |
b_db_last_day |
5811 |
b_db_last_day |
5816 |
b_db_last_day |
5858 |
weekofyear |
5859 |
weekofyear |
5860 |
weekofyear |
5861 |
weekofyear |
6407 |
int16 |
6408 |
int2 |
6409 |
int16 |
6410 |
int4 |
6411 |
int16 |
6412 |
int8 |
6413 |
int16 |
6414 |
float8 |
6415 |
int16 |
6416 |
float4 |
6419 |
int16 |
6420 |
int16_bool |
6421 |
int16 |
6422 |
numeric |
6423 |
int16eq |
6424 |
int16ne |
6425 |
int16lt |
6426 |
int16le |
6427 |
int16gt |
6428 |
int16ge |
6429 |
int16pl |
6430 |
int16mi |
6431 |
int16mul |
6432 |
int16div |
6433 |
numeric |
6434 |
numeric_bool |
6438 |
int21gt |
6439 |
int21le |
6440 |
int21ge |
6441 |
int216eq |
6442 |
int216ne |
6443 |
int216lt |
6444 |
int216gt |
6445 |
int216le |
6446 |
int216ge |
6447 |
int2numericeq |
6448 |
int2numericne |
6449 |
int2numericlt |
6450 |
int2numericgt |
6451 |
int2numericle |
6452 |
int2numericge |
6453 |
int41eq |
6454 |
int41ne |
6455 |
int41lt |
6456 |
int41gt |
6457 |
int41le |
6458 |
int41ge |
6459 |
int416eq |
6460 |
int416ne |
6461 |
int416lt |
6462 |
int416gt |
6463 |
int416le |
6464 |
int416ge |
6465 |
int4numericeq |
6466 |
int4numericne |
6467 |
int4numericlt |
6468 |
int4numericgt |
6469 |
int4numericle |
6470 |
int4numericge |
6471 |
int81eq |
6472 |
int81ne |
6473 |
int81lt |
6474 |
int81gt |
6475 |
int81le |
6476 |
int81ge |
6477 |
int816eq |
6478 |
int816ne |
6479 |
int816lt |
6480 |
int816gt |
6481 |
int816le |
6482 |
int816ge |
6483 |
int8numericeq |
6484 |
int8numericne |
6485 |
int8numericlt |
6486 |
int8numericgt |
6487 |
int8numericle |
6488 |
int8numericge |
6539 |
int21eq |
6540 |
int21ne |
6578 |
b_timestampdiff |
6579 |
b_timestampdiff |
6582 |
b_timestampdiff |
6583 |
b_timestampdiff |
6584 |
b_timestampdiff |
6585 |
b_timestampdiff |
6586 |
b_timestampdiff |
6587 |
b_timestampdiff |
6588 |
b_timestampdiff |
6589 |
b_timestampdiff |
6590 |
b_timestampdiff |
6591 |
b_timestampdiff |
6592 |
b_timestampdiff |
6593 |
b_timestampdiff |
6594 |
b_timestampdiff |
6595 |
b_timestampdiff |
6635 |
int21lt |
6814 |
int12eq |
6815 |
numericint1eq |
6853 |
int168ge |
7747 |
numericint2le |
7748 |
numericint2ge |
7749 |
numericint4eq |
7750 |
numericint4ne |
7751 |
numericint4lt |
7752 |
numericint4gt |
7753 |
numericint4le |
7754 |
numericint4ge |
7755 |
numericint8eq |
7756 |
numericint8ne |
7757 |
numericint8lt |
7758 |
numericint8gt |
7759 |
numericint8le |
7760 |
numericint8ge |
7761 |
int161eq |
7762 |
int161ne |
7763 |
int161lt |
8751 |
int161gt |
8752 |
int161le |
8753 |
int161ge |
8754 |
int162eq |
8755 |
int162ne |
8756 |
int162lt |
8757 |
int162gt |
8758 |
int162le |
8759 |
int162ge |
8760 |
int164eq |
8761 |
int164ne |
8762 |
int164lt |
8763 |
int164gt |
8764 |
int164le |
8765 |
int164ge |
8766 |
int168eq |
8767 |
int168ne |
8768 |
int168lt |
8769 |
int168gt |
8770 |
int168le |
9011 |
smalldatetime_smaller |
9012 |
smalldatetime_larger |
9558 |
int12ne |
9559 |
int12lt |
9560 |
int12gt |
9561 |
int12le |
9562 |
int12ge |
9563 |
int14eq |
9564 |
int14ne |
9566 |
int14lt |
9567 |
int14gt |
9568 |
int14le |
9569 |
int14ge |
9573 |
int18eq |
9574 |
int18ne |
9575 |
int18lt |
9576 |
int18gt |
9584 |
int18le |
9585 |
int18ge |
9586 |
int116eq |
9587 |
int116ne |
9588 |
int116lt |
9589 |
int116gt |
9590 |
int116le |
9591 |
int116ge |
9592 |
int1numericeq |
9593 |
int1numericne |
9594 |
int1numericlt |
9595 |
int1numericgt |
9596 |
int1numericle |
9597 |
int1numericge |
9624 |
numericint1ne |
9625 |
numericint1lt |
9626 |
numericint1gt |
9627 |
numericint1le |
9628 |
numericint1ge |
9629 |
numericint2eq |
9630 |
numericint2ne |
9631 |
numericint2lt |
9632 |
numericint2gt |
9910 |
substring_index |