ydb icon indicating copy to clipboard operation
ydb copied to clipboard

List all supported predicates in documentation

Open OSA413 opened this issue 2 years ago • 2 comments

I want to check if a value starts with some substring, I tried to search it in the WHERE section but with no luck. https://ydb.tech/en/docs/yql/reference/syntax/select#where

OSA413 avatar Jul 05 '22 06:07 OSA413

I want to check if a value starts with some substring, I tried to search it in the WHERE section but with no luck. https://ydb.tech/en/docs/yql/reference/syntax/select#where

That's listed in Built-in functions section: StartsWith, EndsWith

eoan-ermine avatar Jul 06 '22 17:07 eoan-ermine

I want to check if a value starts with some substring, I tried to search it in the WHERE section but with no luck. https://ydb.tech/en/docs/yql/reference/syntax/select#where

That's listed in Built-in functions section: StartsWith, EndsWith

Built-in functions section of documentation is a right place to look for such things: https://ydb.tech/en/docs/yql/reference/builtins/basic

WHERE clause accepts arbitrary expressions, so everything returning bool (or bool?) is supported.

spuchin avatar Jul 16 '22 20:07 spuchin