Postgres operator does not exist:

Question

Here's my code:

.having('(COUNT(DISTINCT taggings.tag_id) = 0 OR array[?] <@ array_agg(taggings.tag_id))', tag_ids)

I am getting the followint error when executing the above query:

ActiveRecord::StatementInvalid: PG::UndefinedFunction: ERROR:  operator does not exist: text[] <@ integer[]
LINE 1: ...OUNT(DISTINCT taggings.tag_id) = 0 OR array[NULL] <@ array_a...
                                                             ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.

I'm new to the postgresql, can anyone please point the solution?

klin · Accepted Answer · 2017-11-20 21:24:34Z

3

You should explicitly cast the array to int[], because array[null] is resolved as text[].

... OR array[?]::int[] <@ array_agg(taggings.tag_id)

answered Nov 20, 2017 at 21:24

klin

123k15 gold badges240 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres operator does not exist:

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related