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

Reply via email to