Probably a very simple solution but I am pretty new to PostgreSQL and I need you help good people. I have a table called countries containing information about different countries and later on I added a column called three_rivers that…
Asking this question for a colleague who ran into this behaviour with PostgreSQL. Hoping somebody out there can solve this puzzle for us. The following logs Rows updated: 3 when run: drop table if exists test; create table test (str…
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'm trying to create a trigger in Postgresql, but the delimiter $$ isn't recongnized. I'have small problems with the syntax of Postgresql after moving from MySql, so excuse my if this is just a very basic question. I tried this…
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`m trying to manage users permissions using groups (roles), but it doesn't work and I don't know why. What I want to do is something like this: CREATE ROLE readonly_role; GRANT SELECT ON ALL TABLES IN SCHEMA public TO readonly_role;…
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 working SELECT statement but as SQL isn't my strong point I don't know how to make this into an UPDATE function. I have others that work but it appears to be JOIN's getting me here. I've tried…
I want to quickly scan a chat conversation - in close to real time - and detect any food names that are in it. I've got a database of 400K foods or so, so the trivial solution of just using…