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

Sept. 26, 2016

Thread	Author	Time
Re: cvs text to quoted cvs text	Michael Moore	22:05

Sept. 29, 2016

Thread	Author	Time
using possibly null timestamptz columns	James Cloos	12:35
Re: using possibly null timestamptz columns	Tom Lane	13:05
Re: using possibly null timestamptz columns	Tom Lane	13:15
Re: using possibly null timestamptz columns	James Cloos	15:48

Oct. 4, 2016

Thread	Author	Time
PLPython and named arguments	Andrey Avakimov	12:20
Re: PLPython and named arguments	Tom Lane	12:37
Re: PLPython and named arguments	Adrian Klaver	13:19
Re: PLPython and named arguments	Andrey Avakimov	13:36

Oct. 6, 2016

Thread	Author	Time
SQL Bug	Bujji Babu	10:22
Re: SQL Bug 📎	Bujji Babu	10:23
Re: SQL Bug	Oleksandr Shulgin	10:44
Re: [BUGS] SQL Bug	Heikki Linnakangas	10:44
Re: [BUGS] SQL Bug	Bujji Babu	10:59
Re: SQL Bug	Heikki Linnakangas	11:07
Re: [BUGS] SQL Bug	Bujji Babu	11:19

Oct. 7, 2016

Thread	Author	Time
row number with in cursor	Kevin Duffy	00:05
Re: row number with in cursor	Adrian Klaver	00:26
Re: row number with in cursor	Kevin Duffy	01:01
Re: row number with in cursor	Adrian Klaver	01:21
Re: row number with in cursor	Thomas Kellerer	05:42
Large Objects	Jürgen Purtz	07:10
Re: Large Objects	Thomas Kellerer	07:24
Re: Large Objects	Pavel Stehule	07:25
Re: Large Objects	Adrian Klaver	13:19
How to get the position of each record in a SELECT statement	JORGE MALDONADO	17:20
Re: How to get the position of each record in a SELECT statement	Stephen Tahmosh	17:31
Re: Large Objects	Jürgen Purtz	19:31
Re: Large Objects	Thomas Kellerer	19:41

Oct. 8, 2016

Thread	Author	Time
Re: How to get the position of each record in a SELECT statement	Adelo Herrero Pérez	07:35
Re: How to get the position of each record in a SELECT statement	Adelo Herrero Pérez	07:44

Oct. 13, 2016

Thread	Author	Time
Table Partitioning with Foreign Data Wrapper	Ranjeet Verma	08:19
Using TEMP ON COMMIT DROP, but need logging too.	Michael Moore	21:24
Re: Using TEMP ON COMMIT DROP, but need logging too.	David G. Johnston	21:48
Re: Using TEMP ON COMMIT DROP, but need logging too.	Michael Moore	21:53

Oct. 14, 2016

Thread	Author	Time
Re: Using TEMP ON COMMIT DROP, but need logging too.	Benjamin Dietrich	07:24
Re: Using TEMP ON COMMIT DROP, but need logging too.	Michael Moore	17:23
Re: Using TEMP ON COMMIT DROP, but need logging too.	David G. Johnston	17:32
Re: Using TEMP ON COMMIT DROP, but need logging too.	Michael Moore	17:35

Oct. 26, 2016

Thread	Author	Time
Fwd: Regarding change in the size of database	harish Reddy	05:01
Re: Fwd: Regarding change in the size of database	Jayadevan M	13:37
Re: Fwd: Regarding change in the size of database	harish Reddy	16:21

Oct. 27, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	Jayadevan M	03:34
Re: Fwd: Regarding change in the size of database	harish Reddy	11:23
Re: Fwd: Regarding change in the size of database	Michael Moore	23:40

Oct. 31, 2016

