Let's say I have the following PostgreSQL database schema: Group id: int Task: id: int created_at: datetime group: FK Group I have the following Materialized View to calculate the number of tasks and the most recent Task.created_at value per group:…
I want to create a new text search dictionary for PostgreSQL that will perform the recognition of synonyms. The dictionary should use .syn file. I created file in TextEdit with synonyms and saved .syn file on desktop. After that I…
If i modify the max number of allowed digits in MYSQL 5.7 from double(8,2) to double(12,2), is the change immediate or will it need to process all rows??
I'm triying to add quantities of fuels from two tables. Payments table contains data about customers and dates. Fuels table contains data about fuels recharged. I need to add the litres by customer in 3 groups: from yesterday until 46…
I have a table named deposit, below dep_id deposit_amount comp_id 1 100 1 2 100 1 3 100 1 When I run the query below I get the next updated table which is not what I want : query =…
I have the following mysql query: SELECT pagos.id, codigo_factura as code, pagos.importe as amount FROM pagos INNER JOIN m_labores p ON (pagos.id_producto = p.id) INNER JOIN maquinas m ON (pagos.id_maquina = m.id) WHERE m.id = 561 AND fecha_registro BETWEEN '2022-10-11…
So I have two tables: CREATE TABLE table1 (`PRIMARY_DT` date, `CUST_ID` int) ; INSERT INTO table1 (`PRIMARY_DT`, `CUST_ID`) VALUES ('2012-03-02', 878 ), ('2012-07-02', 456 ), ('2012-09-02', 789 ) ; CREATE TABLE table2 (`dt` date, `CUST_ID` int, `value` int) ; INSERT…
I have an event table with lane1 and lane2 mapping colors as below. event lane1 lane2 79 red yellow 83 red white 87 blue red 91 yellow white 96 green white 100 navy yellow 103 yellow green 107 yellow blue…
I am seeking to find first date of the month in the corresponding table: So if i have 26/08/2011 August as date and 2 months to add, it becomes 26/10/2011. I need the first date of the resulting month- like…
Can't create tables in public schema as non-superuser postgres - super user. What I've done: ALTER SCHEMA public owner to postgres; CREATE USER admin WITH PASSWORD 'my-password'; GRANT USAGE, CREATE ON SCHEMA public TO postgres; GRANT USAGE, CREATE ON SCHEMA…