I'm moving from SQL server to Postgresql. In SQL Server I can define table-based function as an alias for a query. Example: Create Function Example(@limit int) As Returns Table As Return Select t1.*, t2.*, price * 0.5 discounted From t1…
I have a large number of txt files with a single column of data. There are no headers in the files. The data are an email address followed by a : and then a string of varchar, which sometimes includes…
Some databases support literals of the various GEO type, for example in Postgres, you can do: SELECT POINT '1,1'; And in Postgres it enforces the sub-type at the column level: SELECT POINT '1,1' UNION ALL SELECT LINE '0,0,1,1'; ERROR: UNION…
I'm having a problem with the prisma, at the moment where I use the findUnique() function to select the registered user based on his email. The error describes that it expects a string and not a JSON , but I…
I have the following (simplified) structure of a device and log messages which are attached to a device: CREATE TABLE device ( id SERIAL PRIMARY KEY, name VARCHAR(100), serial_number VARCHAR(20) UNIQUE ); CREATE TABLE error_log ( id SERIAL PRIMARY KEY,…
I have cases with nested results in JSON. here's the sample result, { "total_result" : 25, "questions" : [ { "id" : 1, "text" : "the question of user 1 here", "user" : { "id" : 5, "name" : "user…
I want to start uploading data to my PostgresSql table using pandas. I do the following, import psycopg2 import pandas as pd from sqlalchemy import create_engine user = 'aaa' passw= 'bbb' host = 'ccc' database = 'ddd' conn_string = f'postgresql://{user}:{passw}@{host}/{database}'…
I have a table that contains students publications like this id student 1 john 2 anthony 3 steven 4 lucille 5 anthony 6 steven 7 john 8 lucille 9 john 10 anthony 11 steven 12 lucille 13 john so the…
It seems this particular topic has quite a bit of traction here, but I have only been able to get one example to work, but I'm not sure if it will work for my use case. Please note I am…
I have a query to compute the 3rd highest salary for an employee as shown below. SELECT MAX(salary) FROM employee WHERE emp_no = 1 AND salary < (SELECT MAX(salary) FROM employee WHERE emp_no = 1 AND salary NOT IN (SELECT…