agefilter is used to express a filter based on the "age" of a timestamp at a particular date. Age can be passed with no parameters (indicating age at current date) or can be used with a parameter (indicating age at specified date).
valueis an ISO8601 duration format.
valueis any HDSI operator and an ISO8601 duration.
TimeSpanand the total seconds are used for comparison.
DateTimeOffsetobject to only the precision specified.
DateTimeOffsettruncated to only the portion specified.
@maxDateare computed in .NET based on precision where:
new DateTime(value.Year, 01, 01)
new DateTime(value.Year, 12, 31)
new DateTime(value.Year, value.Month, 01)
new DateTime(value.Year, value.Month, DateTime.DaysInMonth(value.Month)
similarity_levfilter acts similar to the similarity in that it uses the underlying database technology's GIN indexing to perform a similarity, however the final result is run through the
word_similarity_thresholdto 0.4 since SIN numbers with 5 edits would be represent a 60% difference in source strings.