pgsql-sql since 2014-11-21 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

Nov. 21, 2014

Thread Author Time
pl/pgsql examples Suresh Raja 15:48
Re: pl/pgsql examples Adrian Klaver 15:59
Re: pl/pgsql examples Oliver Christina 19:08

Nov. 26, 2014

Thread Author Time
generating the average 6 months spend excluding first orders Ron256 03:00
Re: generating the average 6 months spend excluding first orders David G Johnston 03:53
Re: generating the average 6 months spend excluding first orders Ron256 04:56
Re: generating the average 6 months spend excluding first orders Ron256 14:35
Re: generating the average 6 months spend excluding first orders Ron256 17:37
Re: generating the average 6 months spend excluding first orders David G Johnston 17:50
Re: generating the average 6 months spend excluding first orders Ron256 17:55
Re: generating the average 6 months spend excluding first orders David G Johnston 18:04
Re: generating the average 6 months spend excluding first orders Ron256 18:19
Re: generating the average 6 months spend excluding first orders Ron256 18:21
Re: generating the average 6 months spend excluding first orders Ron256 18:34
Re: generating the average 6 months spend excluding first orders Ron256 19:26
Re: generating the average 6 months spend excluding first orders Ron256 19:51

Nov. 27, 2014

Thread Author Time
Querying with arrays Tim Dudgeon 13:09
Re: Querying with arrays Tom Lane 14:54
Re: Querying with arrays Tim Dudgeon 16:55

Nov. 30, 2014

Thread Author Time
regr_slope function with auto creation of X column Jason Aleksi 00:27
Re: regr_slope function with auto creation of X column David G Johnston 03:01

Dec. 3, 2014

Thread Author Time
Re: generating the average 6 months spend excluding first orders Ron256 14:42

Dec. 4, 2014

Thread Author Time
Re: Querying with arrays Tim Dudgeon 13:42
Re: Querying with arrays Achilleas Mantzios 13:54
Re: Querying with arrays Gerardo Herzig 19:56

Dec. 5, 2014

Thread Author Time
rolling window without aggregation Huang, Suya 07:25
Re: rolling window without aggregation David G Johnston 07:35

Dec. 7, 2014

Thread Author Time
querying with index on jsonb slower than standard column. Why? Tim Dudgeon 22:59

Dec. 8, 2014

Thread Author Time
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 00:19
Re: querying with index on jsonb slower than standard column. Why? Tim Dudgeon 00:43
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 00:53
Re: querying with index on jsonb slower than standard column. Why? Tim Dudgeon 01:05
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 01:15
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 01:28
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 15:31
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 15:46
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 15:50
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 16:44
Re: querying with index on jsonb slower than standard column. Why? Tom Lane 16:56
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 20:53
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 21:14
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 21:22
Re: querying with index on jsonb slower than standard column. Why? Adrian Klaver 21:34
Re: [SQL] querying with index on jsonb slower than standard column. Why? Tim Dudgeon 21:39

Dec. 9, 2014

Thread Author Time
Re: Check/unique constraint question Scott Rohde 18:01
Re: Check/unique constraint question Tom Lane 18:43
Re: Check/unique constraint question Scott Rohde 22:06
Re: Check/unique constraint question Tom Lane 22:16

Dec. 12, 2014

Thread Author Time
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Josh Berkus 21:24
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 21:44
Re: [PERFORM] Re: querying with index on jsonb slower than standard column. Why? Claudio Freire 22:10
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Andrew Dunstan 23:27

Dec. 13, 2014

Thread Author Time
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 01:20
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Andrew Dunstan 03:05
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Claudio Freire 05:38

Dec. 14, 2014

Thread Author Time
foregin table insert error Ed Rahn 09:13
Re: foregin table insert error Adrian Klaver 14:30
Re: foregin table insert error Ed Rahn 16:49
Re: foregin table insert error Adrian Klaver 18:39
Re: foregin table insert error Adrian Klaver 18:53

Dec. 29, 2014

Thread Author Time
localtime(0) Suresh Raja 16:31
Re: localtime(0) Rene Romero Benavides 16:39
Re: localtime(0) Jonathan S. Katz 16:39

