Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Subject: BUG #19542: Boolean syntax in GRAPH_TABLE
To: pgsql-bugs@lists.postgresql.org
From: PG Bug reporting form <noreply@postgresql.org>
Cc: h.lefebvre.69@gmail.com
Reply-To: h.lefebvre.69@gmail.com, pgsql-bugs@lists.postgresql.org
Date: Fri, 03 Jul 2026 13:25:52 +0000
Message-ID: <19542-97a0785e900e2fde@postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/19542-97a0785e900e2fde%40postgresql.org>
Precedence: bulk

The following bug has been logged on the website:

Bug reference:      19542
Logged by:          Herv=C3=A9 Lefebvre
Email address:      h.lefebvre.69@gmail.com
PostgreSQL version: 19beta1
Operating system:   Linux
Description:       =20

In MATCH clause you cannot use "WHERE boolean" Syntax. aka :

select * from GRAPH_TABLE (trajet MATCH ( a IS quai where
a.nom_station=3D'Place des F=C3=AAtes' )-[t IS dessert where t.correspondan=
ce ]->(b
IS quai) columns (a.nom_station as station1, a.num_ligne as ligne1,
b.nom_station as station2, b.num_ligne as ligne2, T.correspondance as
correspondance));
ERROR:  unrecognized node type: 63

You have to add " =3D true"  (ugly) :
select * from GRAPH_TABLE (trajet MATCH ( a IS quai where
a.nom_station=3D'Place des F=C3=AAtes' )-[t IS dessert where t.correspondan=
ce=3Dtrue
]->(b IS quai) columns (a.nom_station as station1, a.num_ligne as ligne1,
b.nom_station as station2, b.num_ligne as ligne2, T.correspondance as
correspondance));
    station1     | ligne1 |    station2     | ligne2 | correspondance
-----------------+--------+-----------------+--------+----------------
 Place des F=C3=AAtes | 7bis   | Place des F=C3=AAtes | 11     | t
 Place des F=C3=AAtes | 11     | Place des F=C3=AAtes | 7bis   | t
(2 rows)