postgresql-for-doctrine

postgresql-for-doctrine copied to clipboard

Adds support for `EXTRACT(DAY FROM timestamp)`: https://www.postgresql.org/docs/current/functions-datetime.html

keithbrink

ARRAY with multiple arguments

2

I'd like to use this kind of postgres code `Array_to_string(ARRAY['a', 'b', 'c'], ';')` which gives `a;b;c` but this does not parse in dql : ``` ARRAY_TO_STRING( ARRAY( 'a', 'b', 'c'...

flaushi

jsonb type is interpreted as json in doctrine migrations

6

When creating an entity with a jsonb field and generating a migration with doctrine migrations, the migration defines the field as JSON, which forces me to fix that mannually each...

vbourdeix

Unknown database type text[] requested, Doctrine\DBAL\Platforms\PostgreSQL100Platform may not support it.

2

I was already using this extension for some functions and tried using the `text[]` type but doctrine thrown this exception when I tried to use it in an entity. I...

mathroc

Arithmetic expression inside greatest() leads to infinite parsing loop

1

I noticed that using an arithmetic operation inside greatest() causes parser to enter an infinite loop. My `doctrine/dbal` is at version `2.12.1`. Consider this working example: ```php $result = $this->doctrine...

sjuvonen

Add CAST function

1

probable realization same as mysql https://github.com/beberlei/DoctrineExtensions/blob/master/src/Query/Mysql/Cast.php

Gemorroj

JsonbArray returns malformed result

2

I have a field that has `jsonb[]` type. I want to add multidimensional array data to that field. But PostgreSQL returns an error. I tried to find what is wrong...

delirehberi

arrays in Symfony Forms

4

I'm trying to implement a data transformer to save integer[] values in a postgres database using the bundle. ```php // some entity with tags /** * @ORM\Column(type="integer[]", nullable=true) */ protected...

tacman

Range types (mainly tstzrange, tsrange and daterange)

1

Awesome project! When you have time, could you add support for the built-in range types in Postgres? https://www.postgresql.org/docs/current/rangetypes.html For the date based ranges, it would be really cool if it...

adaliszk

Enum type

4

Hi, I have a question. Is it possible to add enum type? I really like your work, it contains most missing features of postgres database. Only one thing missing and...

bednic