cannot use ^xxx outside of match clauses

Question

This function:

defp entries(query, page_number, page_size) do
  offset = page_size * (page_number - 1)

  query
  |> limit([_], ^page_size) # error
  |> offset([_], ^offset)
  |> Repo.all
end

gives an exception:

cannot use ^pg_size outside of match clauses

Why is that and how to fix it?

score 117 · Accepted Answer · answered Aug 09 '16 at 07:14

117

This is most usually a sign that you haven't imported appropriate macros from Ecto.Query.

answered Aug 09 '16 at 07:14

michalmuskala

11,028
2
36
47

The ones that you attempt to use: limit and offset. – michalmuskala Aug 09 '16 at 07:30
`import Ecto.Query`. I would strongly suggest going through http://elixir-lang.org/getting-started/alias-require-and-import.html and https://hexdocs.pm/ecto/Ecto.Query.html if you haven't already. – michalmuskala Aug 09 '16 at 09:16
Is it possible to report root cause error for this problem? – Karlo Smid Apr 14 '20 at 16:31

score 0 · Answer 2 · answered Aug 09 '16 at 07:08

0

Try this:

query
|> limit(page_size)
|> offset(offset)
|> Repo.all

answered Aug 09 '16 at 07:08

NoDisplayName

15,246
12
62
98

score 0 · Answer 3 · answered Sep 27 '19 at 11:45

0

Another possible cause for this error is misspelled words. In my case it was form instead of from.

answered Sep 27 '19 at 11:45

pdamoc

2,798
15
19

score -1 · Answer 4 · answered Nov 27 '18 at 00:42

-1

You must use ^ (pin operator - https://hexdocs.pm/elixir/Kernel.SpecialForms.html)

query
|> limit(^page_size)
|> offset(^v_offset) # I don't know if offset var override offset function of Ecto
|> Repo.all

answered Nov 27 '18 at 00:42

Gilvan Souza

89
1
1

cannot use ^xxx outside of match clauses

4 Answers4