Release Notes For v0.3.0

• Added openCypher functionality for standard and user defined functions.

  • Added the following openCypher functions:
    • Trigonometric: e, sqrt, exp, log, log10, degrees, radians, pi, sin, cos, tan, asin, acos, atan, & atan2.
    • String: replace, split, left, right, substring, rTrim, lTrim, trim, toUpper, toLower, reverse, & toString.
    • Numeric: rand, abs, ceil, floor, round, & sign.
  • Added user defined functions of the form:
    • schema.function

• Currently working on aggregate function support.

  • Added the following openCypher aggregate functions:
    • min, max, stDev, stDevP, percentileCont, percentileDisc & count.
    • avg & sum are added but may need to be reworked.

• Added Exists clause:

  • exists(property)
  • exists(pattern)

• Property Constraints

  • The MATCH clause supports using property constraints.

• Set Clause Added

  • Support for updating a single property value
  • Multiple SET clauses can be used in a single query
  • Supported to work with MATCH, CREATE, and REMOVE clauses

• Remove Clause Added

  • Support for removing a single property values
  • Multiple REMOVE clauses can be used in a single query
  • Supported to work with MATCH, CREATE, and SET clauses

• Define Extension’s Behaviour when dropped

  • Added a process to occur when the extension is dropped in Postgres.

Release Notes For v0.2.0

• Extend Agtype
  • Support for Numeric types.
  • Support for Edge types.
  • Support for Path types.
• Type Casting
  • Type annotations ‘::’ can be added to scalar values, arrays and objects.
  • Casting to a numeric ‘::numeric’ from an integer, float, or string.
  • Casting to a float ‘::float’ from an integer, numeric, or string.
  • Addition of float constants (inf, -inf, NaN) to string input and output.
  • Casting to a vertex ‘::vertex’ from an agtype object.
  • Casting to an edge “::edge’ from an agtype object.
  • Casting to a path ‘::path’ from an agtype array.
• Scalar Functions
  • id() Returns the id of a vertex or edge.
  • start_id() Returns the start id of a vertex or edge.
  • end_id() Returns the end id of a vertex or edge.
  • type() Returns the relationship name of an edge.
  • properties() Returns the properties object of a vertex or edge.
  • head() Returns the head of a list.
  • last() Returns the last element in a list.
  • length() Returns the length of a path.
  • size() Returns the length of a string or the number of elements in a list.
  • startNode() Returns the start vertex for an edge.
  • endNode() Returns the end vertex for an edge.
  • timestamp() Returns the system time in milliseconds from Epoch.
  • toBoolean() Converts a string to a boolean.
  • toFloat() Converts an integer, numeric, or string to a float.
  • toInteger() Converts a float, numeric, or string to an integer.
  • coalesce() Returns the first non null expression in a list of expressions.
• Labels for Vertices/Edges
  • Newly created Edges can be assigned with a label.
  • Newly created Labels vertices do not require a label.
• Improve Match Clause
  • Support Edges - Match clauses support paths.
  • Support Patterns - Match clauses support multiple paths.
  • Support Vertices with no variable assignment.
  • Support Edges and Paths with variable assignment.
• Improve Create Clause
  • Support Edges - Create Clause supports paths.
  • Support Patterns - Create Clause supports multiple paths.

Release Notes For v0.1.0

This release supports the following openCypher clauses.

• CREATE clause with a node that has a label
  • It must be in queries by itself.
• MATCH clause with a node that has a label
• RETURN clause without aggregation
• WITH clause without aggregation

Function call expression is not supported.

For more information, please refer to the documentation in doc/ directory.