pgsql-sql before 2021-03-17 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 3, 2020

Thread Author Time
Recursive CTE with a function Mark Bannister 13:52
Problem with parameterised CASE UPDATE Mike Martin 16:33
Re: Problem with parameterised CASE UPDATE Steve Midgley 18:02
Re: Problem with parameterised CASE UPDATE David G. Johnston 18:15
Re: Problem with parameterised CASE UPDATE Mike Martin 22:31

June 8, 2020

Thread Author Time
Persisting Query tabs/contents over restart Joseph 18:14
Re: Persisting Query tabs/contents over restart David G. Johnston 18:31
Re: Persisting Query tabs/contents over restart Joseph 19:12

June 26, 2020

Thread Author Time
Optimizer Hint, to ignore limit and offset in optimizer plan Martin Handsteiner 08:49
Re: Optimizer Hint, to ignore limit and offset in optimizer plan Pavel Stehule 09:01
Re: Optimizer Hint, to ignore limit and offset in optimizer plan Bruce Momjian 23:59

June 27, 2020

Thread Author Time
Re: Optimizer Hint, to ignore limit and offset in optimizer plan Simon Riggs 11:08
pgsql function for roman2decimal? F Bax 20:38
Re: pgsql function for roman2decimal? Bruce Momjian 21:01
Re: pgsql function for roman2decimal? Erik Brandsberg 21:14
Re: pgsql function for roman2decimal? Bruce Momjian 21:24
Re: pgsql function for roman2decimal? Erik Brandsberg 21:28
Re: pgsql function for roman2decimal? Bruce Momjian 21:31

June 29, 2020

Thread Author Time
AW: Optimizer Hint, to ignore limit and offset in optimizer plan Martin Handsteiner 08:10
Re: AW: Optimizer Hint, to ignore limit and offset in optimizer plan Tom Lane 14:30
Re: AW: Optimizer Hint, to ignore limit and offset in optimizer plan Erik Brandsberg 14:33
Re: AW: Optimizer Hint, to ignore limit and offset in optimizer plan Bruce Momjian 15:48
AW: AW: Optimizer Hint, to ignore limit and offset in optimizer plan Martin Handsteiner 17:33

July 8, 2020

Thread Author Time
Partition by list - is select possible? Mike Martin 10:31
Re: Partition by list - is select possible? David Rowley 12:01
Role information table name Gaurav Tomar 17:25
Re: Role information table name Jonathan Katz 17:44
Re: Role information table name David G. Johnston 17:46
Re: Role information table name Stephen Frost 17:54

July 20, 2020

Thread Author Time
foreign key referencing inheritance parent J Lumby 14:44

July 25, 2020

Thread Author Time
plphyton function - return each list value as a row ? karsten 21:26
Re: plphyton function - return each list value as a row ? David G. Johnston 21:32
plphyton function - return each list value as a row ? karsten 21:41
RE: plphyton function - return each list value as a row ? karsten 21:50

July 30, 2020

Thread Author Time
UNNEST and multidimensional arrays Mike Martin 13:28
Re: UNNEST and multidimensional arrays Pavel Stehule 15:05
Re: UNNEST and multidimensional arrays Steve Midgley 15:30

July 31, 2020

Thread Author Time
how to use function from different database Bhupendra Babu 00:03
Re: how to use function from different database David G. Johnston 00:15
Re: how to use function from different database Rob Sargent 00:28
Re: how to use function from different database Bhupendra Babu 06:05
Re: foreign key referencing inheritance parent 📎 Samed YILDIRIM 07:07
Re: foreign key referencing inheritance parent John Lumby 15:48

Aug. 1, 2020

Thread Author Time
Group by a range of values Mike Martin 12:14
Re: Group by a range of values Torsten Grust 12:34
Re: Group by a range of values Rob Sargent 12:53
Re: Group by a range of values Steve Midgley 18:55

Aug. 3, 2020

Thread Author Time
Error - Arrays must contain only scalars and other arrays when array element is an array Mike Martin 10:39

Aug. 8, 2020

Thread Author Time
Re: Group by a range of values 📎 Samed YILDIRIM 11:29

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

Browse Archives

Prev | Next