pgsql-sql before 2021-05-31 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

Aug. 9, 2020

Thread	Author	Time
recursive sql	ml	06:28
AW: recursive sql		07:55
Re: recursive sql 📎	Samed YILDIRIM	10:38
Re: recursive sql	ml	11:57
Re: recursive sql 📎	Samed YILDIRIM	12:08
Re: recursive sql	Igor Andriychuk	12:18
Re: recursive sql	ml	13:25
Re: recursive sql	Igor Andriychuk	14:10
Re: recursive sql	Igor Andriychuk	14:22
Re: recursive sql	Franz Timmer	14:54
Re: recursive sql	ml	15:04

Aug. 11, 2020

Thread	Author	Time
Use multidimensional array as VALUES clause in insert	Mike Martin	10:47
Use multidimensional array as VALUES clause in insert	Mike Martin	10:50
Re: Use multidimensional array as VALUES clause in insert 📎	Samed YILDIRIM	10:58
Re: Use multidimensional array as VALUES clause in insert	David G. Johnston	13:22
Re: Use multidimensional array as VALUES clause in insert	Thomas Kellerer	14:08
Re: Use multidimensional array as VALUES clause in insert	Igor Andriychuk	14:43
Re: Use multidimensional array as VALUES clause in insert	Mike Martin	20:59

Aug. 16, 2020

Thread	Author	Time
Weird issue with truncation of values in array with some tables	Mike Martin	13:48
Re: Weird issue with truncation of values in array with some tables	David G. Johnston	15:13
Re: Weird issue with truncation of values in array with some tables	Tom Lane	17:12
Re: Weird issue with truncation of values in array with some tables	Mike Martin	21:19

Aug. 22, 2020

Thread	Author	Time
Stored procedure and returning clause	Mike Martin	12:52

Aug. 28, 2020

Thread	Author	Time
value returned by EXTRACT, date_part	John Lumby	17:43
Re: value returned by EXTRACT, date_part	David G. Johnston	19:44
Re: value returned by EXTRACT, date_part	John Lumby	21:18

Aug. 29, 2020

Thread	Author	Time
Re: value returned by EXTRACT, date_part	Tom Lane	01:39
Re: value returned by EXTRACT, date_part	John Lumby	13:13
Re: value returned by EXTRACT, date_part	Tom Lane	16:04

Sept. 3, 2020

Thread	Author	Time
Re: Crossing/Rotating table rows to rows and columns	Christophe Pettus	02:58
Crossing/Rotating table rows to rows and columns	Iuri Sampaio	02:58

Sept. 4, 2020

Thread	Author	Time
Re: Crossing/Rotating table rows to rows and columns	Iuri Sampaio	00:20
Re: Crossing/Rotating table rows to rows and columns	Christophe Pettus	00:22

Sept. 7, 2020

Thread	Author	Time
Re: Crossing/Rotating table rows to rows and columns	Iuri Sampaio	02:03

Sept. 11, 2020

Thread	Author	Time
Clarification on pg_attribute attrelid	Mike Martin	11:26
Re: Clarification on pg_attribute attrelid	Tom Lane	14:12

Sept. 17, 2020

Thread	Author	Time
Postgres as a service for supporting common application users	Shaozhong SHI	22:59
Postgres as a service for supporting common application users	Shaozhong SHI	23:04

Oct. 3, 2020

Thread	Author	Time
Querying sporadic time series type data.	Tim Uckun	05:44
Re: Querying sporadic time series type data.	David G. Johnston	16:11
Re: Querying sporadic time series type data.	Tim Uckun	23:53

Oct. 4, 2020

Thread	Author	Time
Re: Querying sporadic time series type data.	David G. Johnston	00:10
Re: Querying sporadic time series type data.	Steven Pousty	00:42
Re: Querying sporadic time series type data.	Tim Uckun	08:29
parallelisation of queries	Francesco De Angelis	14:40

Oct. 8, 2020

