I am following a video tutorial that tackles <kbd>CASE</kbd>, <kbd>WHEN</kbd>, and <kbd>END AS </kbd> queries. pgAdmin can find it with <kbd>SELECT</kbd> but when using the <kbd>CASE</kbd> it ceases to exist! select film_id, title, description, release_year, length, rating, CASE WHEN language_id ‘1’ THEN ‘English’ WHEN language_id ‘2’ THEN ‘Italian’ WHEN language_id ‘3’ THEN ‘Japanese’ WHEN language_id… Read More Beginner Question in PostgreSQL concerning CASE, WHEN, THEN, END AS

i’m quite new to postgressql, so i have a table called public.dim_products with a column called weight_kg what i would like to do is given some weight in the weight ranges below to set up a new column called weight_class and have these values `+————————–+——————-+ | weight_class VARCHAR(?) | weight range(kg) | +————————–+——————-+ | Light… Read More How to do if elif statements in postgressql and save the outcome in a new column?

I’m new to PostgreSQL, so maybe my question is unconvinced. But what I want is to put the result of one query into a variable and then used it again in another query. I run my query inside pgAdmin4, Below is my query: Also I tried those solution1, solution2 without achieving my goal. WITH vars… Read More How to declare and use a variable in PostgreSQL?

We’re learning how do functions work and we found out this language (?) on the selection, we didn’t find any documentation, neither on pgadmin’s official website… Any help is appreciated! >Solution : Don’t search the pgadmin4 documentation, but look at the SQL tab of the dialog to see the generated SQL commands. Then refer to… Read More What's the "internal" language on the pgadmin4's function creation wizard?

I wrote this sql query in the python interface using PGadmin4 sql server. It is sepose to return an ordered (decending by sum and if equal ascending by stadiumID) where sum is the number of goals that got scored in the stadium. if a stadium didn’t have any matches in it the sum should be… Read More SQL query wont run because of a strange group by error

This is a temporary database, so I don’t mind sharing credentials. We have setup the following in RDS: Host and Port and confirming public access DB Name Not shown is the username and password, however I am 100% certain that we are inputting the correct username and password into PgAdmin 4 and into python’s psycopg2.connect… Read More Troubleshoot connecting to free trial postgres on AWS RDS