pgsql-sql since 2022-06-09 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

June 9, 2022

Thread	Author	Time
A function to find errors in groups in a table	Shaozhong SHI	13:37
A function to find errors in groups in a table	Shaozhong SHI	13:37
Re: A function to find errors in groups in a table	Steve Midgley	19:16
Re: A function to find errors in groups in a table	Shaozhong SHI	23:13
Re: A function to find errors in groups in a table	Steve Midgley	23:25

July 23, 2022

Thread	Author	Time
What seed does random() use if setseed() is not called first? 📎	Carl Sopchak	21:18
Re: What seed does random() use if setseed() is not called first?	Tom Lane	21:47
Re: What seed does random() use if setseed() is not called first? 📎	Carl Sopchak	21:55
Re: What seed does random() use if setseed() is not called first?	Tom Lane	22:06
Re: What seed does random() use if setseed() is not called first?	Carl Sopchak	22:09

Aug. 5, 2022

Thread	Author	Time
JDBC Driver for postgres 9.6	aditya desai	13:00
Re: JDBC Driver for postgres 9.6	Steve Midgley	13:03
Re: JDBC Driver for postgres 9.6	aditya desai	13:12
Re: JDBC Driver for postgres 9.6	Karsten Hilbert	13:15

Aug. 7, 2022

Thread	Author	Time
Possible bug (or at least unexpected behavior)	Adam Mackler	20:06
Re: Possible bug (or at least unexpected behavior)	Tom Lane	23:31

Aug. 8, 2022

Thread	Author	Time
select items based on 2 columns	Shaozhong SHI	08:24
Re: select items based on 2 columns	Frank Streitzig	09:32
Re: select items based on 2 columns	Pierre Chevalier	16:17
Re: select items based on 2 columns 📎	Carl Sopchak	16:30

Aug. 9, 2022

Thread	Author	Time
Re: Possible bug (or at least unexpected behavior) 📎	Tom Lane	21:10
Alternative to "AT TIME ZONE" that is less of a foot-gun?	John Ericson	21:31

Aug. 22, 2022

Thread	Author	Time
Most efficient way to select events from users having common subscriptions	Brice André	06:52

Aug. 30, 2022

Thread	Author	Time
execution id	Voillequin, Jean-Marc	16:22
Re: execution id	David G. Johnston	16:26
RE: execution id	Voillequin, Jean-Marc	16:32
Re: execution id	hubert depesz lubaczewski	16:55

Sept. 15, 2022

Thread	Author	Time
ON CONFLICT clause NOT working on Partition Table PostgreSQL 12	Inzamam Shafiq	17:31
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12	Steve Midgley	23:09

Sept. 16, 2022

Thread	Author	Time
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12	Inzamam Shafiq	05:49
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12	Tom Lane	06:41
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12	Inzamam Shafiq	07:51

Sept. 20, 2022

Thread	Author	Time
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12	Inzamam Shafiq	09:29
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12	David Rowley	09:46

Sept. 22, 2022

Thread	Author	Time
Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12	Geri Wright	10:39

Sept. 23, 2022

Thread	Author	Time
Delete from locking ordering differences	Peter Hendriks	07:31
Re: Delete from locking ordering differences	Rob Sargent	16:04

Sept. 29, 2022

Thread	Author	Time
Re: Delete from locking ordering differences	Peter Hendriks	13:51
[Bug][Ver 11]: Generic query plan selected is worse than custom query plan	Malay Keshav	18:33
Re: [Bug][Ver 11]: Generic query plan selected is worse than custom query plan	Tom Lane	19:58

Oct. 13, 2022

Thread	Author	Time
Can we generate a series of tables in a loop and then use another loop to union all?	Shaozhong SHI	15:44
Re: Can we generate a series of tables in a loop and then use another loop to union all?	Frank Gard	16:50
How to union all tables in a schema into one whole table?	Shaozhong SHI	17:02
Aw: How to union all tables in a schema into one whole table? 📎	Karsten Hilbert	17:06
Re: How to union all tables in a schema into one whole table?	Frank Gard	17:17

Oct. 14, 2022

Thread	Author	Time
Append a list of tables to an empty table to form a whole table	Shaozhong SHI	06:00
Re: Append a list of tables to an empty table to form a whole table	Frank Gard	07:13
Re: Append a list of tables to an empty table to form a whole table	Frank Gard	08:50