Thread	Author	Time
PL/pgSQL Audit Utility	Michael Moore	19:06
Re: PL/pgSQL Audit Utility	Pavel Stehule	19:08
Re: PL/pgSQL Audit Utility	Michael Moore	19:10
Why does the PL/pgSQL compiler do this?	Michael Moore	22:13
Re: Why does the PL/pgSQL compiler do this?	David G. Johnston	22:24
Re: Why does the PL/pgSQL compiler do this?	Michael Moore	22:55
Re: Why does the PL/pgSQL compiler do this?	Michael Moore	23:32
Re: Why does the PL/pgSQL compiler do this?	Adrian Klaver	23:38

Nov. 1, 2016

Thread	Author	Time
Re: Why does the PL/pgSQL compiler do this?	Michael Moore	01:09
Re: Why does the PL/pgSQL compiler do this?	Adrian Klaver	01:20
Re: Why does the PL/pgSQL compiler do this?	Tom Lane	02:38
Re: Why does the PL/pgSQL compiler do this?	Michael Moore	17:36
Re: Why does the PL/pgSQL compiler do this?	Pavel Stehule	17:43

Nov. 2, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	harish Reddy	17:26
Re: Fwd: Regarding change in the size of database	Michael Moore	19:12
ERROR: out of shared memory	Michael Moore	21:31
Re: ERROR: out of shared memory	David G. Johnston	21:49
Re: ERROR: out of shared memory	Michael Moore	21:52
Re: ERROR: out of shared memory	Michael Moore	22:03
Re: Why does the PL/pgSQL compiler do this?	Pavel Stehule	22:15
Re: ERROR: out of shared memory	David G. Johnston	22:28
Re: ERROR: out of shared memory	David G. Johnston	22:29
Re: ERROR: out of shared memory	Michael Moore	22:33
Re: ERROR: out of shared memory	David G. Johnston	22:33
Re: ERROR: out of shared memory	Michael Moore	22:55
Re: ERROR: out of shared memory	David G. Johnston	23:06
Re: ERROR: out of shared memory	David G. Johnston	23:08
Re: ERROR: out of shared memory	Michael Moore	23:31

Nov. 3, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	Amitabh Kant	03:50
Re: Fwd: Regarding change in the size of database	harish Reddy	04:36

Nov. 4, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	Amitabh Kant	04:33

Nov. 11, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	harish Reddy	05:19
Re: Fwd: Regarding change in the size of database	Amitabh Kant	05:34

Nov. 15, 2016

Thread	Author	Time
Only target lines of text	Michael Moore	01:19
Re: Only target lines of text	Rob Sargent	01:36
Re: Only target lines of text	Tom Lane	01:57
Re: Only target lines of text	Michael Moore	03:07
Re: Only target lines of text	Michael Moore	22:58
Re: Only target lines of text	Tom Lane	23:04
Re: Only target lines of text	Michael Moore	23:10

Nov. 23, 2016

Thread	Author	Time
Dynamic queries for Partitions	Metatrader EA	14:54

Nov. 24, 2016

Thread	Author	Time
Re: Dynamic queries for Partitions	Jan Ostrochovsky	09:22

Nov. 29, 2016

Thread	Author	Time
Regarding postgres client on windows	Mallela, Anil	11:26
Re: Regarding postgres client on windows	Adrian Klaver	15:36
Re: [SQL] Regarding postgres client on windows	Steve Midgley	15:40

Nov. 30, 2016

Thread	Author	Time
Re: Fwd: Regarding change in the size of database	harish Reddy	17:28
Re: Fwd: Regarding change in the size of database	Adrian Klaver	17:47

Dec. 8, 2016

Thread	Author	Time
RLS for superuser	Gaurav Tomar	07:32
Re: RLS for superuser	MS (direkt)	07:38
Re: RLS for superuser	Stephen Frost	13:54

Dec. 16, 2016

Thread	Author	Time
simple "select / if found" isn't	Gary Stainburn	11:02
Re: simple "select / if found" isn't	Karsten Hilbert	11:12
Re: simple "select / if found" isn't	Gary Stainburn	11:24
Re: simple "select / if found" isn't	Karsten Hilbert	11:29
Re: simple "select / if found" isn't	Jan Otto	11:34
Re: simple "select / if found" isn't	Gary Stainburn	11:41

Dec. 31, 2016

