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

[Wolfgang]

for 8.0.0beta3.



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);



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

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 The so called big ones under these DBMS eat the following kind of join without complaining: the content of the patch reorders the parse tree to get the same result as this (working recursively for subselects etc.):

extend_syntax.tgz
Description: GNU Unix tar archive

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster