I try to remove pixelId":"AW-23423524124" from the array and in case its the only one in the array trackingIds than remove the entire object of pxg. it does not work using PostgreSQL UPDATE clicks SET protection_config = CASE WHEN protection_config…
here's a sample from my table in Metabase PostgreSQL: timestamp 2023-01-25T05:00:01+03:00 2023-01-25T05:01:01+03:00 2023-01-25T05:05:01+03:00 2023-01-25T05:13:01+03:00 2023-01-25T05:14:01+03:00 2023-01-25T05:20:01+03:00 2023-01-25T05:24:01+03:00 2023-01-25T05:29:01+03:00 I want to group by 15-minute interval and count events that happen in the interval: timestamp count 2023-01-25T05:00 5 2023-01-25T05:15 3 this…
How to add a subquery to the query to display the last message in the room? Chat rooms id, type(USER_TO_USER, USER_TO_SHOP, USER_TO_PLATFORM), name list of messages room_messages - id, participant_id, text, is_read my query select r.id, r.name from rooms as…
How to optimize requests? Hello there is a chat which consists of the following tables Chat rooms id, type(USER_TO_USER, USER_TO_SHOP, USER_TO_PLATFORM), name Chat Room Members room_participants id, participantType (USER, SHOP, PLATFORM), participant_id list of messages room_messages - id, participant_id, text,…
I using postgres sql.I doing a query to calculate the estimated end date from start date and duration (minutes|hours|days|months|etc). The duration can be in minutes|hours| days|months . i try to use dateif but it work if we know the start…
I have a graph with two vertices, and each contain a property named interests, which is an array of strings. I wanted to compare how many strings both arrays have in common and also if the array contains a certain…
The following error occurred while attempting to use gdb to debug errors in Apache Age. The postgres server was started using pg_ctl and a connection to a database was established using psql. The running process ID (pid) of psql was…
How do I link two tables, People and Messages, when there is no single column in the Messages table that corresponds to the primary key of the People table? I have two tables: one containing email messages called Messages and…
I have my RoR app deployed in Heroku, with Devise authentication. Everything was working OK, but 2 days ago, I was informed that a rutinary Postgresql maintenance would be performed. After that, my Users can't log in into the App.…
I need to store order in which rows were written, but new for every unique value in other column For example: Column A Base index 1 1 1 2 2 1 3 2 2 4 2 3 5 2 4…