pgsql-sql since 2020-12-18 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

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

May 31, 2021

Thread	Author	Time
Check ref cursor	Yambu	14:37
Re: Check ref cursor	Pavel Stehule	15:39

June 3, 2021

Thread	Author	Time
Update to whole table	Yambu	13:43
Re: Update to whole table	Steve Midgley	13:55

June 15, 2021

Thread	Author	Time
function INPUT as whole table	Yambu	10:59
Re: function INPUT as whole table	David G. Johnston	12:41
Re: function INPUT as whole table	Tom Lane	13:33
Re: function INPUT as whole table	Viswanatha Sastry	14:01
Re: function INPUT as whole table	Yambu	14:07
Re: function INPUT as whole table	Дмитрий Иванов	17:40

June 16, 2021

Thread	Author	Time
Re: function INPUT as whole table	Дмитрий Иванов	01:50

June 17, 2021

Thread	Author	Time
Listen and notify in psql process	Sakshi Jain	11:01
Fwd: Listen and notify in psql process	Sakshi Jain	11:04
Re: Listen and notify in psql process	Ravi Krishna	11:45
Re: Listen and notify in psql process	Torsten Förtsch	13:34
Re: Listen and notify in psql process	Erik Brandsberg	14:22

June 21, 2021

Thread	Author	Time
Help to design relations between some 5 tables with possible many-to-many relations	JORGE MALDONADO	19:07
Re: Help to design relations between some 5 tables with possible many-to-many relations	David G. Johnston	19:25
Re: Help to design relations between some 5 tables with possible many-to-many relations	Dean Gibson (DB Administrator)	21:03
Re: Help to design relations between some 5 tables with possible many-to-many relations	Dean Gibson (DB Administrator)	21:57

July 2, 2021

Thread	Author	Time
LAST_VALUE returns the entire partition	Дмитрий Иванов	12:04
Re: LAST_VALUE returns the entire partition	Tom Lane	14:04
Re: LAST_VALUE returns the entire partition	Дмитрий Иванов	15:30

July 5, 2021

Thread	Author	Time
Substitute for table variable and data migration approach	Avadhut Narayan Joshi	11:05

July 6, 2021

Thread	Author	Time
Re: Substitute for table variable and data migration approach	Steve Midgley	15:23

July 7, 2021

Thread	Author	Time
UPPER() Function Not Working as Expected in PostgreSQL 12.5 Version	Saraswat, Dhruv	17:35

July 8, 2021

Thread	Author	Time
Re: UPPER() Function Not Working as Expected in PostgreSQL 12.5 Version	David G. Johnston	16:10
Re: UPPER() Function Not Working as Expected in PostgreSQL 12.5 Version	Tom Lane	16:49

July 9, 2021

Thread	Author	Time
Support for PostgreSQL stored procedure through ITX. 📎	Prajakta Chinchole	05:53
Re: Support for PostgreSQL stored procedure through ITX.	Tom Lane	13:42
Re: Sort a table by a column value that is a column name?	Rob Sargent	16:32
Re: Sort a table by a column value that is a column name?	Steve Midgley	16:42
Sort a table by a column value that is a column name?	overland	16:59
Re: Sort a table by a column value that is a column name?	David G. Johnston	17:01
Re: Sort a table by a column value that is a column name?	overland	19:08

July 28, 2021

Thread	Author	Time
pg_verify_checksums on ubuntu 16.04	Rein Petersen	16:20
Re: pg_verify_checksums on ubuntu 16.04	Tom Lane	16:47
Re: pg_verify_checksums on ubuntu 16.04	Christophe Pettus	16:51

July 29, 2021

Thread	Author	Time
Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Avadhut Narayan Joshi	12:22
Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Vijaykumar Jain	12:26
RE: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Avadhut Narayan Joshi	12:31
Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Vijaykumar Jain	12:37
Re: Equivalent of InternalRowsAffected in NonExecuteQuery for PostgreSQL	Steve Midgley	19:43

Aug. 3, 2021

Thread	Author	Time
How to generate the order if you know the next item for each item?	Rockdale Green	15:40
Re: How to generate the order if you know the next item for each item?	David G. Johnston	16:22

Aug. 5, 2021

Thread	Author	Time
Like Command returning wrong result set	Tchouante, Merlin	14:00
Sv: Like Command returning wrong result set	Andreas Joseph Krogh	14:04
Re: Like Command returning wrong result set	Pavel Stehule	14:05
Re: Like Command returning wrong result set	Christophe Pettus	14:05
Show table and columns with null value and count	Zied Kharrat	14:08
RE: Like Command returning wrong result set	Tchouante, Merlin	14:09
Re: How to generate the order if you know the next item for each item?	Tony Shelver	14:33
Re: Show table and columns with null value and count	David G. Johnston	14:38
Re: How to generate the order if you know the next item for each item?	Rockdale Green	16:53
Re: How to generate the order if you know the next item for each item?	Rockdale Green	16:55

