Updated on 2024-06-03 GMT+08:00

Row Expression Function Whitelist

Table 1 Expression function whitelist for data objects to add or modify ILM policies

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