agora inbox for pgsql-sql@postgresql.org  
help / color / mirror / Atom feed
PARALLEL CTAS
  2022-12-12 16:16 UTC  Shane Borden <sborden76@gmail.com>
` Re: PARALLEL CTAS
  2022-12-12 16:55 UTC  Erik Brandsberg <erik@heimdalldata.com>
` Re: PARALLEL CTAS
  2022-12-12 17:13 UTC  Shane Borden <sborden76@gmail.com>
` Re: PARALLEL CTAS
  2022-12-12 17:25 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: PARALLEL CTAS
  2022-12-12 17:36 UTC  Shane Borden <sborden76@gmail.com>
` Re: PARALLEL CTAS
  2022-12-12 18:19 UTC  Steve Midgley <science@misuse.org>
` Re: PARALLEL CTAS
  2022-12-12 18:52 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [7+ messages in thread]

Change detection
  2022-12-09 12:55 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Change detection
  2022-12-09 13:06 UTC  Marcos Pegoraro <marcos@f10.com.br>
` Re: Change detection
  2022-12-09 13:14 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Change detection
  2022-12-09 14:15 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Change detection
  2022-12-09 17:00 UTC  Marcos Pegoraro <marcos@f10.com.br>
` Re: Change detection
  2022-12-09 19:32 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Change detection
  2022-12-09 19:38 UTC  Rob Sargent <robjsargent@gmail.com>
  [7+ messages in thread]

AW: Change detection
  2022-12-09 13:02 UTC  Stöcker, Martin <Martin.Stoecker@etl-datenservice.de>

[QUESTION] Window function with partition by and order by
  2022-11-27 16:08 UTC  Ankit Kumar Pandey <itsankitkp@gmail.com>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:21 UTC  William Alves Da Silva <william_silva@unochapeco.edu.br>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:23 UTC  Samed YILDIRIM <samed@reddoc.net>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:28 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:54 UTC  Ankit Kumar Pandey <itsankitkp@gmail.com>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:54 UTC  Ankit Kumar Pandey <itsankitkp@gmail.com>
` Re: [QUESTION] Window function with partition by and order by
  2022-11-27 16:55 UTC  Ankit Kumar Pandey <itsankitkp@gmail.com>
  [7+ messages in thread]

access sub elements using any()
  2022-10-31 17:04 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: access sub elements using any()
  2022-10-31 22:36 UTC  Torsten Grust <teggy@fastmail.com>
` Re: access sub elements using any()
  2022-10-31 22:40 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: access sub elements using any()
  2022-11-01 00:50 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [4+ messages in thread]

select only 1 pair
  2022-10-24 14:44 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` RE: select only 1 pair
  2022-10-24 14:59 UTC  Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
` Re: select only 1 pair
  2022-10-24 15:01 UTC  William Alves Da Silva <william_silva@unochapeco.edu.br>
` Re: select only 1 pair
  2022-10-24 15:01 UTC  Frank Streitzig <fstreitzig@gmx.net>
` Re: select only 1 pair
  2022-10-24 15:08 UTC  Thomas Kellerer <shammat@gmx.net>
` Re: select only 1 pair
  2022-10-24 15:57 UTC  Steve Midgley <science@misuse.org>
  [6+ messages in thread]

AW: select only 1 pair
  2022-10-24 14:51 UTC  Stöcker, Martin <Martin.Stoecker@etl-datenservice.de>

How to do things like \timing on in a do loop?
  2022-10-15 19:32 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: How to do things like \timing on in a do loop?
  2022-10-15 20:04 UTC  Erik Brandsberg <erik@heimdalldata.com>
` Re: How to do things like \timing on in a do loop?
  2022-10-16 09:21 UTC  hubert depesz lubaczewski <depesz@depesz.com>
  [3+ messages in thread]

Append a list of tables to an empty table to form a whole table
  2022-10-14 06:00 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Append a list of tables to an empty table to form a whole table
  2022-10-14 07:13 UTC  Frank Gard <frank.von.postgresql.org@familie-gard.de>
` Re: Append a list of tables to an empty table to form a whole table
  2022-10-14 08:50 UTC  Frank Gard <frank.von.postgresql.org@familie-gard.de>
  [3+ messages in thread]

How to union all tables in a schema into one whole table?
  2022-10-13 17:02 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: How to union all tables in a schema into one whole table?
  2022-10-13 17:17 UTC  Frank Gard <frank.von.postgresql.org@familie-gard.de>
  [2+ messages in thread]

Aw: How to union all tables in a schema into one whole table?
  2022-10-13 17:06 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>

Can we generate a series of tables in a loop and then use another loop to union all?
  2022-10-13 15:44 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: Can we generate a series of tables in a loop and then use another loop to union all?
  2022-10-13 16:50 UTC  Frank Gard <frank.von.postgresql.org@familie-gard.de>
  [2+ messages in thread]

[Bug][Ver 11]: Generic query plan selected is worse than custom query plan
  2022-09-29 18:33 UTC  Malay Keshav <malay.keshav@databricks.com>
