yql/essentials/tests/sql/suites/select/substring_v1.sql


1
2
3
4
5
6
7

/* postgres can not */
/* syntax version 1 */
-- in v1 substring returns Null as a result for missing value
select
    substring(key, 1, 1) as char,
    substring(value, 1) as tail
from plato.Input;