I need to display the departure and arrival airport codes with their names from another table. But I don't know how to do this in one request select flight_no, a.departure_airport, b.airport_name from flights a join airports_data b on a.departure_airport =…
I have 2 tables: video_real device_id | video_definition 1 | 360 1 | 480 (2 rows) video_all device_id | video_definition 1 | 360 1 | 480 1 | 540 1 | 720 1 | 1080 I want to return device_id…
I have a simple table "users", for which I want to block access to the password for some role "alice". -- create table and some example data create table users ( username text, password text ); insert into users(username, password)…
I am using C# for CRUD operations and using Postgres as my database. I was using Dapper for my operations. But I am stuck when I want to execute multiple queries. I don't want to make multiple connections to the…
I have a table named member. I want to create a function that inserts a new email if it doesn't exist in the table, and then return a boolean. CREATE OR REPLACE FUNCTION add_member(member_email TEXT) RETURNS BOOLEAN AS $$ BEGIN…
I am seeing a connection error when i try to read data from postgressql in my jupyter notebook. The error suggests: Connection info needed in SQLAlchemy format, example: postgresql://username:password@hostname/dbname or an existing connection: dict_keys([]) As far as i can see…
Say I have two tables, Students and Scores: Students ID|Name|Gender 1|Ryan|M 2|Joanna|F 3|Shelly|F 4|James|M 5|Ron|M Scores ID|StudentID|Score 1|1|85 2|3|71 3|5|92 4|3|55 5|4|63 I want to get the names of all students, but I only want passing students for the boys.…
I have a query select * from table1 where column1=ANY(@some_array) @some_array - parameter that has array of values. It could contain null, which is correct according to my business logic. Unfortunately, query returns nothing if @some_array=[1, NULL] Documentation says: expression…
select sum(case when '%sys%' like any(series_arr) or 'displays' = any(lob_arr) then revenue else 0 end) as sys_displ_revenue from mytable Basically, when I run this query, the term '%sys%' like any(<array column>) seems to get ignored, and only the 'displays' revenue…
I'm a newbie in backend development and just started to build a simple table including jsonb type with PostgreSQL in node.js on Ubuntu. CREATE TABLE testTable ( id SERIAL NOT NULL PRIMARY KEY, vStr VARCHAR(64), jVar jsonb); Then I tried…