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

Oct. 10, 2014

Thread Author Time
Re: could not access status of transaction pg_multixact issue jim_yates 14:37
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 16:26

Oct. 15, 2014

Thread Author Time
Any postgres API available to get errorcode for PQerrorMessage Roopeshakumar Narayansa Shalgar (rshalgar) 08:17
Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage Tom Lane 16:36
Re: Any postgres API available to get errorcode for PQerrorMessage Rob Sargent 16:37
Re: [GENERAL] Any postgres API available to get errorcode for PQerrorMessage Roopeshakumar Narayansa Shalgar (rshalgar) 16:48
Re: Any postgres API available to get errorcode for PQerrorMessage John R Pierce 17:21

Oct. 16, 2014

Thread Author Time
Re: Any postgres API available to get errorcode for PQerrorMessage Yogesh. Sharma 03:10
Re: library path problems? (was: Completely unrelated) John R Pierce 03:21
Re: library path problems? Adrian Klaver 03:45
Re: Any postgres API available to get errorcode for PQerrorMessage Roopeshakumar Narayansa Shalgar (rshalgar) 07:09
Re: Any postgres API available to get errorcode for PQerrorMessage Adrian Klaver 20:09

Oct. 30, 2014

Thread Author Time
querying within json Tim Dudgeon 14:55
Re: querying within json Giuseppe Broccolo 15:22
[OFFTOPIC] unsubscribe list Roberto Oliveira dos Santos 15:28
Re: [OFFTOPIC] unsubscribe list Adrian Klaver 15:58
Re: querying within json Tim Dudgeon 16:24
Re: querying within json David G Johnston 16:48
return encoding results 📎 Emi Lu 17:37
Re: return encoding results Andreas Kretschmer 17:45
Re: querying within json Tim Dudgeon 19:22

Oct. 31, 2014

Thread Author Time
INT8 / float casting question Filip Rembiałkowski 14:58
best strategy for searching large text fields Campbell, Lance 14:59
Re: INT8 / float casting question [email protected] 15:15
Re: best strategy for searching large text fields Julien Cigar 15:17
Re: INT8 / float casting question Adrian Klaver 15:29
Re: INT8 / float casting question Adrian Klaver 15:45

Nov. 3, 2014

Thread Author Time
Text searching HTML Campbell, Lance 17:15
Re: Text searching HTML Tom Lane 20:09

Nov. 4, 2014

Thread Author Time
text search index help Campbell, Lance 04:56

Nov. 5, 2014

Thread Author Time
Bug or feature in AFTER INSERT trigger? Martin Edlman 13:00
Re: Bug or feature in AFTER INSERT trigger? hubert depesz lubaczewski 14:06

Nov. 7, 2014

Thread Author Time
filtering based on table of start/end times Seb 20:12
Re: filtering based on table of start/end times Tim 21:14
Re: filtering based on table of start/end times Bryan L Nuse 21:58

Nov. 8, 2014

Thread Author Time
Using aggregates to get sums and partial sums in one query Andreas Joseph Krogh 01:18
Re: filtering based on table of start/end times Tim Schumacher 10:26

Nov. 9, 2014

Thread Author Time
Re: filtering based on table of start/end times Seb 18:43

Nov. 10, 2014

Thread Author Time
Re: Using aggregates to get sums and partial sums in one query Igor Neyman 15:33
Re: Using aggregates to get sums and partial sums in one query David G Johnston 16:19
Re: Using aggregates to get sums and partial sums in one query Andreas Joseph Krogh 18:52

Nov. 12, 2014

Thread Author Time
matching against start/end times and diagnostic values (was: filtering based on table of start/end times) Seb 21:49

Nov. 14, 2014

Thread Author Time
Re: matching against start/end times and diagnostic values Seb 17:04

Nov. 17, 2014

Thread Author Time
slow sub-query problem Tim Dudgeon 18:34
Re: slow sub-query problem David G Johnston 18:44
Re: slow sub-query problem David Johnston 19:19
Re: slow sub-query problem Tom Lane 20:10

Nov. 18, 2014

Thread Author Time
Re: slow sub-query problem Tim Dudgeon 08:53
Re: slow sub-query problem Tim Dudgeon 08:57

Nov. 19, 2014

Thread Author Time
Re: slow sub-query problem David G Johnston 01:37
Re: slow sub-query problem daku.sandor 09:27
Re: slow sub-query problem David G Johnston 17:58

Nov. 20, 2014

Thread Author Time
Re: slow sub-query problem Tim Dudgeon 14:12

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
Re: trigger to access only the last transaction Frank Pinto 08:00
Re: trigger to access only the last transaction s d 08:32
Strange Query - Reg sramay 08:35
Re: Strange Query - Reg sramay 08:36

March 10, 2015

Thread Author Time
Re: Strange Query - Reg Adrian Klaver 15:53

March 12, 2015

Thread Author Time
Re: Find inconsistencies in data with date range Jason Aleski 04:10

March 14, 2015

Thread Author Time
Re: Strange Query - Reg bricklen 14:20

March 15, 2015

Thread Author Time
Perfomance 9.1.9 vs 9.4.1 Alexander Uspensky 08:51
Perfomance 9.1.9 vs 9.4.1 Alexander Uspensky 09:50
Re: Perfomance 9.1.9 vs 9.4.1 Pavel Stehule 11:34

March 16, 2015

Thread Author Time
Help with effective query for listing flags in use by messages in a folder Andreas Joseph Krogh 21:59

March 17, 2015

Thread Author Time
Effective query for listing flags in use by messages in a folder Andreas Joseph Krogh 07:45
Re: Effective query for listing flags in use by messages in a folder Hector Vass 13:31
Re: Effective query for listing flags in use by messages in a folder Andreas Joseph Krogh 21:02

March 18, 2015

Thread Author Time
Re: Effective query for listing flags in use by messages in a folder Hector Vass 11:07
Re: Effective query for listing flags in use by messages in a folder Andreas Joseph Krogh 11:59
Re: Effective query for listing flags in use by messages in a folder Hector Vass 12:08
Re: Effective query for listing flags in use by messages in a folder Andreas Joseph Krogh 12:20
Re: Effective query for listing flags in use by messages in a folder Hector Vass 12:54
Re: Effective query for listing flags in use by messages in a folder Andreas Joseph Krogh 13:01
Re: Effective query for listing flags in use by messages in a folder Hector Vass 13:19
Re: Effective query for listing flags in use by messages in a folder Andreas Joseph Krogh 13:37

March 19, 2015

Thread Author Time
Re: Effective query for listing flags in use by messages in a folder Hector Vass 08:28
Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value agharta 16:30
Re: Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value David G. Johnston 17:05

March 20, 2015

Thread Author Time
Re: Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value agharta 07:26
Re: Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value agharta 07:31
'bitwise and' index Lance Jacob 17:27
Re: 'bitwise and' index Igor Neyman 17:33

March 27, 2015

Thread Author Time
check data for datatype Suresh Raja 18:08
Re: check data for datatype Raymond O'Donnell 18:14
Re: [GENERAL] check data for datatype Jerry Sievers 18:53

March 30, 2015

Thread Author Time
Link Office Word form document with data from PostgreSQL avpro avpro 08:20
Re: Link Office Word form document with data from PostgreSQL Tim Clarke 09:22
JSON TO POSTGRE TABLE Kavi 09:54
Re: [GENERAL] JSON TO POSTGRE TABLE Michael Paquier 10:11

Browse Archives

Prev | Next