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

Aug. 11, 2014

Thread Author Time
Re: function call Marcin Krawczyk 09:50
Re: function call Marcin Krawczyk 11:13
How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Andreas Joseph Krogh 16:01
Re: function call David G Johnston 16:13
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Igor Neyman 18:38
Re: function call Adrian Klaver 19:01
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Pavel Stehule 19:34
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' SENADIN 19:49
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Andreas Joseph Krogh 20:08
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Andreas Joseph Krogh 20:19
Re: How to optimize WHERE column_a IS NOT NULL OR column_b = 'value' Pavel Stehule 20:29

Aug. 15, 2014

Thread Author Time
Stack builder Shane Carey 12:54
Re: Stack builder Rene Romero Benavides 15:08

Aug. 17, 2014

Thread Author Time
High memory usage / performance issue ( temp tables ? ) gmb 07:35
Re: High memory usage / performance issue ( temp tables ? ) Marc Mamin 08:50
Re: High memory usage / performance issue ( temp tables ? ) gmb 10:40
Re: High memory usage / performance issue ( temp tables ? ) gmb 19:47
Re: High memory usage / performance issue ( temp tables ? ) Pavel Stehule 19:55

Aug. 18, 2014

Thread Author Time
Re: High memory usage / performance issue ( temp tables ? ) gmb 05:33
Re: High memory usage / performance issue ( temp tables ? ) Pavel Stehule 06:44
Re: function call Marcin Krawczyk 07:57
Re: High memory usage / performance issue ( temp tables ? ) gmb 11:03
Re: High memory usage / performance issue ( temp tables ? ) gmb 11:20
Re: High memory usage / performance issue ( temp tables ? ) Pavel Stehule 12:29
Re: function call Adrian Klaver 22:16

Aug. 22, 2014

Thread Author Time
Retrieve most recent 1 record from joined table agharta 08:05
Re: Retrieve most recent 1 record from joined table Brice André 08:13
Re: Retrieve most recent 1 record from joined table agharta 08:48

Aug. 23, 2014

Thread Author Time
Re: Retrieve most recent 1 record from joined table Vik Fearing 12:15
postgres json: How to query map keys to get children Hector Menchaca 18:02
Re: postgres json: How to query map keys to get children David G Johnston 20:18
Re: postgres json: How to query map keys to get children Hector Menchaca 23:38

Aug. 25, 2014

Thread Author Time
Re: Retrieve most recent 1 record from joined table Thomas Kellerer 05:59

Aug. 27, 2014

Thread Author Time
Re: Retrieve most recent 1 record from joined table agharta 09:04

Sept. 3, 2014

Thread Author Time
xpath does not seem to escape HTML correctly John Lamb 23:47

Sept. 4, 2014

Thread Author Time
Re: xpath does not seem to escape HTML correctly David G Johnston 01:50

Sept. 8, 2014

Thread Author Time
VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Bijayalakshmi Swain 08:48
Re: VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Adrian Klaver 18:21

Sept. 9, 2014

Thread Author Time
VF0258 - Operating System Compatibility for Application PostgreSQL 9.2 Bijayalakshmi Swain 05:04

Sept. 12, 2014

Thread Author Time
Re: VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Alvaro Herrera 04:12
Re: VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Bruce Momjian 11:28
Re: VF0258 - Operating System Compatibility for Application PostgreSQL 9.2 Bruce Momjian 11:32
Re: VF0072 - Operating System Compatibility for Application PostgreSQL 8.3 Craig Ringer 15:55

Sept. 15, 2014

Thread Author Time
Re: How to compare two tables in PostgreSQL Kamal Kumar TRR 10:43

Sept. 17, 2014

Thread Author Time
pg_multixact issues Dev Kumkar 12:16
Re: pg_multixact issues Adrian Klaver 13:21
Re: pg_multixact issues Andres Freund 13:23
Re: [SQL] pg_multixact issues Dev Kumkar 13:50
Re: pg_multixact issues Dev Kumkar 13:51
Re: [SQL] pg_multixact issues Dev Kumkar 14:54
Re: [SQL] pg_multixact issues Dev Kumkar 20:36
Re: pg_multixact issues Adrian Klaver 21:08
Re: [SQL] pg_multixact issues Adrian Klaver 21:11

Sept. 18, 2014

