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

From Junwang Zhao
Subject Re: SQL Property Graph Queries (SQL/PGQ)
Date
Msg-id CAEG8a3+feGn3PAdyyv6Tv4MQXFcyHLQXF=1pO=0+9HcsbqyftA@mail.gmail.com
Whole thread Raw
In response to Re: SQL Property Graph Queries (SQL/PGQ)  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
List pgsql-hackers
On Mon, Dec 16, 2024 at 6:14 PM Ashutosh Bapat
<ashutosh.bapat.oss@gmail.com> wrote:
>
> 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.

Ok, then it makes sense to me. Thanks for the explanation.

>
> >
> > 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



--
Regards
Junwang Zhao



pgsql-hackers by date:

Previous
From: Artur Zakirov
Date:
Subject: Re: Added schema level support for publication.
Next
From: "Ryohei Takahashi (Fujitsu)"
Date:
Subject: RE: COPY performance on Windows