pgsql-sql before 2024-03-08 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

Oct. 24, 2022

Thread	Author	Time
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

Oct. 3, 2023

Thread	Author	Time
Re: A situation with one parent table and 3 child tables	David G. Johnston	02:53
Re: A situation with one parent table and 3 child tables	Tom Lane	03:03
Re: A situation with one parent table and 3 child tables	David G. Johnston	03:10
Re: A situation with one parent table and 3 child tables	Rob Sargent	03:14

Oct. 12, 2023

Thread	Author	Time
Could not use index because of indcheckxmin is true	Japin Li	07:06
Re: Could not use index because of indcheckxmin is true	Tom Lane	14:30
Re: Could not use index because of indcheckxmin is true	Japin Li	15:31

Oct. 17, 2023

Thread	Author	Time
stored procedures	Shaozhong SHI	15:52
Re: stored procedures	David G. Johnston	16:04

Oct. 23, 2023

Thread	Author	Time
SQL issue after migrating from version 13 to 15	Campbell, Lance	15:19
Re: SQL issue after migrating from version 13 to 15	Tom Lane	15:31
RE: SQL issue after migrating from version 13 to 15	Campbell, Lance	15:58

Oct. 25, 2023

Thread	Author	Time
Concurrently run scipts	Shaozhong SHI	19:57
Re: Concurrently run scipts	Bruce Momjian	20:15
Re: Concurrently run scipts	hector vass	20:42

Oct. 26, 2023

Thread	Author	Time
Re: Concurrently run scipts	Shaozhong SHI	08:01
Re: Concurrently run scipts	hector vass	09:21
Re: Concurrently run scipts	Shaozhong SHI	09:49
Re: Concurrently run scipts	hector vass	13:50

Oct. 27, 2023

Thread	Author	Time
full text search and hyphens in uuid	Martin Norbäck Olivers	11:48

Oct. 28, 2023

Thread	Author	Time
Re: full text search and hyphens in uuid	Tom Lane	02:05

Oct. 29, 2023

Thread	Author	Time
Re: full text search and hyphens in uuid	Martin Norbäck Olivers	16:31

Nov. 8, 2023

Thread	Author	Time
DEFAULT in update & prepared statements	Sanjay Minni	16:02
Re: DEFAULT in update & prepared statements	David G. Johnston	17:21
Re: DEFAULT in update & prepared statements	David G. Johnston	17:30

Nov. 24, 2023

Thread	Author	Time
Bad execution plan when joining partitioned tables	Richard Schmidlechner	19:23

Nov. 29, 2023

Thread	Author	Time
Re: Bad execution plan when joining partitioned tables	Richard Schmidlechner	15:16
RE: Bad execution plan when joining partitioned tables	Jean-Marc Voillequin (MA)	16:26

Dec. 2, 2023

Thread	Author	Time
Overcoming Initcap Function limitations?	Bo Guo	19:03

Dec. 4, 2023

Thread	Author	Time
Re: Overcoming Initcap Function limitations?	Greg Sabino Mullane	18:08
Re: Overcoming Initcap Function limitations?	Steve Midgley	18:39

Dec. 5, 2023

Thread	Author	Time
Re: Overcoming Initcap Function limitations?	Bo Guo	01:39
Re: Overcoming Initcap Function limitations?	Steve Midgley	04:12
Re: Overcoming Initcap Function limitations?	Tom Lane	04:23
Re: Overcoming Initcap Function limitations?	Greg Sabino Mullane	20:54

Dec. 19, 2023

Thread	Author	Time
Wich program generates "list index out of range" ? pgadmin or the server ?	intmail01	08:26
Re: Wich program generates "list index out of range" ? pgadmin or the server ?	Steve Midgley	16:50

Dec. 20, 2023

Thread	Author	Time
Re: Wich program generates "list index out of range" ? pgadmin or the server ?	hubert depesz lubaczewski	10:26

Dec. 21, 2023

Thread	Author	Time
Re: Wich program generates "list index out of range" ? pgadmin or the server ?	intmail01	11:46
Re: Wich program generates "list index out of range" ? pgadmin or the server ?	hubert depesz lubaczewski	12:13

Jan. 9, 2024

Thread	Author	Time
How to use one function which can be accessed for all schemas	intmail01	08:15
Problem with refcursor	Maximilian Tyrtania	08:23
Re: Problem with refcursor	Maximilian Tyrtania	11:17
Re: How to use one function which can be accessed for all schemas	Tom Lane	15:29
How to use one function which can be accessed for all schemas	Wetmore, Matthew (CTR)	16:39
Re: How to use one function which can be accessed for all schemas	Bindra Bambharoliya	18:09
Re: How to use one function which can be accessed for all schemas	David G. Johnston	18:38

Jan. 31, 2024

Thread	Author	Time
Re: Problem with refcursor	Samed YILDIRIM	14:59

Feb. 7, 2024

Thread	Author	Time
POSTGRES 15 - CONSTRAINT TRIGGER CREATION	Cars Jeeva	10:11
Re: POSTGRES 15 - CONSTRAINT TRIGGER CREATION	Steve Midgley	17:50
Re: POSTGRES 15 - CONSTRAINT TRIGGER CREATION	Tom Lane	23:30

Feb. 21, 2024

Thread	Author	Time
How to find all current sequence IDs	Campbell, Lance	22:06
Re: How to find all current sequence IDs	Tom Lane	22:13
Re: How to find all current sequence IDs	Nisarg Patel	23:17

Feb. 22, 2024

Thread	Author	Time
PG_DUMP ERROR	Cars Jeeva	10:42

Feb. 29, 2024

Thread	Author	Time
RE: How to find all current sequence IDs	Campbell, Lance	14:49

Browse Archives

Prev | Next