JoshInnis edited a comment on issue #45: URL: https://github.com/apache/incubator-age/issues/45#issuecomment-982285644
Hello, A graph name is a schema and a label name is a table. Id and properties are columns in vertex table. Id, start_id, end_id, and properties are columns in the edge tables. Use the agtype_access_operator(properties, key) to get to get a property value. Knowing all that you can use Postges' standard DDL language to implement constraints, indices and unique values. ``` ALTER TABLE graph_name.label_name ADD CONSTRAINT constraint_name CHECK(agtype_access_operator(properties, "name_of_property") != '"Check against here"'::agtype); ``` -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
