Re: [HACKERS] [6.5.2] join problems ...

Yes, sorry. Typo. I MEANT to put the parens around
the field list, but...

Mike Mascari

--- Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
wrote:
> <snip>
> > > AND (a.id,a.mid = b.id,b.mid)
> > > AND (b.catid,b.indid,b.divid =
> c.id,c.ppid,c.pid);
> > ... the above is not valid in PostgreSQL, it
> seems...
>
> I have to resort to looking at gram.y for this,
> since I currently have
> the Postgres parser in bits and pieces all over the
> garage floor ;)
>
> The expressions are *almost* valid for Postgres. The
> difference is
> that you need to put parens around each side of the
> "row expression":
>
> | '(' row_descriptor ')' row_op '('
> row_descriptor ')'
> {
> $$ = makeRowExpr($4, $2, $6);
> }
> ;
>
> I had implemented this using Date and Darwen as a
> reference, and afaik
> the SQL standard (and any sensible parser)
> *requires* parens around
> the row expression, referred to in gram.y as a "row
> descriptor".
>
> So, the following should work:
>
> AND ((a.id,a.mid) = (b.id,b.mid))
> AND ((b.catid,b.indid,b.divid) =
> (c.id,c.ppid,c.pid));
>
>
> - Thomas

__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.com