Tracking: string and bytea functions

[xiangjinwu]

https://www.postgresql.org/docs/current/functions-string.html
https://www.postgresql.org/docs/current/functions-binarystring.html

Make sure to test special values: empty string, multi-byte Unicode.

proto ExprType 202..=211, 215, 216, 218, 220, 223..=232, 235..=244, 310..=399

Standard varchar

• || / concat / concat_ws
• bit_length / char_length / character_length / octet_length / length
• support POSITION(substring IN string) → integer #8938 / strpos
• overlay(string PLACING newsubstring FROM start [FOR count])
• substring / substr / Support string functions left and right #8934
• trim / ltrim / rtrim / Support string function btrim #8935

Standard bytea

• ||
• bit_length / octet_length / length
• position
• overlay(string PLACING newsubstring FROM start [FOR count])
• substring / substr
• trim / btrim / ltrim / rtrim

Standard bit / varbit (type not supported yet)

• || (varbit)
• bit_length / octet_length / length
• position
• overlay(string PLACING newsubstring FROM start [FOR count])
• substring

Others varchar

• lower / upper / initcap
• lpad / rpad
• repeat
• reverse
• replace
• translate
• split_part
• starts_with / ^@
• Implement string_to_array #9283
• ascii / chr
• to_hex

• quote_ident
• Implement quote_literal #16792
• quote_nullable
• parse_ident

• md5

Others bytea

• bit_count
• get_bit / set_bit / get_byte / set_byte
• Implement md5 #8847
• Implement sha512, sha384, sha256, sha224 #8846
• Implement sha1 #8845
• Implement encode / decode #8937

Others bit / varbit (type not supported yet)

• bit_count
• get_bit / set_bit
• & / | / # / ~ / << / >>
• explicit cast between int / bigint

Aggregate

• bit_and / bit_or / bit_xor

LIKE / SIMILAR / POSIX RegExp

https://www.postgresql.org/docs/current/functions-matching.html

• singularity-data/risingwave-legacy#668
• ~~ / !~~
• LIKE with ESCAPE
• Support [NOT] ILIKE / ~~* / !~~* #11496
• Implement [NOT] SIMILAR TO #8966
• substring(string similar pattern escape escape-character) (substring(string from pattern for escape-character))
• ~ / ~* / !~ / !~* fix(expr): regex operator ~ / !~ should return null when either input is null #5136
• regexp_like
• support regexp_count #11735
• regexp_instr
• regexp_substr
• regexp_match
• support regexp_replace #11723
• regexp_split_to_array
• substring(string from pattern)

Formatting

• support function format #11247

https://www.postgresql.org/docs/current/functions-formatting.html

• implement to_char for timestamp / timestamptz / interval
• implement to_date(varchar, varchar) -> date #11226
• implement to_timestamp(varchar, varchar) -> timestamptz #11227
• implement to_char for int / bigint / decimal / real / double
• implement to_number(varchar, varchar) -> decimal

Encoding related

varchar

• pg_client_encoding
• normalize / is normalized
• to_ascii
• unistr

bytea

• convert / convert_from / convert_to Support convert_from(b: bytea, src_encoding: text) -> text #13306

Aggregate Function

• string_agg

Set Returning Function

• string_to_table
• regexp_matches
• regexp_split_to_table

[BanBuDu0]

I finished encdec some time ago.
I think I will keep contributing all of the bytea functions one by one, if no one is doing the same work.