ArrayExpressionBuilder

API reference › yii › db › pgsql › ArrayExpressionBuilder

class	`yii\db\pgsql\ArrayExpressionBuilder`
Implements	`yii\db\ExpressionBuilderInterface`
Uses traits	`yii\db\ExpressionBuilderTrait`
Since	2.0.14
Source	`framework/db/pgsql/ArrayExpressionBuilder.php`

Class ArrayExpressionBuilder builds ArrayExpression for PostgreSQL DBMS.

Properties

Property	Type	Description	Defined by
`$queryBuilder` protected	`yii\db\QueryBuilder`	Default: `null`.	`yii\db\ExpressionBuilderTrait`

Method	Description	Defined by
`__construct()`	ExpressionBuilderTrait constructor.	`yii\db\ExpressionBuilderTrait`
`build()`	Method builds the raw SQL from the $expression that will not be additionally escaped or quoted.	`ArrayExpressionBuilder`
`buildPlaceholders()` protected	Builds placeholders array out of $expression values	`ArrayExpressionBuilder`
`buildSubqueryArray()` protected	Build an array expression from a subquery SQL.	`ArrayExpressionBuilder`
`getTypehint()` protected		`ArrayExpressionBuilder`
`typecastValue()` protected	Casts $value to use in $expression	`ArrayExpressionBuilder`

public function build(yii\db\ArrayExpression|yii\db\ExpressionInterface $expression, array &$params = []): string

Method builds the raw SQL from the $expression that will not be additionally escaped or quoted.

Parameters

Parameter	Type	Description
`$expression`	`yii\db\ArrayExpression\|yii\db\ExpressionInterface`	The expression to be built
`$params`	`array`	The binding parameters.

Returns

string: The raw SQL that will not be additionally escaped or quoted.

protected function buildPlaceholders(yii\db\ExpressionInterface|yii\db\ArrayExpression $expression, array &$params): array

Builds placeholders array out of $expression values

Parameters

Parameter	Type	Description
`$expression`	`yii\db\ExpressionInterface\|yii\db\ArrayExpression`
`$params`	`array`	The binding parameters.

Returns

array

protected function buildSubqueryArray(string $sql, yii\db\ArrayExpression $expression): string

Build an array expression from a subquery SQL.

Parameters

Parameter	Type	Description
`$sql`	`string`	The subquery SQL.
`$expression`	`yii\db\ArrayExpression`

Returns

string: The subquery array expression.

protected function getTypehint(yii\db\ArrayExpression $expression): string

Parameters

Parameter	Type	Description
`$expression`	`yii\db\ArrayExpression`

Returns

string: The typecast expression based on type.

protected function typecastValue(yii\db\ArrayExpression $expression, mixed $value): mixed

Casts $value to use in $expression

Parameters

Parameter	Type	Description
`$expression`	`yii\db\ArrayExpression`
`$value`	`mixed`

Returns

mixed