Thread	Author	Time
libpq CREATE DATABASE operation from multiple treads	p.sun.fun	19:46
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	19:57
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:04
Re: libpq CREATE DATABASE operation from multiple treads	Dmitry Igrishin	20:15
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:30
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	20:32
Re: libpq CREATE DATABASE operation from multiple treads	Rob Sargent	20:35
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	20:36
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:41
Re: libpq CREATE DATABASE operation from multiple treads	Rob Sargent	20:43
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:46
Re: libpq CREATE DATABASE operation from multiple treads	Rob Sargent	20:50
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	20:52
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	20:56
Re: libpq CREATE DATABASE operation from multiple treads	Tom Lane	20:57

Oct. 9, 2020

Thread	Author	Time
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	03:33
Re: libpq CREATE DATABASE operation from multiple treads	Guillaume Lelarge	03:44
Re: libpq CREATE DATABASE operation from multiple treads	p.sun.fun	03:49
send query in background	Franz Timmer	04:31
send query in background	ml	04:34
Re: send query in background	Tatsuo Ishii	04:40
getting aroung chr(0)	James Cloos	20:01

Oct. 10, 2020

Thread	Author	Time
total and partial sums in the same query??	Iuri Sampaio	02:58
Re: total and partial sums in the same query??	David G. Johnston	03:40
Re: total and partial sums in the same query??	Iuri Sampaio	03:42
Re: total and partial sums in the same query??	David G. Johnston	03:58
Re: total and partial sums in the same query??	Iuri Sampaio	15:28
Re: total and partial sums in the same query??	David G. Johnston	17:55

Oct. 17, 2020

Thread	Author	Time
get counts of multiple field values in a jsonb column	Martin Norbäck Olivers	15:00
Re: get counts of multiple field values in a jsonb column	David G. Johnston	15:38
Re: get counts of multiple field values in a jsonb column	Rob Sargent	16:15

Oct. 20, 2020

Thread	Author	Time
Re: get counts of multiple field values in a jsonb column	Simon Riggs	08:56

Oct. 21, 2020

Thread	Author	Time
Best way to change values of a primary key referenced by many tables	Andreas Joseph Krogh	20:27
Re: Best way to change values of a primary key referenced by many tables	David G. Johnston	21:25
Re: Best way to change values of a primary key referenced by many tables	Iuri Sampaio	22:11

Nov. 12, 2020

Thread	Author	Time
Identify columns that need indexes	Yambu	07:50
Re: Identify columns that need indexes	hubert depesz lubaczewski	11:14

Nov. 18, 2020

Thread	Author	Time
Querry correction required	Sachin Kumar	17:43
Re: Querry correction required	Thomas Kellerer	17:49

Nov. 19, 2020

Thread	Author	Time
Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	19:21
Re: Get last generated serial sequence and set it up when explicit value is used	David G. Johnston	20:04

Nov. 20, 2020

Thread	Author	Time
Re: Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	08:19
Re: Get last generated serial sequence and set it up when explicit value is used	David G. Johnston	08:49
Re: Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	10:23
perform setval() fails?	Sebastien FLAESCH	17:00
Re: perform setval() fails?	Christophe Pettus	17:01

Nov. 21, 2020

Thread	Author	Time
Re: Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	09:26

Nov. 25, 2020

Thread	Author	Time
Re: Get last generated serial sequence and set it up when explicit value is used	Sebastien FLAESCH	11:32

Nov. 26, 2020

Thread	Author	Time
CTE materialized/not materialized	Voillequin, Jean-Marc	15:24

Nov. 27, 2020

Thread	Author	Time
Re: CTE materialized/not materialized	Alvaro Herrera	14:53
RE: CTE materialized/not materialized	Voillequin, Jean-Marc	15:18
Re: CTE materialized/not materialized	Tom Lane	15:35
RE: CTE materialized/not materialized	Voillequin, Jean-Marc	15:58
Re: CTE materialized/not materialized	Alvaro Herrera	17:03

