Subject | RE: [Firebird-Architect] IN LIST |
---|---|
Author | Leyne, Sean |
Post date | 2006-12-03T21:55:29Z |
Steve,
The "IN LIST" feature would resolve 99% of issues I have with the IN
clause.
The "short-cutting" of the list is at best a 'nice to have'.
Sean
> I think the problem here is the fact that the subranging and theI completely agree.
> "list"-ing part are being mixed.
>
> As I see it, they're separate ideas that don't need to be considered
> together.
> Issue 1: The fact that "In" clauses are evaluated as if they were aAgain, I completely agree.
> chain of "OR's", as in
> Issue 2: It might be nice (i.e., "syntactic sugar") to be able to say
> "1,2,3,4" with "1-4", or more likely, to avoid 1-4 looking like "-3",
> with "1..4".
> Personally, I'd love to see the first feature implemented.
> I've had
> cases where the ability to specify an "In :List" as a parameter would
> have been very useful.
The "IN LIST" feature would resolve 99% of issues I have with the IN
clause.
The "short-cutting" of the list is at best a 'nice to have'.
Sean