@@ 1483-1489 (lines=7) @@ | ||
1480 | return $this->mServer; |
|
1481 | } |
|
1482 | ||
1483 | public function buildGroupConcatField( |
|
1484 | $delim, $table, $field, $conds = '', $join_conds = [] |
|
1485 | ) { |
|
1486 | $fld = "LISTAGG($field," . $this->addQuotes( $delim ) . ") WITHIN GROUP (ORDER BY $field)"; |
|
1487 | ||
1488 | return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')'; |
|
1489 | } |
|
1490 | ||
1491 | /** |
|
1492 | * @param string $field Field or column to cast |
@@ 1664-1670 (lines=7) @@ | ||
1661 | return 'CONCAT(' . implode( ',', $stringList ) . ')'; |
|
1662 | } |
|
1663 | ||
1664 | public function buildGroupConcatField( |
|
1665 | $delim, $table, $field, $conds = '', $join_conds = [] |
|
1666 | ) { |
|
1667 | $fld = "GROUP_CONCAT($field SEPARATOR " . $this->addQuotes( $delim ) . ')'; |
|
1668 | ||
1669 | return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')'; |
|
1670 | } |
|
1671 | ||
1672 | public function buildStringCast( $field ) { |
|
1673 | return $field; |
@@ 1282-1288 (lines=7) @@ | ||
1279 | return implode( ' || ', $stringList ); |
|
1280 | } |
|
1281 | ||
1282 | public function buildGroupConcatField( |
|
1283 | $delimiter, $table, $field, $conds = '', $options = [], $join_conds = [] |
|
1284 | ) { |
|
1285 | $fld = "array_to_string(array_agg($field)," . $this->addQuotes( $delimiter ) . ')'; |
|
1286 | ||
1287 | return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')'; |
|
1288 | } |
|
1289 | ||
1290 | public function buildStringCast( $field ) { |
|
1291 | return $field . '::text'; |
@@ 918-924 (lines=7) @@ | ||
915 | return '(' . implode( ') || (', $stringList ) . ')'; |
|
916 | } |
|
917 | ||
918 | public function buildGroupConcatField( |
|
919 | $delim, $table, $field, $conds = '', $join_conds = [] |
|
920 | ) { |
|
921 | $fld = "group_concat($field," . $this->addQuotes( $delim ) . ')'; |
|
922 | ||
923 | return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')'; |
|
924 | } |
|
925 | ||
926 | /** |
|
927 | * @param string $oldName |