simplifying - Search results in mailing lists

2024-12-05 21:40:46 | Re: Clarification Needed on PostgreSQL Version Upgrade (Steve Midgley)

simplify this, but if you are dealing with high value data, this is how I would

2022-05-08 19:15:54 | Re: Recursive query - ERROR: invalid memory alloc request size 1073741824 (Simon Riggs)

Find the mistakes in your query by simplifying it. -- Simon Riggs http://www.EnterpriseDB.com/

2022-03-04 14:52:27 | Re: Bug in tables column data in postgres database (Steve Midgley)

Simplify and instrument your environment. Use analytic tools. Develop steps to reproduce (and steps where

2021-12-15 11:36:44 | Re: ERROR ON INSERTING USING A CURSOR IN EDB POSTGRESQL (hubert depesz lubaczewski)

simplified to: CREATE OR REPLACE PROCEDURE public.temp_insert_in_books2() LANGUAGE 'plpgsql'     SECURITY DEFINER

2021-05-28 18:32:45 | Postgresql - Json syntax in INSERT RETURNING clause with INTO (Ron Clarke)

simplified expression of what I've been looking at: Thanks for taking a look, and please

2021-01-07 16:50:13 | Re: how to make query (Steve Midgley)

simplify your table structures in the DDL to focus only on the place where you are having

2020-10-10 03:40:36 | Re: total and partial sums in the same query?? (David G. Johnston)

simplified self-contained example and, using the provided input data, describe exactly what the output

2020-09-04 00:20:51 | Re: Crossing/Rotating table rows to rows and columns (Iuri Sampaio)

simplify the query to actually get an idea of the target pivot table, removing datetime

2020-04-10 21:26:07 | Re: 回复: [External] Re: Separate volumes (Erik Brandsberg)

simplifying the management and backup. On Fri, Apr 10, 2020 at 5:01 PM Bruce

2018-11-30 17:52:31 | interval origami (Adam Jensen)

simplified attempt to isolate what I see as the core problem, which is probably mostly

2018-11-19 13:27:01 | Difficulties with LAG-function when calculating overtime (Andreas Joseph Krogh)

simplified example) schema:   drop table if exists logged_hours; create table logged_hours(     date DATE

2018-04-18 03:19:44 | Re: Postgres 9.6 - ltree extension - (re)build a tree on a table (Steve Midgley)

simplify the problem a bit.. You could probably issue a recursive update statement just

2017-10-26 00:15:31 | Re: [SQL] Unable to use INSERT ... RETURNING with column fromother table (Andreas Joseph Krogh)

simplify it?   Thanks.   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andreas@visena.com

2017-09-14 02:55:48 | [SQL] How could I improve a query with a function in the join clause? (Daniel Franco)

simplification purposes, the following query has a similar structure of what I'm having issues

2016-05-21 16:52:12 | SQL query funnel analysis (Maks Materkov)

simplified): id | user_id | type_id | created -- | ------- | ------- | ------- 1 | 7160 | 6148 | 2016-05-20 12:11:21 ... Currently