I have two tables. table 1 Column A Column B rgz 1 dry 1 vgy 2 chy 3 pom 2 table 2 Column C Column D tuv 10 tuv 11 chx 22 lmn 34 I want the following result shown…
I'm maintaining an old PostgreSQL-based application (PostgreSQL 9.1.22) on a Windows 2012 Server and we have noticed some data integrity inconsistencies. No errors have been spotted in logs nor in the event viewer, but we have noticed that somebody (or…
I wand to select record from one table and insert into other . Here is my table 1 create table temp ( seq varchar(20), prefix varchar(20) ); insert into temp values ('AAA','A'); // counter should be 1 as combo of…
Is postgresql can do average for rolling data? I have this case where I need to average the values for 5 days and get all the days filled up while waiting for the actual values so basically if I'm in…
I have a table ,one of the table filed is json format: my_table id json_field 1 { "to_status": 7, "to_status_name": "In Progress", "role": "admin"} 2 { "to_status": 3, "to_status_name": "Completed", "role": "admin"} 3 { "to_status": 2, "to_status_name": "Completed", "role": "customer"}…