I need to enter value for direction of sort in a function, but how to do it? Tried like that, but this doesn't work of course. create or replace function invest_ideas (order_by_direction varchar default 'desc') create or replace function invest_ideas…
I'm trying to make an API that uses PostgreSQL to store shortened links. However, when trying to execute a query to the database, postgreClient is undefined every time. short.controller.ts: import { Request, Response, NextFunction } from "express"; import client from…
I need to remove only character 1 from the string '[1,11, 1, 111,12,1,11]' in Postgres without affecting the other characters. Symbol 11 and 111, 12 should not be affected. I can't cope with this task. Please help me The end…
In my Ecto schema, I have a User who has_many Items. An item has a boolean field active: User module: schema "users" do field :name, :string has_many :items, Item end Item module: schema "items" do field(:active, :boolean) belongs_to(:user, User) end…
I have got the following Postgres table: create table test ( id serial, contract varchar, amount0 int, amount1 int, price double precision ); I would like to insert 100 rows of dummy data that conforms to the following: – In…
I have two tables, organization and address. organization table has an address_id column but all the rows have address_id set to NULL. I want to SET address_id in organization table equal to a random id in address table but I…
I used an URI in .env to connect my code to the database of my app, but it connected to the postgres database instead of the database "workout-app" and I don't know how to fix that. My application created tables…
I am trying 8weeksqlchallenge, and I usually work with MySQL and the error codes are quite cleaner there, but not so much on dbfiddle.com This is my schema CREATE SCHEMA dannys_diner; SET search_path = dannys_diner; CREATE TABLE sales ( "customer_id"…
I am trying to pass a date to a function in postgres. Here is my code: CREATE OR REPLACE FUNCTION public.path_optimization(input_date date) RETURNS TABLE(area_id_ uuid, result_uuids text[]) LANGUAGE plpgsql AS $function$ DECLARE r RECORD; BEGIN -- Iterate through the records…
I collect device ON/OFF events in a timeseries table. Following is a sample data. time_stamp state 2023-10-04 10:05:53 0 2023-10-04 10:15:58 1 2023-10-04 10:30:59 0 2023-10-04 10:40:00 1 2023-10-04 10:55:01 0 2023-10-04 11:05:03 1 2023-10-04 11:35:36 0 2023-10-04 11:40:39 1…