My data are: order_id chef_name order_returned 1001 Charles McBakey Y 1001 Sarah McCookin N 1001 John McFry N 1001 Charles McBakey N 1001 John McFry N 1001 John McFry Y 1001 John McFry Y 1001 Sarah McCookin N 1001 Charles…
is there a way to use lubridates:floor_date() in a postgres backend with non-standart units like '2 month'? or good alternatives?? I have a lazy tbl with a date column and want to group this column by x months. Like so..…
postgresql version info: psql -V psql (PostgreSQL) 13.11 (Debian 13.11-0+deb11u1) Create table : create table sample1(ticker text,pe float,grow float,peg float); create table sample2(ticker text,pe float,grow float,peg float); Insert data for test in table sample1: insert into sample1 (ticker,pe,grow,peg) values ('dxp',16.8,2.809,0.07),…
In PostgreSQL, I have a table with some settings the user can make. In that table there is also a "global" user that takes place if the user doesn't have any settings for them. This query returns the settings for…
Given this table and data: test# create table t (c int); CREATE TABLE test# insert into t (c) values (1), (3), (2); INSERT 0 3 If I try to query the table with an invalid order by expression in a…
I'm trying to return TEXT[] type from my_func() with a RETURN QUERY EXECUTE and VALUES statement. But calling my_func() which has " in '' got the error as shown below: CREATE FUNCTION my_func() RETURNS SETOF TEXT[] AS $$ BEGIN --…
Hi I am working in Postgres. I have below code DO $$ DECLARE item integer; begin item:=5; DROP TABLE IF EXISTS temp_data; CREATE temp TABLE temp_data AS select current_timestamp + interval '1 day' as op; END $$; select * from…
I have a preexisting Postgres database with a bunch of tables. Each table has an ID column with a sequence. In my entity class I have something like this: @Entity @Table(name = "plan_block") @Getter @Setter @NoArgsConstructor @AllArgsConstructor @Audited public class…
I wand to select record from one table and insert into other . Here is my table 1 create table temp ( seq varchar(20), prefix varchar(20) ); insert into temp values ('AAA','A'); // counter should be 1 as combo of…
Count active customers dependent on start and end date Customer Start Date End Date 1 2020-01 2020-04 2 2020-01 2020-03 3 2020-02 Hi, I have a table like the above. I would like to calculate the number of "Active Customers"…