Oct. 15, 2022

Thread	Author	Time
How to do things like \timing on in a do loop?	Shaozhong SHI	19:32
Re: How to do things like \timing on in a do loop?	Erik Brandsberg	20:04

Oct. 16, 2022

Thread	Author	Time
Re: How to do things like \timing on in a do loop?	hubert depesz lubaczewski	09:21

Oct. 24, 2022

Thread	Author	Time
select only 1 pair	Shaozhong SHI	14:44
AW: select only 1 pair		14:51
RE: select only 1 pair	Voillequin, Jean-Marc	14:59
Re: select only 1 pair	William Alves Da Silva	15:01
Re: select only 1 pair	Frank Streitzig	15:01
Re: select only 1 pair	Thomas Kellerer	15:08
Re: select only 1 pair	Steve Midgley	15:57

Oct. 31, 2022

Thread	Author	Time
access sub elements using any()	Rob Sargent	17:04
Re: access sub elements using any()	Torsten Grust	22:36
Re: access sub elements using any()	Rob Sargent	22:40

Nov. 1, 2022

Thread	Author	Time
Re: access sub elements using any()	Tom Lane	00:50

Nov. 27, 2022

Thread	Author	Time
[QUESTION] Window function with partition by and order by	Ankit Kumar Pandey	16:08
Re: [QUESTION] Window function with partition by and order by	William Alves Da Silva	16:21
Re: [QUESTION] Window function with partition by and order by	Samed YILDIRIM	16:23
Re: [QUESTION] Window function with partition by and order by	Tom Lane	16:28
Re: [QUESTION] Window function with partition by and order by	Ankit Kumar Pandey	16:54
Re: [QUESTION] Window function with partition by and order by	Ankit Kumar Pandey	16:54
Re: [QUESTION] Window function with partition by and order by	Ankit Kumar Pandey	16:55

Dec. 9, 2022

Thread	Author	Time
Change detection	Shaozhong SHI	12:55
AW: Change detection		13:02
Re: Change detection	Marcos Pegoraro	13:06
Re: Change detection	Shaozhong SHI	13:14
Re: Change detection	Shaozhong SHI	14:15
Re: Change detection	Marcos Pegoraro	17:00
Re: Change detection	Shaozhong SHI	19:32
Re: Change detection	Rob Sargent	19:38

Dec. 12, 2022

Thread	Author	Time
PARALLEL CTAS	Shane Borden	16:16
Re: PARALLEL CTAS	Erik Brandsberg	16:55
Re: PARALLEL CTAS	Shane Borden	17:13
Re: PARALLEL CTAS	Rob Sargent	17:25
Re: PARALLEL CTAS	Shane Borden	17:36
Re: PARALLEL CTAS	Steve Midgley	18:19
Re: PARALLEL CTAS	Tom Lane	18:52
Tom changed his job role many times	Shaozhong SHI	22:43

Dec. 13, 2022

Thread	Author	Time
Re: Tom changed his job role many times	David Rowley	01:01
Re: Tom changed his job role many times	Shaozhong SHI	20:33

Dec. 14, 2022

Thread	Author	Time
Postgresql long transaction support	Kirmo Uusitalo	11:54
Re: Postgresql long transaction support	Samed YILDIRIM	12:02
Re: Postgresql long transaction support	Kirmo Uusitalo	12:45
Re: Postgresql long transaction support	Steve Midgley	19:59
Re: Postgresql long transaction support	Tom Lane	21:13

Jan. 7, 2023

Thread	Author	Time
Order By weirdness? 📎	Carl Sopchak	20:35
Re: Order By weirdness?	Erik Brandsberg	20:38
Re: Order By weirdness? 📎	Carl Sopchak	20:45
Re: Order By weirdness?	Samed YILDIRIM	21:01

Feb. 9, 2023

Thread	Author	Time
How to ensure a log-entry is created based on state of data in other tables	Andreas Joseph Krogh	07:23
Re: How to ensure a log-entry is created based on state of data in other tables	Steve Midgley	15:08
Re: How to ensure a log-entry is created based on state of data in other tables	Andreas Joseph Krogh	16:33
Re: How to ensure a log-entry is created based on state of data in other tables	Steve Midgley	16:37
Re: How to ensure a log-entry is created based on state of data in other tables	David G. Johnston	16:44
Re: How to ensure a log-entry is created based on state of data in other tables	Rob Sargent	16:44
Re: How to ensure a log-entry is created based on state of data in other tables	Andreas Joseph Krogh	16:59

