query on smallint array column

From: Zhihong Yu <zyu(at)yugabyte(dot)com>
To: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: query on smallint array column
Date: 2020-12-13 17:43:10
Message-ID: CALNJ-vSg--Gup5jwrKv4GP50gzk8Gtq1qunNjudu=n7barorEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
I was experimenting with the following query.

create table sint1(k int primary key, arr smallint[]);
create index s1 on sint1(arr);
insert into sint1 select s, array[s*s, s] FROM generate_series(1, 10) AS s;
select * from sint1 where arr @> array[4];
ERROR: operator does not exist: smallint[] @> integer[]
LINE 1: select * from sint1 where arr @> array[4];
^
HINT: No operator matches the given name and argument types. You might
need to add explicit type casts.
-------

I wonder if someone can enlighten me on the correct way to perform the type
cast.

Thanks

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2020-12-13 17:50:47 Re: query on smallint array column
Previous Message Andrey Borodin 2020-12-13 17:24:49 Re: MultiXact\SLRU buffers configuration