Re: IDS Feature Request List (including potential new requests).
Posted in 2006
Here is another request 3 in total:
tuple comparison. Hell it is even a part of the standard.
select * from company where (effective_date, termination_date) <
(select effective_date, termination_date from temp_company) ;
select * from employee where (sex, height, weight) >= ("M",6, 250) ;
I think that is the proper syntax.
So, in summary my current wish list is:
a) Shared Named server side prepared statements. (people are doing
similar things to try to duplicate the functionality)
b) multi-column select count distinct (implemented in other database
products)
c) n-tuple comparison in line with the standard. ( it is a standard and
I am tired of working around it with concatentation and padding
variables where needed)
d) civility on the c.d.i site. Except for really funny tongue in cheek
exchanges that waste lots of bandwidth.