'SELECT query with same label node using PGQL

We are trying to write PGQL select query on PG View(version 21.4) to retrieve all nodes using label.

We had being using the following link as our PGQL guideline. https://pgql-lang.org/spec/1.4/#writing-simple-queries

Node Table:

  • Database table: NODE
  • Columns: ID, LABEL, PROPERTIES, CREATEDBY, CREATEDDATETIME

Example select query: SELECT n.* FROM MATCH (n:DATA) ON GRAPH

ERROR: vertex label does not exist.

It will return result if :DATA is remove. What would had cause the error since it was working on PGS. Any solution or workaround would be appreciated.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source