User Defined Function and Comparison Operator

[dautushenka]

I work with PostgreSQL. I implemented custom function for working with array type
DQL: CONTAINS(field, '{1,2}')
which should converted into SQL: field @> '{1,2}'
When I was trying to apply with function I got error:

[Syntax Error] line 0, col -1: Error: Expected =, <, <=, <>, >, >=, !=, got end of string.

After digging into the code I found out that parser requires comparison operator also.
I use following workaround:
CONTAINS(field,?1) = TRUE

I think we need to implement ability to create custom operators.

[Ocramius]

What's missing is probably a boolean function - we support string/date/numeric atm, but not boolean.

[dautushenka]

@Ocramius It also will fix the issue.

[zspine]

Seems like most of the PostgreSQL functions requires it. I had the same issue with jsonb functions.

$qb = $this->createQueryBuilder('u');
$qb->andWhere('JSONB_EXISTS(u.roles, :role) = TRUE');
$qb->setParameter('role', User::ROLE_OWNER);
return $qb->getQuery()->getResult();

@dautushenka Thanks a lot for sharing the workaround!!! I have been trying to debug this for more than 4 hours....

[esbobkov]

I have problem with Comparison Operator. I want to use POSIX Regular Expressions in Postgres. Operator is ~
But in not supported