Table of Contents

Class PostgreSQLSqlExpressionConvertVisitor

Namespace
LinqToDB.Internal.DataProvider.PostgreSQL
Assembly
linq2db.dll
public class PostgreSQLSqlExpressionConvertVisitor : SqlExpressionConvertVisitor
Inheritance
object
PostgreSQLSqlExpressionConvertVisitor
Inherited Members
Extension Methods

Constructors

PostgreSQLSqlExpressionConvertVisitor(bool) 

public PostgreSQLSqlExpressionConvertVisitor(bool allowModify)

Parameters

allowModify bool

Properties

ConcatRequiresExplicitStringCast

When true (default), ConvertConcat(SqlConcatExpression) wraps every non-string operand in an explicit CAST(... AS VARCHAR(N)) before adding it to the concat chain. Required for providers whose concat operator is + (SQL Server pre-2025, SqlCe, Sybase ASE, Access) — SQL-standard data-type precedence would otherwise try to coerce string operands to the non-string side's type. Providers whose final concat operator is || (PostgreSQL / Oracle / SQLite / SAP HANA / DuckDB / Firebird / DB2 / Informix / SQL Server 2025+) or CONCAT(...) function (MySQL / ClickHouse) auto-coerce non-string operands and override this to false for cleaner SQL.

protected override bool ConcatRequiresExplicitStringCast { get; }

Property Value

bool

SupportsNullInColumn 

protected override bool SupportsNullInColumn { get; }

Property Value

bool

Methods

ConvertConversion(SqlCastExpression)

Implements SqlCastExpression conversion.

protected override ISqlExpression ConvertConversion(SqlCastExpression cast)

Parameters

cast SqlCastExpression

Returns

ISqlExpression

ConvertSearchStringPredicate(SearchString) 

public override ISqlPredicate ConvertSearchStringPredicate(SqlPredicate.SearchString predicate)

Parameters

predicate SqlPredicate.SearchString

Returns

ISqlPredicate

ConvertSqlBinaryExpression(SqlBinaryExpression) 

public override IQueryElement ConvertSqlBinaryExpression(SqlBinaryExpression element)

Parameters

element SqlBinaryExpression

Returns

IQueryElement

ConvertSqlFunction(SqlFunction) 

public override ISqlExpression ConvertSqlFunction(SqlFunction func)

Parameters

func SqlFunction

Returns

ISqlExpression

VisitExprExprPredicate(ExprExpr) 

protected override IQueryElement VisitExprExprPredicate(SqlPredicate.ExprExpr predicate)

Parameters

predicate SqlPredicate.ExprExpr

Returns

IQueryElement

WrapColumnExpression(ISqlExpression) 

protected override ISqlExpression WrapColumnExpression(ISqlExpression expr)

Parameters

expr ISqlExpression

Returns

ISqlExpression