I created a function that returns all values that meet the condition specified and tried specifying int[] as the result type of the function. create or replace function mults_of_3_5(id int) returns int[] language sql as $$ SELECT ValuesUnder1000 FROM Mults…
Trying to make a GET call from the front end to select the username in the row where user_id = 1 by using parameterized queries. Hard-coded queries work fine, but parameterized queries cause the request to be aborted and returns…
Overview I am trying to develop a query that selects as many rows as necessary so that I update up to LIMIT unique thing.thing_ids and is ordered by the status_1_date column (meaning older things should be updated first). thing_id is…
I am trying to replace multiple whitespaces from a column in Redshift(Postgres) Query used : Select replace(col_name,' ',' ') from table; above query is not working for multiple whitespaces only. I have tried replacing other characters in the same query,…
I showed users(roles) with dg and du, then there were the same results as shown below: postgres=# dg List of roles Role name | Attributes -----------+------------------------------------------------------------ anna | john | postgres | Superuser, Create role, Create DB, Replication, Bypass RLS…
Trying to create a conditional unique index in postgresql but unable to do so and getting this error Query 1 ERROR: ERROR: cannot use subquery in index predicate LINE 3: WHERE ( ^ this is how my query looks like…
How to order by timestamp and group based on score Entities starting with a prefix (say a1 are similar), but we need to pickup the one with the highest score, in this case a1-1 For a2 it should pickup a2-1,…
I'm working on a project for a tutoring institute where we have an existing Odoo application managing our data. We now need to create a web application using React that provides two interfaces: one for instructors and one for students.…
Our PostgreSQL database was getting bigger and we wanted to identify what tables are guilty.
I have problem connecting to my Db that is running on a container on Docker using postres image: docker run --name postgres-container -p 2345:2345 -e POSTGRES_PASSWORD=password123 -e POSTGRES_USER=admin -d postgres My typescript code (is on a ts file) app.get("/hello", async…