Does anyone know if Postgres is smart enough to search an in memory table in a binary fashion of some sort, or if not, is there a way to mark a column to tell postgres it is in order and…
How can i use variables in a query of a foreign table? I could ALTER the option (query) of the foreign tabel and add the variable into the where clause but i am concerned that this locks the foreign table…
I have a problem I'm trying to resolve. I'd love to get your ideas or help with the method I have in my mind. I created a good analogy for it: I need to tag each record in a table…
I have a Postgres table whose header is [id(uuid), name(str), arg_name(str), measurements(list), run_id(uuid), parent_id(uuid)] with a total of 237K entries. When I want to filter for specific measurements I can use 'name', but for the majority of entries in the…
Using PostgreSQL 9.6, I'm trying to insert rows into a table map, generated from another table tbl. tbl name in1 in2 a 1 b 2 {3} c 4 {5,6} d 7 {8,9,10} Should result in this: map name out1 out2…
I do a lot of looking at user behavior and want an easy way to order by the first event in a group of events per user. i.e. User1 | Event1 User1 | Event2 User1 | Event3 User2 | Event1…
I have the following table "sales" date revenue 2022-06-01(Week 1) 100 2022-06-08(week 2) 200 2022-05-01(week 1) 800 2022-05-08(week 2) 900 and I want to compare sales current week vs the same week last month and get the following result: date…
I am having the following issue. I have a table like the following that holds all the exchange rates per day for all currencies (as base currency is Euro): id rates_values rate_date 1 {"AED":2.835349,"AFN":67.743417,... 1-1-2022 2 {"AED":2.485349,"AFN":66.843814, 2-2-2022 The column…
I have a table where I store some info about events. My table have columns: id, created_at(which is date field), key(which is varchar255), quantity(which is integer) and event(which is varchar255). I'm making query to take all keys which exists on…
Table 1 - col1 col2 1 443 2 449 3 479 Table 2 - col1 col2 1 NULL 2 NULL 3 NULL Note - col1 is not a PK expected Output - Table 2 - col1 col2 1 443 2…