I'm trying to filter some journald logs which might have some-what similar information in different keys. journalctl -o json | head -n 1000 | jq '.UNIT, .USER_UNIT, ._SYSTEMD_UNIT Those 3 keys might have the unit name, depending on how the…
I have a table of real estate data with lots of NULLS in address column. I want to replace these nulls based on the unique ID. (I'm following Alex the Analyst tutorial). However when I use this in postgresql, I'm…
I'm looking for guidance on how to apply IFNULL to an outer query in my mySQL Query. The query checks for new timecards submitted the previous day and kicks off a procedure that writes the results to a file server.…
I'm trying to group rows when it starts with 1 and has consecutive 0s, and stop grouping once it meets another 1 or 2. Here is an example: (column 'group' is what I expect to see) +-----+------+-------+ | seq |…
Still learning SQL/PostgreSQL. I am struggling to figure out how to stop returning an array with a null value as [null] and instead just return an empty array. COALESCE( json_agg( CASE WHEN socials.id IS NULL THEN NULL ELSE json_build_object('id', socials.id,…
I try to populate null-rows in a table with data from the same table. Here is my code: create table public.testdata( id INTEGER, person INTEGER, name varchar(10)); insert into testdata (id, person,name) VALUES ( 1,1,'Jane' ), ( 2,1,'Jane' ), (…
I have looked at the COALESCE documentation and it mentions the typical case of using COALESCE to make default/situational parameters, e.g. COALESCE(discount, 5) which evaluates to 5 if discount is not defined as something else. However, I have seen it…
I have a strange problem: There is a price in a JSON column in a table and the following statements give different results while they should give the same thing: CAST(COALESCE(JSON_EXTRACT(item.price_details, "$.shipping.price"), 0) AS FLOAT) AS shippricecoalfloat COALESCE(CAST(JSON_EXTRACT(item.price_details, "$.shipping.price") AS…
I am trying to create a script, which will update column lang_id in table static if static.method_id = methods.method_id and if methods.mm_id = languages.mm_id and if languages.is_default = 1. But this one is not working, tell me please, why? UPDATE…