avilesj

avilesj

Hello community.

I am trying to perform the following query in Ecto

SELECT *
FROM table t 
where ARRAY[2, 12] <@ list_of_ids ;

The closest I have gotten to is

from t in Table,
where: fragment("ARRAY[?] <@ ?", ^list_of_ids, r.list_of_ids)

Performing this query returns the error

(Postgrex.Error) ERROR 42883 (undefined_function) operator does no
t exist: text[] <@ integer[]

Now, I am confident the value of ^list_of_ids is a list of integers. Even so, if I hard code the values in the fragment, it works.

from t in Table,
where: fragment("ARRAY[?] <@ ?", [2,12], r.list_of_ids)

Last night I was searching about similar queries and the only similar issue I was able to find was this one in SO..

I made it work through raw query → Repo.load but I would like to know the real syntax for this operation.

So, my question is:

What is the proper Ecto syntax to accomplish what I am trying to do?

Thank you all.

Showing Posts 1 to 3

LostKobrakai

LostKobrakai

t0t0

t0t0

Hi,

you shouldn’t have to wrap your values between ARRAY[], could you try:

  • fragment("? <@ ?", ^list_of_ids, r.list_of_ids)
  • fragment("?::INT[] <@ ?", ^list_of_ids, r.list_of_ids)
  • fragment("? <@ ?", type(^list_of_ids, {:array, :integer}), r.list_of_ids)
  • fragment("? <@ ?", type(^list_of_ids, r.list_of_ids), r.list_of_ids)

Nevermind, I believed that Ecto was smart enough to handle it directly (without splice/1) and the problem was related to typing (this is quite frequent with PostgreSQL).

andreh

andreh

Common, this is too good to be true! I’ve just removed 2 round-trips to the database and 15 lines of code thanks to you. You made my day!

— All posts loaded —

Where Next? Top

Trending in Questions Top

RSP87
I’m working on a project that simulates the bumbl example in the programming phoenix book. It acts almost like an email client. We have a...
New
nseaSeb
Hello, I know there is an approach for handling lists that allows for optimized traversal, but I can’t recall the specific method (somet...
New
kpanic
Hi everyone, I am toying with the idea of building a “match maker” for giving personal help to people that wants to start coding. I sta...
New
brecabral
Documentation While reading the Scoped Routes section, I noticed that the documentation currently refers to a problem without explainin...
New
velrest
So my question is quite simple and i have found no conclusive answer on forum, google or AI. Should we use :erlang.float for Integer to ...
New
asweet-confluent
I recently noticed that Elixir’s Logger defaults its primary log level to :debug when no :logger, :level application configuration is pre...
New
apz
I’m new to elixir and just tried to install the elixirLS extension for VScode(ium) and it is throwing some errors that I would like help ...
New

Other Trending Topics Top

GenericJam
Edit: 2026 May 15 - This post is archived. Mob is alive!! Main docs: mob v0.7.11 — Documentation A bit of explanation for the slightly c...
New
JesseHerrick
Hey, I’m Jesse and I’m the main contributor behind Dexter, a full-featured, lightning-fast Elixir LSP optimized for large codebases. It s...
New
mudasobwa
I am happy to introduce the very α version of the new programming language compiled to BEAM. Welcome Cure. It has literally three kille...
New
marciok
Hi there! We created Gust: A task orchestrator inspired by Airflow. For those who have never heard about Aiflow, it’s a Python-based wor...
New
mhanberg
Hi everyone! The first release candidate for the Expert language server project is now available! We’ve published a press release detai...
New
jimsynz
Beam Bots (or just BB for short) is a framework for building fault-tolerant robotics applications in Elixir using familiar OTP patterns. ...
New

We're in Beta

About us Mission Statement

Options

Thread Display Mode




Thread Preview

Skip Thread Previews