GaussDB-行表达式函数白名单

50 阅读18分钟

GaussDB-行表达式函数白名单

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

更多详情请参考GaussDB 文档中心:doc.hcs.huawei.com/db/zh-cn/ga…