Dec. 2, 2020

Thread	Author	Time
Join push down on FDW partitions	Anders Svensson	13:30
Re: Join push down on FDW partitions 📎	Samed YILDIRIM	14:44
parallel safe on user defined functions	Voillequin, Jean-Marc	15:25
Re: parallel safe on user defined functions	Tom Lane	16:15

Dec. 3, 2020

Thread	Author	Time
calling function	Yambu	03:47
Re: Join push down on FDW partitions	Anders Svensson	09:52

Dec. 18, 2020

Thread	Author	Time
Custom aggregate last_value_when	Ben Tilly	21:03

Dec. 21, 2020

Thread	Author	Time
dblink_exists	ml	01:35
Re: dblink_exists	David G. Johnston	01:52
Re: dblink_exists	ml	05:07
JSON path query returns duplicate values	Thomas Kellerer	09:43

Dec. 29, 2020

Thread	Author	Time
Re: JSON path query returns duplicate values	Thomas Kellerer	14:14

Jan. 7, 2021

Thread	Author	Time
how to make query	Sachin Kumar	10:15
PostgreSQL Django Query	Sachin Kumar	11:55
Re: how to make query	Philip Semanchuk	13:58
Re: how to make query	Sachin Kumar	14:25
Re: how to make query	Steve Midgley	16:50
Re: how to make query	Philip Semanchuk	17:05

Jan. 14, 2021

Thread	Author	Time
Non blocking type change for primary column	Torge Kummerow	16:26

Jan. 15, 2021

Thread	Author	Time
Re: Non blocking type change for primary column	Guillaume Lelarge	09:42

Jan. 16, 2021

Thread	Author	Time
Re: Non blocking type change for primary column	Mohamed Wael Khobalatte	05:18

Jan. 19, 2021

Thread	Author	Time
Bring to dead tuples to alive	Roberto Médola	13:02
Re: Bring to dead tuples to alive	Steve Midgley	16:02
Re: Bring to dead tuples to alive	Craig Jackson	16:48
Re: Bring to dead tuples to alive	Roberto Médola	17:37
Re: Bring to dead tuples to alive	Craig Jackson	18:41
Re: Bring to dead tuples to alive	Erik Brandsberg	19:47
Re: Bring to dead tuples to alive	Roberto Médola	20:10
Re: Bring to dead tuples to alive	Steve Midgley	20:29
Re: Bring to dead tuples to alive	Skylar Thompson	23:22

Jan. 20, 2021

Thread	Author	Time
Re: Bring to dead tuples to alive	Roberto Médola	12:58

Jan. 23, 2021

Thread	Author	Time
Question about WITH ORDINALITY and unnest	Mike Martin	13:17
Re: Question about WITH ORDINALITY and unnest	David G. Johnston	16:14
Re: Question about WITH ORDINALITY and unnest	Shaozhong SHI	21:14
Re: Question about WITH ORDINALITY and unnest	Tom Lane	21:50

Jan. 24, 2021

Thread	Author	Time
format integer	ml	14:57
Re: format integer	David G. Johnston	16:06
Re: format integer	Steve Midgley	16:37
Re: format integer	Torge Kummerow	16:48
Re: format integer	ml	17:35

Jan. 29, 2021

Thread	Author	Time
Re: Bring to dead tuples to alive	Roberto Médola	16:47

Feb. 5, 2021

Thread	Author	Time
How to fix Execute format error?	Joe How	11:22
Re: How to fix Execute format error?	Pavel Stehule	15:01
Re: How to fix Execute format error?	Joe How	17:40
Re: How to fix Execute format error?	Pavel Stehule	17:48

Feb. 7, 2021

Thread	Author	Time
Whitelink to other data stores	Shaozhong SHI	11:27
Re: Whitelink to other data stores	Ian Lawrence Barwick	11:34

Feb. 9, 2021

