In Postgres 16.2 I've a table Product with extra index: CREATE TABLE Product (id SERIAL , name: text, companyId: number, PRIMARY KEY (id)); CREATE INDEX product_company_id ON Product (companyId); The table has about 12M rows. When I search for a…
I have 2 tables: chat and chat_messages. I want to get only those chats which don't have chat_messages from users (they may have messages from other sources like admins). This code returns 0 records, I can't figure out why: message_count_subquery…
I have a column stored as jsonb which is an array of number. Values look like this I'd like to count the total distinct values from this column. I can get the distinct values like below SELECT DISTINCT JSONB_ARRAY_ELEMENTS_TEXT(aimjoined) AS…
Have the following messages table: ID OWNER TO MESSAGE DATE 1 y x Hello 1 2 y x World 2 3 z x Postgres 3 And users table: ID USERNAME x x y y z z Need to get data…
I want to query a table for where the number of identical values in one column is equal to the number distinct values in another column. I'm not sure how to phrase that better, so I think it best to…
I have the following schema in PostgreSQL 12: CREATE TABLE test_aggregate( id_semilavorato text NOT NULL PRIMARY KEY, array_allestimenti text[] ); INSERT INTO test_aggregate VALUES ('A',ARRAY['IDA1','IDA2']); INSERT INTO test_aggregate VALUES ('B',ARRAY['IDA1']); INSERT INTO test_aggregate VALUES ('C',ARRAY['IDA2']); INSERT INTO test_aggregate VALUES ('D',ARRAY['IDA3']);…
I am trying to make a simple SQL query in PostgreSQL to use in our team: with findData as ( select '(''XXX'',''YYYY'')' as dataList ) select * from findData That gives the result: ('XXX','YYYY') Exactly what I wanted ! But…
I have a database table holding 500k records. I need to load these records, do an API call, fetch data from this API endpoint, and save new data back to the database. I tried to do it like this (simplified…
I have the following snippet of a table that I am trying to filter some identities for: id fid ts val 44292 1243 2014-12-15 00:00:00.000 True 44292 1243 2017-02-02 00:00:00.000 False 44292 1250 2014-12-16 00:00:00.000 ABC 44293 1243 2014-12-15 00:00:00.000…
I get the following error when executing an sql query and can’t figure out what I’m doing wrong, please help me. The purpose of the query is to calculate the median cost of orders for all tables - even Text…