Thread	Author	Time
How to use postgresql generated generated always COLUMN ?	tank.zhang	04:29
Re: How to use postgresql generated generated always COLUMN ?	David G. Johnston	04:52
回复： [SQL] How to use postgresql generated generated always COLUMN ?	Tank.zhang	05:01
Re: How to use postgresql generated generated always COLUMN ?	tank.zhang	05:03

Jan. 9, 2017

Thread	Author	Time
How to use external java libraries in Database	bb23850	11:20
Re: How to use external java libraries in Database	Rob Sargent	15:54

Jan. 10, 2017

Thread	Author	Time
How to display multiple rows in 1 row	Baxter Allen	19:55
Re: How to display multiple rows in 1 row	David G. Johnston	20:24

Jan. 11, 2017

Thread	Author	Time
Re: How to display multiple rows in 1 row	Steve Midgley	03:11
Re: How to display multiple rows in 1 row	David G. Johnston	03:40
Re: How to display multiple rows in 1 row	David G. Johnston	03:55
Re: How to display multiple rows in 1 row	Steve Midgley	04:01

Feb. 7, 2017

Thread	Author	Time
why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.	Herwig Goemans	10:53
Re: why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.	Tom Lane	16:37

Feb. 8, 2017

Thread	Author	Time
Re: why is PG NOT pushing where clause to VIEW ? Resulting in bad performance.	Herwig Goemans	10:20
Problem wil TIMEZONE vs TIME ZONE	Mike Wes	11:20
Re: Problem wil TIMEZONE vs TIME ZONE	Adrian Klaver	14:32
Re: Problem wil TIMEZONE vs TIME ZONE	Tom Lane	15:52

Feb. 9, 2017

Thread	Author	Time
function source code not returning from inside a pgsql function.	Herwig Goemans	16:39
Re: function source code not returning from inside a pgsql function.	David G. Johnston	16:44
Re: function source code not returning from inside a pgsql function.	Tom Lane	16:57
Re: function source code not returning from inside a pgsql function.	Herwig Goemans	17:29

Feb. 16, 2017

Thread	Author	Time
Conditional Lookup Table with Like	sqlQuestions	22:19
Re: Conditional Lookup Table with Like	David G. Johnston	22:37
Re: Conditional Lookup Table with Like	sqlQuestions	23:05
Re: Conditional Lookup Table with Like	David G. Johnston	23:32

Feb. 17, 2017

Thread	Author	Time
Re: Conditional Lookup Table with Like	sqlQuestions	00:37
Re: Conditional Lookup Table with Like	sqlQuestions	15:33
Re: Conditional Lookup Table with Like	David G. Johnston	16:41
Re: Conditional Lookup Table with Like	sqlQuestions	17:56
Re: Conditional Lookup Table with Like	sqlQuestions	17:58

Feb. 18, 2017

Thread	Author	Time
Question on MERGE in postgresql	Kaleeswaran Velu	15:32
Re: Question on MERGE in postgresql	David G. Johnston	15:39

Feb. 28, 2017

Thread	Author	Time
FDW Process ID (PID)	Gaurav Tomar	06:35
Re: FDW Process ID (PID)	Adrian Klaver	17:03
Re: FDW Process ID (PID)	Adrian Klaver	17:07

March 5, 2017

Thread	Author	Time
avoid update - insert churn	Kevin Duffy	18:20
Re: avoid update - insert churn	Adrian Klaver	19:56
Re: avoid update - insert churn	Kevin Duffy	20:07

March 6, 2017

