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