postgresql-for-doctrine

postgresql-for-doctrine copied to clipboard

array_agg doesn't support ORDER BY

1

When I use the function like this `array_agg(d.startDate ORDER BY d.startDate DESC)`, I get en error "[Syntax Error] line 0, col 64: Error: Expected Doctrine\\ORM\\Query\\Lexer::T_CLOSE_PARENTHESIS, got 'ORDER'" Please fix it.

olek07

Postgres 14-specific JSON syntax

1

In reviewing the documentation for Postgres 14, I saw this: > PostgreSQL has supported manipulating [JSON](https://www.postgresql.org/docs/14/datatype-json.html) data since the release of PostgreSQL 9.2, though retrieval of values used a unique...

tacman

jsonb_build_object support?

1

Hello! Do you have support for jsonb_build_object function?

alexinteam

Implement the `cast` function: https://www.postgresql.org/docs/current/sql-createcast.html

mpiot

I want to get sql like `select (np.params::json)->> 'slug'`, `np.params` is a text field DDL: ```sql JSON_GET_FIELD_AS_TEXT(TO_JSON(np.params), 'slug') ``` Finally got an error: `Doctrine\ORM\Query\QueryException: [Syntax Error] line 0, col 110:...

dmitryuk

This issue lists Renovate updates and detected dependencies. Read the [Dependency Dashboard](https://docs.renovatebot.com/key-concepts/dashboard/) docs to learn more.[View this repository on the Mend.io Web Portal](https://developer.mend.io/github/martin-georgiev/postgresql-for-doctrine). ## Open These updates have all been...

renovate[bot]

This is a follow-up for #177 * Update `composer.json` to (re)allow Doctrine ORM v3 & Lexer v3 * Use `Doctrine\ORM\Query\TokenType` over deprecated/removed lexer constants * Migrate entity fixtures to attributes

GwendolenLynch

[](https://renovatebot.com) This PR contains the following updates: | Package | Change | Age | Adoption | Passing | Confidence | |---|---|---|---|---|---| | [phpunit/phpunit](https://phpunit.de/) ([source](https://togithub.com/sebastianbergmann/phpunit)) | `^10.5.10` -> `^11.0.3` |...

renovate[bot]

See the [release statement](https://www.doctrine-project.org/2024/02/03/doctrine-orm-3-and-dbal-4-released.html). Current version can't be required by a default symfony [webapp](https://symfony.com/doc/current/setup.html#creating-symfony-applications) installation.

adrianrudnik

Cannot use object of type Doctrine\Common\Lexer\Token as array

1

Hi, Juste upgraded to 8.3 and the UNACCENT function throws an error : ``` Error: Cannot use object of type Doctrine\Common\Lexer\Token as array at vendor/martin-georgiev/postgresql-for-doctrine/src/MartinGeorgiev/Doctrine/ORM/Query/AST/Functions/BaseVariadicFunction.php:24 at MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\BaseVariadicFunction->feedParserWithNodes(object(Parser)) (vendor/martin-georgiev/postgresql-for-doctrine/src/MartinGeorgiev/Doctrine/ORM/Query/AST/Functions/BaseFunction.php:50) at MartinGeorgiev\Doctrine\ORM\Query\AST\Functions\BaseFunction->parse(object(Parser))...

pesseyjulien