Operators and Functions | Learning Cypher

Functions

Functions are grouped by usage. Except for the COALESCE function, all of these functions return a null value if any argument has a null value.

COALESCE

The COALESCE function takes any number of parameters (at least one) and returns the first non-null value. It returns a null value only in case all the parameters have null values.

Usually, this function is used every time you have to deal with null values and want a fallback value in case of a null value. Consider the following query:

MATCH (aa:Book) 
WHERE 'novel' IN COALESCE(aa.tags, ['novel']) 
RETURN aa.title

This query returns all books that have novel in their tags, but will return all the books that do not have no tags set as well. In fact, if a book doesn't have the tags property, the COALESCE function will return the collection ['novel']. Therefore, the IN predicate will always succeed.

TIMESTAMP

The TIMESTAMP function takes no arguments and returns the number of milliseconds passed from the midnight of January 1, 1970. This function...

Tech Concepts

Programming languages

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning Cypher

By : Onofrio Panzarino

Learning Cypher

By: Onofrio Panzarino

Overview of this book

Functions

COALESCE

TIMESTAMP

Learning Cypher

By : Onofrio Panzarino

Learning Cypher

By: Onofrio Panzarino

Overview of this book

Functions

COALESCE

TIMESTAMP

Confirmation

Buy this book with your credits?

Submit Your Feedback

Create a Free Account To Continue Reading

Sign in to activate your 7-day free access