Environment:MS SQL Server 2005
Number of attachments :
The type for the EnterStore is set to Timestamp. But the data is retrived by start and end index.
alter table EntryStore add UpdateTimestamp timestamp not null
AND UpdateTimestamp > CAST(#startIndex# AS <include refid="timestampType"/>)
<isNotEqual property="endIndex" compareValue="-1">
AND UpdateTimestamp <= CAST(#endIndex# AS <include refid="timestampType"/>)
We changed this to BigInt and incremented each time a row is inserted. This seemed to work and match how postgres was using the column.