| @@ 1550-1556 (lines=7) @@ | ||
| 1547 | return $this->mServer; |
|
| 1548 | } |
|
| 1549 | ||
| 1550 | public function buildGroupConcatField( |
|
| 1551 | $delim, $table, $field, $conds = '', $join_conds = [] |
|
| 1552 | ) { |
|
| 1553 | $fld = "LISTAGG($field," . $this->addQuotes( $delim ) . ") WITHIN GROUP (ORDER BY $field)"; |
|
| 1554 | ||
| 1555 | return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')'; |
|
| 1556 | } |
|
| 1557 | ||
| 1558 | /** |
|
| 1559 | * @param string $field Field or column to cast |
|
| @@ 1530-1536 (lines=7) @@ | ||
| 1527 | return implode( ' || ', $stringList ); |
|
| 1528 | } |
|
| 1529 | ||
| 1530 | public function buildGroupConcatField( |
|
| 1531 | $delimiter, $table, $field, $conds = '', $options = [], $join_conds = [] |
|
| 1532 | ) { |
|
| 1533 | $fld = "array_to_string(array_agg($field)," . $this->addQuotes( $delimiter ) . ')'; |
|
| 1534 | ||
| 1535 | return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')'; |
|
| 1536 | } |
|
| 1537 | ||
| 1538 | /** |
|
| 1539 | * @param string $field Field or column to cast |
|
| @@ 944-950 (lines=7) @@ | ||
| 941 | return '(' . implode( ') || (', $stringList ) . ')'; |
|
| 942 | } |
|
| 943 | ||
| 944 | public function buildGroupConcatField( |
|
| 945 | $delim, $table, $field, $conds = '', $join_conds = [] |
|
| 946 | ) { |
|
| 947 | $fld = "group_concat($field," . $this->addQuotes( $delim ) . ')'; |
|
| 948 | ||
| 949 | return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')'; |
|
| 950 | } |
|
| 951 | ||
| 952 | /** |
|
| 953 | * @throws MWException |
|
| @@ 1805-1811 (lines=7) @@ | ||
| 1802 | return 'CONCAT(' . implode( ',', $stringList ) . ')'; |
|
| 1803 | } |
|
| 1804 | ||
| 1805 | public function buildGroupConcatField( |
|
| 1806 | $delim, $table, $field, $conds = '', $join_conds = [] |
|
| 1807 | ) { |
|
| 1808 | $fld = "GROUP_CONCAT($field SEPARATOR " . $this->addQuotes( $delim ) . ')'; |
|
| 1809 | ||
| 1810 | return '(' . $this->selectSQLText( $table, $fld, $conds, null, [], $join_conds ) . ')'; |
|
| 1811 | } |
|
| 1812 | ||
| 1813 | /** |
|
| 1814 | * @param string $field Field or column to cast |
|