I want to be able to extract text from jsonb array in a new column as text. This is my SQL table. Id. ErrorCode. 101 ["exit code: 1"] 102 ["exit code: 3"] 103 ["OOMKILLED"] This is my column definition '[]'::jsonb…
I'm trying to use toml to store the connection settings of a database. I want to load these settings that are in a config.toml file and thus do my operations I tried the following: go code: func Init() *sql.DB {…
My table consists of user_id, revenue, publish_month columns. Right now I use group_by user_id and sum(revenue) to get revenue for all individual users. Is there a single SQL query I can use to query for user revenue across a time…
I have an insert statement that may insert single or multiple records into a table with an INSERT statement. I need to know what the primary id value is for each new row. Tried adding the following to the insert…
I have one table as below which stores employees details empid attribute value start_date end_date E1 Active FALSE 2020-01-01 2022-05-05 E1 Active TRUE 2022-06-06 9999-12-31 E1 Branch NYC 2022-01-01 9999-12-31 E2 Active TRUE 2020-01-01 9999-12-31 Then another table which have…
Following are my 2 tables CREATE TABLE temptext ( id text ); CREATE TABLE temptext2 ( id _text ); My insert queries are INSERT INTO temptext (id)VALUES ('a'); INSERT INTO temptext2 (id)VALUES ('{c,d,e,a}'); I have 2 queries that run perfectly…
I have a script.sh which executes 1 script.sql. It will look for the data in a data table. I have a loop and in this one I have other loops which will look for information in the data table and…
I faced with problem when create postgres container in the Docker on Windows 10 (on the MacOS is OK) I get error: FATAL: data directory "/var/lib/postgresql/data/pgdata" has invalid permissions full logs 2022-12-27 11:40:08 This user must also own the server…
I have a PostGIS table that stores the locations a device has passed through in the following way: ts lat lon 2022/12/23 10:04 -3.2654 -79.9234 2022/12/23 10:14 -3.2654 -79.9234 2022/12/23 10:24 -2.95592 -79.6833 As the device is transmitting every 10…
I have table with self-related foreign keys and can not get how I can receive firs child or descendant which meet condition. My_table structure is: id parent_id type 1 null union 2 1 group 3 2 group 4 3 depart…