Aug. 9, 2021

Thread	Author	Time
Hide some tables	[email protected]	12:57
Re: Hide some tables	Jayadevan M	13:39
Re: Hide some tables	Tom Lane	13:45
Re: Hide some tables	[email protected]	17:48

Aug. 10, 2021

Thread	Author	Time
Is this a security oversight?	Ben Tilly	17:41
Re: Is this a security oversight?	Tom Lane	18:32
Re: Is this a security oversight?	Ben Tilly	18:40
Re: Is this a security oversight?	Tom Lane	18:45

Aug. 12, 2021

Thread	Author	Time
How to call webservice from PostgreSQL	aditya desai	12:49
Re: How to call webservice from PostgreSQL	Pavel Stehule	12:53
Re: How to call webservice from PostgreSQL	aditya desai	15:11

Aug. 13, 2021

Thread	Author	Time
Is there any way to invoke Java API from PostgreSQL	aditya desai	04:27
Re: Is there any way to invoke Java API from PostgreSQL	Erik Brandsberg	04:32
Re: Is there any way to invoke Java API from PostgreSQL	aditya desai	04:42
Re: Is there any way to invoke Java API from PostgreSQL	Erik Brandsberg	04:54
How to revoke access and list schema objects	[email protected]	16:00
Re: Is there any way to invoke Java API from PostgreSQL	Steve Midgley	16:39
Re: How to revoke access and list schema objects	Programadores cba	19:03

Aug. 18, 2021

Thread	Author	Time
Re: Is there any way to invoke Java API from PostgreSQL	aditya desai	10:18
Backup Functions	Sridhar Parepalli	15:05
Re: Backup Functions	Vijaykumar Jain	15:30
RE: Backup Functions	Sridhar Parepalli	16:05
Re: Backup Functions	Tom Lane	16:17
RE: Backup Functions	Sridhar Parepalli	17:14
Re: Backup Functions	David G. Johnston	17:43

Aug. 19, 2021

Thread	Author	Time
Re: Backup Functions	David G. Johnston	05:12

Aug. 23, 2021

Thread	Author	Time
Partition by outer join	aditya desai	15:52

Aug. 24, 2021

Thread	Author	Time
Re: Partition by outer join	aditya desai	03:58
Re: Partition by outer join	hubert depesz lubaczewski	06:32
Re: Partition by outer join	Thomas Kellerer	06:39
Re: Partition by outer join	aditya desai	06:49
question about to_tsvector and to_tsquery	Martin Norbäck Olivers	12:01
Re: question about to_tsvector and to_tsquery	Tom Lane	14:12
Re: Partition by outer join	David G. Johnston	14:15
Re: Partition by outer join	Steve Midgley	16:01
Re: Partition by outer join	David G. Johnston	16:09
Re: Partition by outer join	Thomas Kellerer	16:45

Aug. 26, 2021

Thread	Author	Time
Re: Partition by outer join	aditya desai	03:37

Sept. 13, 2021

Thread	Author	Time
PostgreSQL performance GNU vs LLVM	arjun shetty	17:23

Sept. 19, 2021

Thread	Author	Time
How to sort deleted rows with trigger. Some rows before then some rows after.	[email protected]	17:31
Re: How to sort deleted rows with trigger. Some rows before then some rows after.	Rob Sargent	18:00

Sept. 20, 2021

Thread	Author	Time
Re: How to sort deleted rows with trigger. Some rows before then some rows after.	intmail01	15:53
Re: How to sort deleted rows with trigger. Some rows before then some rows after.	David G. Johnston	16:22
Re: How to sort deleted rows with trigger. Some rows before then some rows after.	Rob Sargent	16:58

Sept. 24, 2021

Thread	Author	Time
SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont 📎	Matias Montroull	13:23
Re: SQL Error [0A000]: ERROR: OVER is not supported for ordered-set aggregate percentile_cont	David G. Johnston	21:04

Sept. 25, 2021

Thread	Author	Time
Creating a query to structure results grouped by two columns, pivoting only a third colum	Iuri Sampaio	16:39

Sept. 26, 2021

Thread	Author	Time
Re: Creating a query to structure results grouped by two columns, pivoting only a third colum	Steve Midgley	00:53

Sept. 27, 2021

Thread	Author	Time
Re: Creating a query to structure results grouped by two columns, pivoting only a third colum	Iuri Sampaio	14:06

Oct. 3, 2021

Thread	Author	Time
PostgreSQL CHECK Constraint	Shaozhong SHI	07:30

Browse Archives

Prev | Next