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