In my Postgres database I naively created a column in table Foos as a json[] that looks like this: TABLE Foos id | ... | baas -------------------------------- 1 | ... | [ | ... | { | ... | "name":…
I have a varchar field and want to remove rows which can cast only to date value 01.01.2024 1.2 1 0.6 11.11.2024 I tried this script, but it's work incorrect select * from values where value > '01.01.1970' Result: value…
I have a table filled with pre-calculated prices for rental objects. This is a simple version of it: CREATE TABLE `pricecache` ( `oid` int(11) NOT NULL DEFAULT '0', `start` date NOT NULL, `end` date NOT NULL, `duration` tinyint(3) UNSIGNED NOT…
I have two postgresql tables with the following data [teams] [id][team_name] 1 team 1 2 team 2 3 team 3 [matches] [participant 1][participant 2] 1 3 2 1 3 2 The matches table references the team ID. I am trying…
I need to track the sequence of sites visited by a user in their session. My data looks like this: visitor session_num site page_view_num timestamp User A 2 Site A 1 2024-03-22 11:41:10 User A 2 Site A 2 2024-03-22…
i want to join table, and i have 2 table like Table : Suhu ID_ROOM | SUHU_MIN | SUHU_MAX ---------------------------------- 1 10 15 1 12 20 1 15 25 1 20 22 Table : RH ID_ROOM | RH_MIN | RH_MAX…
I am new to SQL and want to execute a query with joins. What I noticed is, when I have 2 rows in my table workers_send_times then I get doubled the same rows like start_time: 2024-01-01 end_time: 2024-01-02 start_time: 2024-01-01…
Is there a way of safe selecting a column that doesn't exists in a table without geting "invalid identifier" error? Maybe returning null instead? Something like this: select id, non_existant_column as col_name -- return null here instead of rising an…
I have two tables in postgres. CREATE TABLE data ( name VARCHAR(10) PRIMARY KEY ); CREATE TABLE timeseries ( name VARCHAR(10) NOT NULL REFERENCES data(name), time TIMESTAMP NOT NULL, value INTEGER NOT NULL, PRIMARY KEY (name, time) ); How I…
I am trying to add a comma and a space to my strings. Here are some examples: {ELEPHANT:1, FENNEC_FOX:1NAKED_MOLE:1URCHIN:2} {DUNG_BEETLE:12URCHIN:1} {DUNG_BEETLE:1FENNEC_FOX:1URCHIN:2} Notice the inconsistent lack of ", ". I would like to outcome to be {ELEPHANT:1, FENNEC_FOX:1, NAKED_MOLE:1, URCHIN:2} {DUNG_BEETLE:1,…