Example: Using DEFAULT in a Predicate - Teradata Vantage

The following statement uses DEFAULT to compare the values of the Dept_No column with the default value of the Dept_No column. Because the comparison operation involves a single column reference, Vantage can derive the column context of the DEFAULT function even though the column name is omitted.

SELECT * FROM Employee WHERE Dept_No < DEFAULT;

If the DEFAULT function evaluates to null, the predicate is unknown and the WHERE condition is false.