Thread	Author	Time
Re: avoid update - insert churn	Steve Midgley	03:55
parameter type is unknown error	Günce Kaya	11:28
Fwd: parameter type is unknown error	Günce Kaya	11:36
Re: Fwd: parameter type is unknown error	Charles Clavadetscher	11:51
Re: Fwd: parameter type is unknown error	Raymond O'Donnell	11:57
Re: Fwd: parameter type is unknown error	Günce Kaya	12:00
Re: Fwd: parameter type is unknown error	Günce Kaya	12:20
Re: Fwd: parameter type is unknown error	Charles Clavadetscher	12:22
Re: Fwd: parameter type is unknown error	Tom Lane	12:36
Re: Fwd: parameter type is unknown error	Günce Kaya	12:36
Re: Fwd: parameter type is unknown error	Charles Clavadetscher	12:51
Re: parameter type is unknown error 📎	Samed YILDIRIM	13:27
Re: Fwd: parameter type is unknown error	Adrian Klaver	14:12
Re: Fwd: parameter type is unknown error	Charles Clavadetscher	14:20

March 7, 2017

Thread	Author	Time
Re: Fwd: parameter type is unknown error	Günce Kaya	04:18

March 20, 2017

Thread	Author	Time
Equivalent data type for SQL_Variant not found	Ghosh, Snehashish	13:12
Re: Equivalent data type for SQL_Variant not found	Adrian Klaver	13:54

March 27, 2017

Thread	Author	Time
Column widening without outage	Aniruddha Deshpande	08:29
daisychain rows to detect value	Gary Stainburn	09:58
Re: daisychain rows to detect value	David G. Johnston	15:59

March 30, 2017

Thread	Author	Time
Query Advice	Gary Chambers	18:03
Re: Query Advice	David G. Johnston	18:13
Re: Query Advice	Vincent Elschot	18:16
Re: Query Advice	Rob Sargent	18:17
Re: Query Advice	Jason Aleski	18:27
Re: Query Advice	Gary Chambers	19:19
Re: Query Advice	Gary Chambers	19:22

April 2, 2017

Thread	Author	Time
Crosstab function	Gowtham Vel	16:05

April 3, 2017

Thread	Author	Time
Re: Crosstab function	Adrian Klaver	14:39

April 4, 2017

Thread	Author	Time
Re: Crosstab function 📎	Gowtham Vel	18:28

April 5, 2017

Thread	Author	Time
Re: Crosstab function	Gowtham Vel	17:04

April 6, 2017

Thread	Author	Time
Re: Crosstab function	Adrian Klaver	00:01

April 7, 2017

Thread	Author	Time
death of array?	Rob Sargent	02:32
Re: death of array?	David G. Johnston	03:02
Re: death of array?	Achilleas Mantzios	06:28
Re: death of array?	Rob Sargent	15:22
Re: death of array?	David G. Johnston	15:26
Re: death of array?	Rob Sargent	15:57
Re: death of array?	David G. Johnston	16:02
Re: death of array?	Rob Sargent	16:17

April 8, 2017

Thread	Author	Time
Re: death of array?	Rob Sargent	21:07

April 10, 2017

Thread	Author	Time
Re: death of array?	Achilleas Mantzios	06:50
Re: death of array?	Rob Sargent	14:41

April 12, 2017

Thread	Author	Time
CTEs and re-use	Rob Sargent	00:41
Re: CTEs and re-use	David G. Johnston	01:47
Re: CTEs and re-use	Rob Sargent	02:47
Re: CTEs and re-use	Rob Sargent	03:05
Re: CTEs and re-use	Rosser Schwarz	04:04
Re: CTEs and re-use	Rob Sargent	16:29

April 13, 2017

Thread	Author	Time
Best way to store Master-Detail Data	Alvin Díaz	03:51
Re: Best way to store Master-Detail Data	David G. Johnston	04:15
Re: Best way to store Master-Detail Data	Andreas Kretschmer	10:54
Re: Best way to store Master-Detail Data	Alvin Díaz	13:08

April 20, 2017

Thread	Author	Time
Please advice on query optimization	Muhannad Shubita	16:43
Re: Please advice on query optimization 📎	Samed YILDIRIM	17:18
Re: Please advice on query optimization	Muhannad Shubita	17:35
Re: Please advice on query optimization 📎	Samed YILDIRIM	19:29
Re: Please advice on query optimization	David G. Johnston	19:37
Re: Please advice on query optimization	Muhannad Shubita	20:07
Re: Please advice on query optimization	Hector Vass	22:04

Browse Archives

Prev | Next