Skip to main content

DISCONTINUED

Returns true if the record represents a DISCONTINUED tombstone. The DISCONTINUED logical function is to be used in conjunction with time travel queries.

Syntax

DISCONTINUED ( column_expression ) 

Arguments

column_expression
A valid column expression.

Return Type

Returns data of type BOOL.

Examples

The following example returns primary keys that have been discontinued. The following example uses the DEMO DATABASE.

SELECT * 
FROM LIFETIME financial.pricing
WHERE DISCONTINUED(pricing);

Response:

SYMBOL [STRING] PRICE [FLOAT32] DIVIDEND_YIELD [FLOAT32]    PRICE_EARNING [FLOAT32] EARNING_SHARE [FLOAT32] BOOK_VALUE [FLOAT32]    52_WEEK_LOW [FLOAT32]   52_WEEK_HIGH [FLOAT32]  TIMESTAMP [TIMESTAMP]   
A NULL NULL NULL NULL NULL NULL NULL 2020-11-13 07:26:03.650678200
MMM NULL NULL NULL NULL NULL NULL NULL 2020-11-13 07:26:03.670677500