JourneyToSilius commented on issue #1635: URL: https://github.com/apache/age/issues/1635#issuecomment-2146281375
@NathanFrund here is a demo implementation of how I did it in Go: ``` func (s *store) CreateUniquePropertyFunction() error { queryFormat := `CREATE OR REPLACE FUNCTION graph.aggregated.get_vertex_address(properties agtype) RETURNS agtype AS $BODY$ SELECT graph.ag_catalog.agtype_access_operator($1, '"address"'); $BODY$ LANGUAGE sql IMMUTABLE;` _, err := s.AgePoolConnector.Pool.Exec(context.Background(), queryFormat) if err != nil { return fmt.Errorf("failed to execute query: %v", err) } return nil } func (s *store) CreateUniqueVertexConstraint() error { queryFormat := `CREATE UNIQUE INDEX idx_v2vertex_address_constraint ON graph.aggregated.v2vertex(get_vertex_address(properties));` _, err := s.AgePoolConnector.Pool.Exec(context.Background(), queryFormat) if err != nil { return handleQueryError(err) } return nil } ``` -- 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