Re: SQL Property Graph Queries (SQL/PGQ) - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: SQL Property Graph Queries (SQL/PGQ)
Date
Msg-id CAExHW5uA3xwiqCSXz7snCcRBhNe5A-rPTsKS+pUHhE07uJi-Yg@mail.gmail.com
Whole thread Raw
In response to Re: SQL Property Graph Queries (SQL/PGQ)  (Junwang Zhao <zhjwpku@gmail.com>)
Responses Re: SQL Property Graph Queries (SQL/PGQ)
List pgsql-hackers
Hi Junwang,

>
> I'm looking at the catalog definition, I have some questions which
> might be silly.

Thanks for your interest in SQL/PGQ.

>
> Each pg element can have multiple labels(whose properties belong
> to the same pg element), can we have multiple elements share the
> same label?

Yes. A label can be shared between edges and vertices as well.

>
> If we have a 1..* relation between element and label, I think maybe
> we don't need _pg_propgraph_label_.

pg_propgraph_label is used to map a label name in a given property
graph to its OID. pg_propgraph_element_label - can be used to find all
the elements with a given label and all the labels of a given element.
The relationship is many to many.

>
> From the name _pg_propgraph_label_property_, I tend to think it is
> referencing _pg_propgraph_label_, but actually it is referencing
> _pg_propgraph_element_label_.
>

Right.

-- 
Best Wishes,
Ashutosh Bapat



pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: Sort functions with specialized comparators
Next
From: Amit Kapila
Date:
Subject: Re: DOCS: pg_createsubscriber wrong link?