Thread	Author	Time
Relationship between PostgreSQL and Datalakes and etc on Azure	Shaozhong SHI	09:23
Re: Relationship between PostgreSQL and Datalakes and etc on Azure	Steve Midgley	16:44

Feb. 20, 2021

Thread	Author	Time
embedded composite types	Arturo Guadagnin	14:41
Re: embedded composite types	David G. Johnston	15:07
Re: embedded composite types	Tom Lane	15:58

March 17, 2021

Thread	Author	Time
select into composite type / return	Gary Stainburn	16:48
Re: select into composite type / return	Tom Lane	17:26
Re: select into composite type / return	Gary Stainburn	17:42

March 18, 2021

Thread	Author	Time
Re: select into composite type / return	Gary Stainburn	10:05
Re: select into composite type / return	Torsten Grust	11:10
Re: select into composite type / return	Gary Stainburn	11:20
Re: select into composite type / return	Tom Lane	14:28
Re: select into composite type / return	Gary Stainburn	14:32

March 22, 2021

Thread	Author	Time
Re: select into composite type / return	Gary Stainburn	10:34
Re: select into composite type / return	Pavel Stehule	10:40
Re: select into composite type / return	Gary Stainburn	10:54
Re: select into composite type / return	Pavel Stehule	10:56
Re: select into composite type / return	Gary Stainburn	11:01
Re: select into composite type / return	Pavel Stehule	11:15

March 31, 2021

Thread	Author	Time
Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	08:35
Re: Serial sequence name when table/column name in uppercase	Ian Lawrence Barwick	08:51
Re: Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	08:58
Re: Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	10:13
Re: Serial sequence name when table/column name in uppercase	Tom Lane	13:55
Re: Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	14:57
Re: Serial sequence name when table/column name in uppercase	Sebastien FLAESCH	15:13

April 6, 2021

Thread	Author	Time
URL Decode function	JORGE MALDONADO	04:34
Re: URL Decode function	MichaelDBA	12:56
Re: URL Decode function	Andreas Joseph Krogh	13:03
Re: URL Decode function	MichaelDBA	13:07

April 19, 2021

Thread	Author	Time
Substitute of TRY and CATCH in postgres	aditya desai	13:21
Re: Substitute of TRY and CATCH in postgres	Thomas Kellerer	13:32

May 11, 2021

Thread	Author	Time
set Assert checking on by session	Rein Petersen	22:43
Re: set Assert checking on by session	Tom Lane	23:20

May 23, 2021

Thread	Author	Time
Getting transaction details from the WAL?	Bo Guo	02:00
Re: Getting transaction details from the WAL?	Christophe Pettus	02:03
Re: Getting transaction details from the WAL?	Bo Guo	02:36

May 24, 2021

Thread	Author	Time
Index creation	Yambu	03:41
Re: Index creation	David Rowley	04:00
Re: Index creation	Yambu	04:42
Long updates by primary key	Алексей Белобородов	10:19
Re: Long updates by primary key	Vijaykumar Jain	10:52
Re: Index creation	Steve Midgley	16:09
Re: Index creation	Yambu	17:34

May 25, 2021

Thread	Author	Time
RE: Index creation	Marc Mamin	09:44
Re: Index creation	Yambu	10:18

May 26, 2021

Thread	Author	Time
Select for update	Yambu	09:26
Re: Select for update	David G. Johnston	12:27
Re: Select for update	Yambu	15:19
Re: Select for update	David G. Johnston	17:06
Re: Select for update	Tom Lane	17:36

May 28, 2021

Thread	Author	Time
Postgresql - Json syntax in INSERT RETURNING clause with INTO	Ron Clarke	18:32
Re: Postgresql - Json syntax in INSERT RETURNING clause with INTO	Vijaykumar Jain	19:36
Re: Postgresql - Json syntax in INSERT RETURNING clause with INTO	David G. Johnston	19:41

Browse Archives

Prev | Next