[SPARK-28768] Implement more text pattern operators

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 18/Aug/19 10:56
• Updated: 29/Dec/19 09:30
• Resolved: 29/Dec/19 09:30

Description

postgres=# \do ~*~
                                     List of operators
   Schema   | Name | Left arg type | Right arg type | Result type |       Description
------------+------+---------------+----------------+-------------+-------------------------
 pg_catalog | ~<=~ | character     | character      | boolean     | less than or equal
 pg_catalog | ~<=~ | text          | text           | boolean     | less than or equal
 pg_catalog | ~<~  | character     | character      | boolean     | less than
 pg_catalog | ~<~  | text          | text           | boolean     | less than
 pg_catalog | ~>=~ | character     | character      | boolean     | greater than or equal
 pg_catalog | ~>=~ | text          | text           | boolean     | greater than or equal
 pg_catalog | ~>~  | character     | character      | boolean     | greater than
 pg_catalog | ~>~  | text          | text           | boolean     | greater than
 pg_catalog | ~~   | bytea         | bytea          | boolean     | matches LIKE expression
 pg_catalog | ~~   | character     | text           | boolean     | matches LIKE expression
 pg_catalog | ~~   | name          | text           | boolean     | matches LIKE expression
 pg_catalog | ~~   | text          | text           | boolean     | matches LIKE expression
(12 rows)

postgres=# select '1' ~<~ '2';
 ?column?
----------
 t
(1 row)

https://stackoverflow.com/questions/35807872/operator-in-postgres