How to fix could not find array type for data type text[] error

Question

I have tried following to find item in a array

import {Any} from "typeorm";

const loadedPosts = await connection.getRepository(Post).find({
    countries: Any(["Sri Lanka", "Nepal"])
});

but I am getting this error [QueryFailedError] could not find array type for data type text[]

my entity column define like this

@IsNotEmpty()
@Column("text", {array: true})
public countries: string[];

jboot · Accepted Answer · 2020-07-29 07:11:31Z

2

If I understand your question correctly, you have a Post entity with a countries column of type text[]. You then try to find posts that have at least one of the following countries: "Sri Lanka" or "Nepal".

This is not a TypeORM issue. It is currently not possible in PostgreSQL to find any records that have these kind of intersections using two arrays and the ANY() function. Instead try to use an array operator, such as @>.

Please have a look at the last part of Sudharsan Thumatti's answer in the following similar question: https://stackoverflow.com/a/54069718/3298175

Please note that array functions aren't always performant as someone might expect. Perhaps you are better off with a second table called countries that has a foreign key to posts in stead, creating a one-to-many relation. A junction table could help as well if you would prefer a many-to-many relation, allowing you to reuse the countries table.

edited Jul 29, 2020 at 7:11

user330315

answered Jul 29, 2020 at 6:59

jboot

87112 silver badges20 bronze badges

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

2 Comments

Sandun Tharaka Over a year ago

but according to documentations they have Any option github.com/typeorm/typeorm/blob/master/docs/…

jboot Over a year ago

That’s correct, but you can’t use that on a field that already is an array. Right now you are checking if there is an array that equals one of the following texts. That comparison is flawed and results in an error. It would work if the Post’s field would be a single country of type text, but it doesn’t work on arrays.

Collectives™ on Stack Overflow

How to fix could not find array type for data type text[] error

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related