syntax extension for unsupported JOINs coming from a binary only (unmodifyable) program

From: Wolfgang <wh(at)ibas-labs(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: syntax extension for unsupported JOINs coming from a binary only (unmodifyable) program
Date: 2005-11-22 22:17:12
Message-ID: 438398E8.8030508@ibas-labs.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Here are some little changes to the postgreSQL server backend I found
beeing convenient for me
while I was attempting to get interoparability with a binary only
program. The patch attached is tested and works
for 8.0.0beta3.
The so called big ones under these DBMS eat the following kind of join
without complaining:

select a.val1, b.val2, c.val3 from
t1 a left outer join t2 b on (a.id1=b.id2),
t1 left outer join t3 c on (a.id1=c.id3);

the content of the patch reorders the parse tree to get the same result
as this (working recursively for subselects etc.):

select a.val1, b.val2, c.val3 from
t1 a left outer join t2 b on (a.id1=b.id2)
left outer join t3 c on (a.id1=c.id3);

Wolfgang

Attachment Content-Type Size
extend_syntax.tgz application/x-gtar 8.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-11-22 22:37:44 A few pgindent oddities
Previous Message Bruce Momjian 2005-11-22 21:03:51 Re: Time for pgindent?