Feb. 23, 2023

Thread	Author	Time
Could not serialize access due to read/write dependencies among transactions	michele curioni	21:18
Re: Could not serialize access due to read/write dependencies among transactions	Tom Lane	22:10

Feb. 25, 2023

Thread	Author	Time
Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range	nikhil raj	20:35
Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range.	nikhil raj	21:04
Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range	Steve Midgley	21:56

Feb. 27, 2023

Thread	Author	Time
Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range	nikhil raj	19:45

April 11, 2023

Thread	Author	Time
Looking for an efficient way to replace efficient NOT IN when landling very large data	Shaozhong SHI	09:27
Re: Looking for an efficient way to replace efficient NOT IN when landling very large data	David Rowley	09:33
Re: Looking for an efficient way to replace efficient NOT IN when landling very large data	Shaozhong SHI	09:44

April 20, 2023

Thread	Author	Time
PostgreSQL Objects design	kunwar singh	16:01
Re: PostgreSQL Objects design	Steve Midgley	16:25
PostgreSQL Objects design	Wetmore, Matthew (CTR)	18:40

June 22, 2023

Thread	Author	Time
Strange update behaviour	ProfiVPS Support	21:49
Re: Strange update behaviour	Tom Lane	22:11
Re: Strange update behaviour	ProfiVPS Support	23:07

June 23, 2023

Thread	Author	Time
Re: Strange update behaviour	Tom Lane	01:56
Re: Strange update behaviour	ProfiVPS Support	06:56

June 26, 2023

Thread	Author	Time
Window functions: frame-adhering aggregate without ORDER BY clause	Romain Carl	11:44
Re: Window functions: frame-adhering aggregate without ORDER BY clause	Tom Lane	13:54
Re: Window functions: frame-adhering aggregate without ORDER BY clause	Romain Carl	15:14
Re: Window functions: frame-adhering aggregate without ORDER BY clause	Erik Brandsberg	16:21

July 4, 2023

Thread	Author	Time
How come column is locked?	Shaozhong SHI	14:34
Re: How come column is locked?	William Alves Da Silva	14:40
Re: How come column is locked?	Thomas Kellerer	14:43
Re: How come column is locked?	Tom Lane	14:47
Working around insert into a_table from select things from a_function	Shaozhong SHI	16:58
Aw: Working around insert into a_table from select things from a_function	Karsten Hilbert	17:09
Re: How come column is locked?	Thomas Kellerer	18:39
Re: How come column is locked?	Rob Sargent	23:27
Re: Working around insert into a_table from select things from a_function	Rob Sargent	23:28

July 6, 2023

Thread	Author	Time
How to select the last value/row?	Shaozhong SHI	15:46
Re: How to select the last value/row?	David G. Johnston	15:51
Re: How to select the last value/row?	Shaozhong SHI	16:02
Re: How to select the last value/row?	David G. Johnston	16:09
Re: How to select the last value/row?	Tom Lane	16:12
How do Exception, do nothing and carry on	Shaozhong SHI	21:47
Re: How do Exception, do nothing and carry on	David G. Johnston	21:54

July 8, 2023

Thread	Author	Time
How to remove duplicates in an array and maintain the order?	Shaozhong SHI	15:30
Re: How to remove duplicates in an array and maintain the order?	David G. Johnston	15:36
Re: How to remove duplicates in an array and maintain the order?	Marcos Pegoraro	15:50
Re: How to remove duplicates in an array and maintain the order?	Thomas Kellerer	16:19
Finding out types of error	Shaozhong SHI	18:55
Re: Finding out types of error	David G. Johnston	18:58

July 13, 2023

Thread	Author	Time
Can we set time exception?	Shaozhong SHI	14:46
RE: Can we set time exception?	Voillequin, Jean-Marc	15:11
Re: Can we set time exception?	David G. Johnston	15:36
Re: Can we set time exception?	Tom Lane	15:52

July 14, 2023

Thread	Author	Time
Memory allocation error	Shaozhong SHI	06:38
Re: Memory allocation error	Pavel Stehule	07:13
Re: Memory allocation error	Shaozhong SHI	07:36
Re: Memory allocation error	Pavel Stehule	07:49
Re: Memory allocation error 📎	Tom Lane	11:13
Re: Memory allocation error	Pavel Stehule	11:54
Re: Memory allocation error	Shaozhong SHI	22:44

