Query: INSERT INTO derived (a, b, c) VALUES (?, ?, ?) ON CONFLICT (a, b, c) DO UPDATE SET a = EXCLUDED.a, b = EXCLUDED.b, c = EXCLUDED.c WHERE EXISTS (select a from primary where a = ?) Please note,…
I'm new to SQL and don't think I understand how to write if else statements. The following code block produces a syntax error at the if statement. create or replace function weight_from_days_ago (days_ago int, difficulty int, user_level int, root_score int)…
I need to write a function that will transform the results of a column called "store_id" in a table. I want to transform the integer 1 into "Store 1" and 2 into "Store 2", but I get errors no matter…
I apologize in advance, I am certainly not a db expert, so might be asking something obvious here. I have a large postgreql table with the following (example) data : CREATE TABLE t (ID int, componentid varchar(30), scanresult varchar(30), eventdatetime…
I have a table called cc_index and the table has among others the following columns: length, date, url, [other_colums]. The same url may appear in multiple rows. For each url, I only want to retain a single row (but all…
In my PostgreSQL 14.8 database I have a table named orders that looks as follows: CREATE TABLE orders ( user_id int , order_id int , order_date date , quantity int , revenue float , product text ); INSERT INTO orders…
I demonstrate the issue with the following simple table. (The actual table and JSON document have a lot more fields.) CREATE table contact ( id bigint PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, firstname VARCHAR, lastname VARCHAR, birthday timestamp with…
There are multiple solutions online but they all use 'CREATE TABLE' and 'INSERT' in their solutions. I only have read access. So how to print all table names and row count in a schema? If possible how to print column…
SHA() method giving different result for same value of binary with different sizes. Created a table, columns with X1 binary(1), X2 binary(10) size. CREATE TABLE TEST_binary10_2 ( PK bigint NOT NULL, VERSION int NOT NULL, X1 binary(1) DEFAULT NULL, X2…
I have a table named Report_Table in Azure SQL. It has more than one hundred columns. I will give an example with 3 columns like: +--------+----------+------+ | job_id | rep_pm | done | +--------+----------+------+ | 46 | a002 | a…