User Tools

Site Tools


development

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
development [2018/03/21 17:03]
yzan [Pattern development]
development [2018/03/25 17:15] (current)
yzan [Data types]
Line 68: Line 68:
   * Boolean type is automatically casted to {0,1} if treated as numerical.   * Boolean type is automatically casted to {0,1} if treated as numerical.
   * Not all functions may work with Longvarchar and longnvarchar types. This is database specific.   * Not all functions may work with Longvarchar and longnvarchar types. This is database specific.
-  * We can group by xml, floating point numbers and timestamps, but the gain from that in well typed dbs is questionable.+  * We can group by xml, floating point numbers and timestamps, but the gain from that in well typed dbs is questionable.  
 +  * We may extract year, month, day in week,... from timestamps and only then treat timestamps as nominal. 
 +  * We may treat timestamps as numerical by calculating datediff(@temporalColumn,​ @baseDate) if @baseDate is available, otherwise calculate datediff(@temporalColumn,​ "​1.1.2000"​).
 ==== Naming convention for patterns ==== ==== Naming convention for patterns ====
   * bare name, if possible, to keep the names short   * bare name, if possible, to keep the names short

Page Tools