[SPARK-28146] Support IS OF (<type>) predicate

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Peter Toth
• Created: 24/Jun/19 15:37
• Updated: 29/Dec/19 05:54
• Resolved: 29/Dec/19 05:54

Description

PostgreSQL supports IS OF (<type>) predicate, for example the following query is valid:

select 1 is of (int), true is of (bool)

true true

I can't find PostgreSQL documentation about it, but here is how it works in Oracle:
https://docs.oracle.com/cd/B28359_01/server.111/b28286/conditions014.htm#SQLRF52157