Thread Author Time
Re: pg_multixact issues Dev Kumkar 09:11
Re: [SQL] pg_multixact issues Andres Freund 10:33
Re: [GENERAL] pg_multixact issues Dev Kumkar 12:50
Re: [GENERAL] [SQL] pg_multixact issues Dev Kumkar 17:22
Re: [GENERAL] [SQL] pg_multixact issues Adrian Klaver 21:47

Sept. 19, 2014

Thread Author Time
Re: [GENERAL] pg_multixact issues Alvaro Herrera 02:37
Re: [GENERAL] pg_multixact issues Andres Freund 07:33
Re: [SQL] pg_multixact issues Dev Kumkar 07:51
Re: [GENERAL] pg_multixact issues Dev Kumkar 07:53
Re: pg_multixact issues Emanuel Calvo 13:44
Re: pg_multixact issues Dev Kumkar 14:09

Sept. 23, 2014

Thread Author Time
FOREIGN KEY Reference on multiple columns 09:54
Re: FOREIGN KEY Reference on multiple columns Luca Vernini 09:59
Re: FOREIGN KEY Reference on multiple columns 11:38
Re: FOREIGN KEY Reference on multiple columns Luca Vernini 12:36
Re: FOREIGN KEY Reference on multiple columns 13:10
Re: FOREIGN KEY Reference on multiple columns Adrian Klaver 13:15
Re: FOREIGN KEY Reference on multiple columns Luca Vernini 13:17
Re: FOREIGN KEY Reference on multiple columns 13:38

Sept. 24, 2014

Thread Author Time
Re: FOREIGN KEY Reference on multiple columns Tim Landscheidt 18:02

Sept. 25, 2014

Thread Author Time
Re: FOREIGN KEY Reference on multiple columns 05:04
uuid for each postgres install? Gerardo Herzig 20:02
Re: uuid for each postgres install? Adrian Klaver 20:18
Re: uuid for each postgres install? Gerardo Herzig 21:56
Re: uuid for each postgres install? Ian Lawrence Barwick 22:32

Sept. 26, 2014

Thread Author Time
Re: [GENERAL] pg_multixact issues Dev Kumkar 08:06

Sept. 28, 2014

Thread Author Time
how to see "where" SQL is better than PLPGSQL Gerardo Herzig 18:30
Re: [SQL] how to see "where" SQL is better than PLPGSQL Pavel Stehule 18:49
Re: [SQL] how to see "where" SQL is better than PLPGSQL Gerardo Herzig 19:29
Re: how to see "where" SQL is better than PLPGSQL Pavel Stehule 19:44

Sept. 29, 2014

Thread Author Time
Re: Why data returned inside parentheses in for loop David G Johnston 19:34
Re: Why data returned inside parentheses in for loop David G Johnston 21:16
Re: Why data returned inside parentheses in for loop David G Johnston 21:18

Sept. 30, 2014

Thread Author Time
Re: [SQL] pg_multixact issues Dev Kumkar 15:10
Re: [SQL] pg_multixact issues Alvaro Herrera 15:20
Re: [SQL] pg_multixact issues Dev Kumkar 19:32

Oct. 5, 2014

Thread Author Time
Function with OUT parameter and Return Query Hector Menchaca 04:23
Re: Function with OUT parameter and Return Query Guillaume Lelarge 08:06
Re: Function with OUT parameter and Return Query Hector Menchaca 18:10

Oct. 8, 2014

Thread Author Time
could not access status of transaction pg_multixact issue jim_yates 18:00
Re: could not access status of transaction pg_multixact issue Adrian Klaver 18:40
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 18:55
Re: could not access status of transaction pg_multixact issue jim_yates 19:43
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 20:54
Re: could not access status of transaction pg_multixact issue jim_yates 21:26

Oct. 9, 2014

Thread Author Time
Re: could not access status of transaction pg_multixact issue jim_yates 14:07
Re: could not access status of transaction pg_multixact issue Adrian Klaver 15:01
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 15:12
Re: could not access status of transaction pg_multixact issue jim_yates 17:02
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 18:00
Re: could not access status of transaction pg_multixact issue jim_yates 20:17
Re: could not access status of transaction pg_multixact issue Alvaro Herrera 20:36
Re: could not access status of transaction pg_multixact issue jim_yates 21:51

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

Browse Archives

Prev | Next