Repository navigation
DiGi.PostgreSQL.Table.Enums
Specifies the logical operator to combine multiple filter conditions or groups.
public enum FilterLogicalOperatorAnd 0
Combines conditions or groups using logical AND.
Or 1
Combines conditions or groups using logical OR.
Specifies the comparison operator to be applied to a database column filter.
public enum FilterOperatorEquals 0
Checks if the column value is equal to the filter value. Applicable to both text and numeric columns.
NotEquals 1
Checks if the column value is not equal to the filter value. Applicable to both text and numeric columns.
GreaterThan 2
Checks if the column value is greater than the filter value. Applicable to numeric columns only.
GreaterThanOrEqual 3
Checks if the column value is greater than or equal to the filter value. Applicable to numeric columns only.
LessThan 4
Checks if the column value is less than the filter value. Applicable to numeric columns only.
LessThanOrEqual 5
Checks if the column value is less than or equal to the filter value. Applicable to numeric columns only.
In 6
Checks if the column value matches any of the values in the specified collection parameter. Applicable to both text and numeric columns.
NotIn 7
Checks if the column value does not match any of the values in the specified collection parameter. Applicable to both text and numeric columns.
Contains 8
Checks if the column value contains the filter string value as a substring (case-insensitive search). Applicable to text and string columns only.
IsNull 9
Checks if the column value is null. Applicable to all column types.
IsNotNull 10
Checks if the column value is not null. Applicable to all column types.
Specifies statistical and text-parsing aggregation calculations for multi-value column operations.
public enum MultivalueAggregateFunctionSplitDistinctCount 0
Splits multi-value string items by a separator, and counts unique sub-items.
SplitValueDistribution 1
Splits multi-value string items by a separator, groups them, and counts sub-item frequencies.
Specifies statistical aggregation calculations for single-value column operations.
public enum SinglevalueAggregateFunctionAvg 0
Calculates the average value of a column.
Sum 1
Calculates the sum total of a column.
Min 2
Finds the minimum value in a column.
Max 3
Finds the maximum value in a column.
Count 4
Counts the number of non-null records in a column.
DistinctCount 5
Counts the unique values in a column.