July 16, 2023

Thread	Author	Time
Multiple sets of results from recursive query	Shaozhong SHI	10:40
best finding all paths with recursive query	Shaozhong SHI	17:22

July 17, 2023

Thread	Author	Time
Re: Multiple sets of results from recursive query	Greg Sabino Mullane	16:43
Re: Multiple sets of results from recursive query	Shaozhong SHI	19:21
Re: Multiple sets of results from recursive query	Erik Brandsberg	19:31
Re: Multiple sets of results from recursive query	Shaozhong SHI	19:43

July 20, 2023

Thread	Author	Time
TSQL To Postgres - Unpivot/Union All	Anthony Apollis	11:29
Fwd: TSQL To Postgres - Unpivot/Union All	Anthony Apollis	12:17
Re: TSQL To Postgres - Unpivot/Union All	David G. Johnston	12:48
Re: TSQL To Postgres - Unpivot/Union All	Geoff Winkless	13:58
Fwd: TSQL To Postgres - Unpivot/Union All 📎	Anthony Apollis	14:28
Re: TSQL To Postgres - Unpivot/Union All	Geoff Winkless	14:51
Re: Fwd: TSQL To Postgres - Unpivot/Union All	Thomas Kellerer	15:07
Re: TSQL To Postgres - Unpivot/Union All	Anthony Apollis	15:47

July 25, 2023

Thread	Author	Time
Declaring a constant or variable in a query	JORGE MALDONADO	14:35
Re: Declaring a constant or variable in a query	Greg Sabino Mullane	16:51

Aug. 8, 2023

Thread	Author	Time
Very odd message	Shaozhong SHI	22:13
Re: Very odd message	Erik Brandsberg	22:17

Aug. 9, 2023

Thread	Author	Time
variable intermédiaires	Alain Benard	13:38
Re: variable intermédiaires	Guillaume Lelarge	14:17

Aug. 12, 2023

Thread	Author	Time
index not being used	lists-pgsql	01:15
Re: index not being used	Erik Brandsberg	01:47

Sept. 10, 2023

Thread	Author	Time
How to handle application connectivity change when moving from Oracle to Postgres in GCP	kunwar singh	17:43
Re: How to handle application connectivity change when moving from Oracle to Postgres in GCP	Erik Brandsberg	17:55
RE: How to handle application connectivity change when moving from Oracle to Postgres in GCP	Mike Sofen	18:32

Sept. 13, 2023

Thread	Author	Time
Query with conditional statement	JORGE MALDONADO	17:52
RE: Query with conditional statement	Tchouante, Merlin	17:57
Re: Query with conditional statement	David G. Johnston	18:07
Re: Query with conditional statement	Shane Borden	20:39

Sept. 14, 2023

Thread	Author	Time
Re: Query with conditional statement	Mehmet Sabri KUNT	08:11

Sept. 15, 2023

Thread	Author	Time
Regex matching where text is input and regex stored in column	Achilleas Mantzios - cloud	10:52

Sept. 16, 2023

Thread	Author	Time
no_data_found oracle vs pg	Jean-Marc Voillequin (MA)	09:26
Re: no_data_found oracle vs pg	Pavel Stehule	14:06
Re: Regex matching where text is input and regex stored in column	Achilleas Mantzios	16:35

Sept. 18, 2023

Thread	Author	Time
RE: no_data_found oracle vs pg	Jean-Marc Voillequin (MA)	06:49
Re: no_data_found oracle vs pg	Pavel Stehule	06:54
Re: no_data_found oracle vs pg	David Rowley	13:13
RE: no_data_found oracle vs pg	Jean-Marc Voillequin (MA)	14:05

Sept. 25, 2023

Thread	Author	Time
DDL in active production database	Skelton, Adam J	00:01
Re: DDL in active production database	David G. Johnston	00:06
Sv: DDL in active production database	Andreas Joseph Krogh	09:58

Oct. 2, 2023

Thread	Author	Time
A situation with one parent table and 3 child tables	JORGE MALDONADO	20:57
Re: A situation with one parent table and 3 child tables	Gareth Evans	21:46

Browse Archives

Prev | Next