1 In the Code First workflow, if the length of the string field in an entity is not specified, the data provider sets the default length to 2048 and 4096 bytes for unicode and non-unicode types respectively. However, if the length of the string field is set to a maximum allowed limit, that is 4000 bytes for unicode types and 8000 bytes for non-unicode types, the data provider resets it to 2048 bytes and 4096 bytes respectively. For all the other scenarios where the length of the string field is specified, the data provider uses the specified length.

Avg(expression)

avg(expression)

BigCount(expression)

count(expression)

Count(expression)

count(expression)

Max(expression)

max(expression)

Min(expression)

min(expression)

StDev(expression)

stdev(expression)

StDevP(expression)

stdevp(expression)

Sum(expression)

sum(expression)

Var(expression)

var(expression)

VarP(expression)

varp(expression)

Abs(value)

abs(value)

Ceiling(value)

ceiling(value)

Floor(value)

floor(value)

Round(value)

round(numeric_expression1, integer_expression2)

1 Requires PSQL v11.30 Update 4 (May 2013)

BitWiseAnd (value1, value2)

bit_and (value1, value2)

BitWiseNot (value)

BitWiseOr (value1, value2)

BitWiseXor (value1, value2)

Concat(string1, string2)

concat(string1, string2)

Contains(string, target)

contains(string, target)

EndsWith(string, target)

endswith(string, target)

IndexOf(target, string2)

instr(target, string2)

Left(string1, length)

left(string1, length)

Length(string)

length(string)

LTrim(string)

ltrim(string)

Trim(string)

trim (BOTH FROM string)

Replace(string1, string2, string3)

replace(string1, string2, string3)

Reverse(string)

reverse(string)

RTrim(string)

rtrim(string)

StartsWith(string, target)

startswith(string, target)

Substring(string, start, length)

ToLower(string)

lower(string)

ToUpper(string)

upper(string)