` Re: [Bug][Ver 11]: Generic query plan selected is worse than custom query plan
  2022-09-29 19:58 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [2+ messages in thread]

Delete from locking ordering differences
  2022-09-23 07:31 UTC  Peter Hendriks <peter@mindloops.nl>
` Re: Delete from locking ordering differences
  2022-09-23 16:04 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: Delete from locking ordering differences
  2022-09-29 13:51 UTC  Peter Hendriks <peter@mindloops.nl>
  [3+ messages in thread]

ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-15 17:31 UTC  Inzamam Shafiq <inzamam.shafiq@hotmail.com>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-15 23:09 UTC  Steve Midgley <science@misuse.org>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-16 05:49 UTC  Inzamam Shafiq <inzamam.shafiq@hotmail.com>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-16 06:41 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-16 07:51 UTC  Inzamam Shafiq <inzamam.shafiq@hotmail.com>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-20 09:29 UTC  Inzamam Shafiq <inzamam.shafiq@hotmail.com>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-20 09:46 UTC  David Rowley <dgrowleyml@gmail.com>
` Re: ON CONFLICT clause NOT working on Partition Table PostgreSQL 12
  2022-09-22 10:39 UTC  Geri Wright <geri.w123@gmail.com>
  [8+ messages in thread]

execution id
  2022-08-30 16:22 UTC  Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
` Re: execution id
  2022-08-30 16:26 UTC  David G. Johnston <david.g.johnston@gmail.com>
` RE: execution id
  2022-08-30 16:32 UTC  Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
` Re: execution id
  2022-08-30 16:55 UTC  hubert depesz lubaczewski <depesz@depesz.com>
  [4+ messages in thread]

Most efficient way to select events from users having common subscriptions
  2022-08-22 06:52 UTC  Brice André <brice@famille-andre.be>

Alternative to "AT TIME ZONE" that is less of a foot-gun?
  2022-08-09 21:31 UTC  John Ericson <list@johnericson.me>

Possible bug (or at least unexpected behavior)
  2022-08-07 20:06 UTC  Adam Mackler <adam@mackler.email>
` Re: Possible bug (or at least unexpected behavior)
  2022-08-07 23:31 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: Possible bug (or at least unexpected behavior)
  2022-08-09 21:10 UTC  Tom Lane <tgl@sss.pgh.pa.us>
  [3+ messages in thread]

select items based on 2 columns
  2022-08-08 08:24 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: select items based on 2 columns
  2022-08-08 09:32 UTC  Frank Streitzig <fstreitzig@gmx.net>
` Re: select items based on 2 columns
  2022-08-08 16:17 UTC  Pierre Chevalier <pierre.chevalier1967@free.fr>
` Re: select items based on 2 columns
  2022-08-08 16:30 UTC  Carl Sopchak <carl@sopchak.me>
  [4+ messages in thread]

JDBC Driver for postgres 9.6
  2022-08-05 13:00 UTC  aditya desai <admad123@gmail.com>
` Re: JDBC Driver for postgres 9.6
  2022-08-05 13:03 UTC  Steve Midgley <science@misuse.org>
` Re: JDBC Driver for postgres 9.6
  2022-08-05 13:12 UTC  aditya desai <admad123@gmail.com>
` Re: JDBC Driver for postgres 9.6
  2022-08-05 13:15 UTC  Karsten Hilbert <Karsten.Hilbert@gmx.net>
  [4+ messages in thread]

What seed does random() use if setseed() is not called first?
  2022-07-23 21:18 UTC  Carl Sopchak <carl@sopchak.me>
` Re: What seed does random() use if setseed() is not called first?
  2022-07-23 21:47 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: What seed does random() use if setseed() is not called first?
  2022-07-23 21:55 UTC  Carl Sopchak <carl@sopchak.me>
` Re: What seed does random() use if setseed() is not called first?
  2022-07-23 22:06 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: What seed does random() use if setseed() is not called first?
  2022-07-23 22:09 UTC  Carl Sopchak <carl@sopchak.me>
  [5+ messages in thread]

A function to find errors in groups in a table
  2022-06-09 13:37 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` A function to find errors in groups in a table
  2022-06-09 13:37 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: A function to find errors in groups in a table
  2022-06-09 19:16 UTC  Steve Midgley <science@misuse.org>
` Re: A function to find errors in groups in a table
  2022-06-09 23:13 UTC  Shaozhong SHI <shishaozhong@gmail.com>
` Re: A function to find errors in groups in a table
  2022-06-09 23:25 UTC  Steve Midgley <science@misuse.org>
  [5+ messages in thread]

Electricity bill
  2022-06-08 01:39 UTC  Theodore M Rolle, Jr. <stercor@gmail.com>
` Re: Electricity bill
  2022-06-08 01:42 UTC  Jonathan Katz <jonathan.katz@excoventures.com>
` Re: Electricity bill
  2022-06-08 01:47 UTC  David G. Johnston <david.g.johnston@gmail.com>
` Fwd: Electricity bill
  2022-06-08 01:48 UTC  Theodore M Rolle, Jr. <stercor@gmail.com>
` Re: Electricity bill
  2022-06-08 14:15 UTC  Joe Conway <mail@joeconway.com>
  [5+ messages in thread]

losing my mind about sytnax error in window clause
  2022-06-07 23:03 UTC  Rein Petersen <email@reinpetersen.com>
` Re: losing my mind about sytnax error in window clause
  2022-06-07 23:40 UTC  Tom Lane <tgl@sss.pgh.pa.us>
` Re: losing my mind about sytnax error in window clause
  2022-06-07 23:45 UTC  Rob Sargent <robjsargent@gmail.com>
` Re: losing my mind about sytnax error in window clause
  2022-06-07 23:46 UTC  Bob Edwards <bob@cs.anu.edu.au>
` Re: losing my mind about sytnax error in window clause
  2022-06-08 00:14 UTC  Rein Petersen <email@reinpetersen.com>
` Re: losing my mind about sytnax error in window clause
  2022-06-08 00:48 UTC  Ben Tilly <btilly@gmail.com>
  [6+ messages in thread]


[next (older)]

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox