Add support for aggregate functions (COUNT, SUM, etc)

Activity

Show:
Diego Bosca
January 11, 2021, 12:43 PM

In fact as we use ISO dates order is directly related to string order

Thomas Beale
January 11, 2021, 7:02 PM

I would suggest that if MIN() and MAX() can be used with Strings in real world SQL implementations, then it’s ok for us (although weird for me!); but if not, I wouldn’t do it.

Diego Bosca
January 11, 2021, 7:24 PM

Funny thing is that most SQL implementations support min and max over strings (maybe just an alias of 'Select stringvalue from table order by stringvalue ASC|DESC limit 1')

In XQuery, min and max functions can be applied over any atomic type, i.e number types dates, times, string and even boolean

Matija Polajnar
January 13, 2021, 5:48 AM

Typo in multiple places: “Integer of Real”; you meant “Integer or Real”.

Pieter Bos
21 hours ago

In fact, the RM model has a notion of ordered objects - every DV_ORDERED for example. But I guess it’s ok not to support that here.

Reporter

Sebastian Iancu

Raised By

Diego Bosca

Components

Affects versions

Configure