Lecturer or Associate Professor in Computer Science at University of Leeds

New capabilities planned for the next edition of GQL

Major capabilities

1. 1.Conditional execution of statements
2. 2.VECTOR data type and vector operations
3. 3.Integrity constraints
4. 4.Abstract element types

Incremental enhancements

1. 1.Reference individual list elements (using list[] syntax)
2. 2.PRODUCT in aggregate functions
3. 3.GROUP BY ALL shorthand
4. 4.Endpoint predicates
5. 5.CAST error behavior
6. 6.NULLS NOT DISTINCT
7. 7.Match and Run
8. 8.Unicode Case-folding

MATCH (a: Person)
CALL {
 WHEN BINDING (a)-[: OWNS] -> (b: Movie)
 THEN
  RETURN "has at least movies" AS msg, count (b) AS num
 WHEN BINDING (a) -[: OWNS]-> (b: Book)
 THEN
  RETURN "has only books" AS msg, count (b) AS num
ELSE RETURN "has no media" AS msg, 0 AS num
}
RETURN *

Swansea University project uses vintage computers to build digital confidence

MSc Computer Science with Business Analytics

#PostgreSQL 19 interactive tour:

```