Jan. 6, 2015

Thread Author Time
Add new field with auto-icrement to existing table Brice André 16:31
Re: Add new field with auto-icrement to existing table Andreas Kretschmer 17:44
Re: Add new field with auto-icrement to existing table Brice André 20:26

Jan. 7, 2015

Thread Author Time
Count values that match elements in csv string sqlnewbie2015 00:05
Re: Count values that match elements in csv string David G Johnston 02:21
Use a TEXT string which is an output from a function for executing a new query in postgres Roy Blum 18:12
Re: Use a TEXT string which is an output from a function for executing a new query in postgres Rob Sargent 18:16

Jan. 8, 2015

Thread Author Time
Re: Use a TEXT string which is an output from a function for executing a new query in postgres Craig Ringer 00:08

Jan. 11, 2015

Thread Author Time
pg_stat_acvtivity Marcin Krawczyk 12:29
Re: pg_stat_acvtivity Pavel Stehule 13:47

Jan. 16, 2015

Thread Author Time
fifo stock calculation with window function Dmitry Teslenko 10:07

Jan. 23, 2015

Thread Author Time
commit inside a function failing Suresh Raja 19:56
Re: [SQL] commit inside a function failing Pavel Stehule 20:00
Re: commit inside a function failing Adrian Klaver 20:04
Re: [SQL] commit inside a function failing [email protected] 20:06
Better way to compute moving averages? Jason Aleski 22:58

Jan. 24, 2015

Thread Author Time
Re: Better way to compute moving averages? David G Johnston 00:50
Re: Better way to compute moving averages? Jason Aleski 02:36
Re: commit inside a function failing 📎 Christopher Browne 15:26

Jan. 26, 2015

Thread Author Time
check if the same function is already running, then exit! Suresh Raja 19:58
Re: check if the same function is already running, then exit! Pavel Stehule 20:01
Re: check if the same function is already running, then exit! Andy Colson 20:05

Jan. 28, 2015

Thread Author Time
Re: How to insert in a table the error returns by query David G Johnston 16:55
Re: How to insert in a table the error returns by query ciamblex 17:49
Re: How to insert in a table the error returns by query David G Johnston 18:22
Re: How to insert in a table the error returns by query Marc Mamin 18:52
Re: How to insert in a table the error returns by query David G Johnston 19:03

Jan. 29, 2015

Thread Author Time
Re: How to insert in a table the error returns by query Marc Mamin 18:01

Feb. 10, 2015

Thread Author Time
Implementing incremental client updates Nii Gii 11:39
Re: Implementing incremental client updates Glyn Astill 13:05

Feb. 11, 2015

Thread Author Time
Advisory locks Tom Paynter 10:32
Re: Advisory locks daku.sandor 10:40
Re: Advisory locks Tom Paynter 10:49

March 5, 2015

Thread Author Time
Schema for caching message-count in folders using triggers Andreas Joseph Krogh 19:45
Re: Schema for caching message-count in folders using triggers Adrian Klaver 19:59
Re: Schema for caching message-count in folders using triggers Andreas Joseph Krogh 20:04
Re: Schema for caching message-count in folders using triggers Adrian Klaver 20:31
Re: Schema for caching message-count in folders using triggers Alvaro Herrera 21:16
Re: Schema for caching message-count in folders using triggers Andreas Joseph Krogh 21:20

March 6, 2015

Thread Author Time
Find inconsistencies in data with date range Jason Aleski 21:38
Re: Find inconsistencies in data with date range Adrian Klaver 22:12

March 7, 2015

Thread Author Time
Re: Find inconsistencies in data with date range David G Johnston 03:00
Re: Find inconsistencies in data with date range s d 16:42

March 8, 2015

Thread Author Time
trigger to access only the last transaction avpro avpro 22:01

March 9, 2015

Thread Author Time
Re: trigger to access only the last transaction Marcos Almeida Azevedo 07:29
Re: trigger to access only the last transaction Frank Pinto 07:46
Re: trigger to access only the last transaction avpro avpro 07:50
Re: trigger to access only the last transaction avpro avpro 07:50