From: | "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su> |
---|---|
To: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Re: subselects |
Date: | 1998-01-13 14:51:45 |
Message-ID: | 34BB7F81.2B9BD92F@sable.krasnoyarsk.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thomas G. Lockhart wrote:
>
> > > btw, to implement "(a,b,c) OP (d,e,f)" I made a new routine in the parser called
> > > makeRowExpr() which breaks this up into a sequence of "and" and/or "or" expressions.
> > > If lists are handled farther back, this routine should move to there also and the
> > > parser will just pass the lists. Note that some assumptions have to be made about the
> > > meaning of "(a,b) OP (c,d)", since usually we only have knowledge of the behavior of
> > > "a OP c". Easy for the standard SQL operators, unknown for others, but maybe it is OK
> > > to disallow those cases or to look for specific appearance of the operator to guess
> > > the behavior (e.g. if the operator has "<" or "=" or ">" then build as "and"s and if
> > > it has "<>" or "!" then build as "or"s.
> >
> > Sorry, I forgot something: is (a, b) OP (x, y) in standard ?
>
> Yes. The problem wouldn't be very interesting otherwise :)
Could we restrict OPs to standard ones (like we do for subselects) - I don't
like assumption about ORs for operators with "!" ?
"Assume as little as possible" is good rule...
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-01-13 15:24:30 | Re: [HACKERS] Re: subselects |
Previous Message | Bruce Momjian | 1998-01-13 14:48:00 | Re: [HACKERS] Re: subselects |