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

From Henson Choi
Subject Re: SQL Property Graph Queries (SQL/PGQ)
Date
Msg-id CAAAe_zDgc-G20EdJwoFk2mV25LeuqHh66AeX39s6GSkx37fNjQ@mail.gmail.com
Whole thread Raw
In response to Re: SQL Property Graph Queries (SQL/PGQ)  (Junwang Zhao <zhjwpku@gmail.com>)
List pgsql-hackers
 Hi Junwang,

> 1.3 Supported by Oracle, not PG
>
> a.* star reference in COLUMNS
>   Oracle allows COLUMNS (a.*) to return all properties of an element
>   variable across all its labels. PG rejects this ("*" not allowed
>   here). A workaround exists: list properties explicitly. This is the
>   only SQL/PGQ query execution capability where Oracle is ahead of the
>   current PG implementation.

PGQ doesn’t seem to reject a.*. I think PostgreSQL is still at an early stage
of supporting SQL/PGQ, so missing features like this are acceptable for
now, and we can add support for more syntax in the future.

I agree — a.* in COLUMNS is better addressed in a follow-up patch.

Regards,
Henson

pgsql-hackers by date:

Previous
From: Junwang Zhao
Date:
Subject: Re: SQL Property Graph Queries (SQL/PGQ)
Next
From: Henson Choi
Date:
Subject: Re: Row pattern recognition