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

March 19, 2014

Thread Author Time
Table results format - should I use crosstab? If so, how? Jennifer Mackown 14:58
Re: Table results format - should I use crosstab? If so, how? David Johnston 15:47
Re: Table results format - should I use crosstab? If so, how? hari.fuchs 17:56
Can I use a constraint to make sure all array elements are positive? AlexK 21:59
Re: Can I use a constraint to make sure all array elements are positive? Vik Fearing 22:08
Re: Can I use a constraint to make sure all array elements are positive? Sergey Konoplev 22:20
Re: Can I use a constraint to make sure all array elements are positive? Vik Fearing 22:35

March 20, 2014

Thread Author Time
SQL Query for Foreign constraint Bhim Kumar 08:01
Re: SQL Query for Foreign constraint Igor Neyman 13:48

April 4, 2014

Thread Author Time
Formatting query result like a calendar dahd101+hm3ufk 12:34
Re: Formatting query result like a calendar Jan Ostrochovsky 14:43

April 8, 2014

Thread Author Time
performance drop when function argument is evaluated in WHERE clause Gerardo Herzig 11:53
Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Tom Lane 13:50
Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Gerardo Herzig 17:33
Re: Re: [PERFORM] performance drop when function argument is evaluated in WHERE clause Tom Lane 17:41

May 1, 2014

Thread Author Time
Optimize query for listing un-read messages Andreas Joseph Krogh 12:51

May 4, 2014

Thread Author Time
Re: Optimize query for listing un-read messages Brice André 12:06
Re: Optimize query for listing un-read messages Andreas Joseph Krogh 16:40
Re: Optimize query for listing un-read messages Brice André 16:49
Re: Optimize query for listing un-read messages Andreas Joseph Krogh 16:53
Re: Optimize query for listing un-read messages Brice André 17:43
Re: Optimize query for listing un-read messages Andreas Joseph Krogh 18:03

May 9, 2014

Thread Author Time
group number Rene Romero Benavides 20:15
Re: group number Pavel Stehule 20:22

May 18, 2014

Thread Author Time
matching column of regexps James Cloos 23:44

May 19, 2014

Thread Author Time
Re: matching column of regexps Vik Fearing 00:35
Re: matching column of regexps James Cloos 05:43
How to clean up phone-numbers with regex? Andreas 08:54
Re: How to clean up phone-numbers with regex? Rob Sargent 13:39
Re: How to clean up phone-numbers with regex? Steve Crawford 15:43
Re: How to clean up phone-numbers with regex? Steve Crawford 15:44
Re: How to clean up phone-numbers with regex? Rob Sargent 15:49
Re: How to clean up phone-numbers with regex? David G Johnston 15:52

May 27, 2014

Thread Author Time
Question about Array data type in PostgreSQL and their link with hash table concept Dariyoosh Dariyoosh 12:39
Re: Question about Array data type in PostgreSQL and their link with hash table concept Luca Vernini 12:44
Re: Question about Array data type in PostgreSQL and their link with hash table concept Dariyoosh Dariyoosh 12:50
Set flag column on update if other columns change? Steve Wampler 16:00
Re: Set flag column on update if other columns change? Andreas Kretschmer 16:21
Re: Set flag column on update if other columns change? Steve Wampler 16:23

May 28, 2014

Thread Author Time
Re: Unquoted column names fold to lower case creechy 05:47
Three way foreign keys Gary Stainburn 11:24

May 29, 2014

Thread Author Time
PGsql function timestamp issue ng 20:46
Re: PGsql function timestamp issue Jonathan S. Katz 20:52
Re: PGsql function timestamp issue Steve Crawford 21:13
Re: PGsql function timestamp issue bricklen 22:00

June 9, 2014

Thread Author Time
Re: Parameterized Query David G Johnston 13:36
Problem with strange chars in text filed. Bruce 16:02
Re: Problem with strange chars in text filed. Rob Sargent 16:07
Fwd: Problem with strange chars in text filed. Bruce 17:59
Re: Problem with strange chars in text filed. Adrian Klaver 23:06

June 10, 2014

Thread Author Time
Re: Problem with strange chars in text filed. Bruce 01:44

June 11, 2014

Thread Author Time
Re: need to pass the csv file name as value to the column file_id David G Johnston 13:38
Re: need to pass the csv file name as value to the column file_id David G Johnston 13:42
Re: need to pass the csv file name as value to the column file_id David G Johnston 14:35
Re: need to pass the csv file name as value to the column file_id David G Johnston 16:03

June 12, 2014

Thread Author Time
Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 09:17
Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 09:31
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 14:02
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 19:32
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 19:49
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 19:52
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 20:04
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 20:07
Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables David G Johnston 20:36
Re: Re: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables Andreas Joseph Krogh 21:28

June 13, 2014

Thread Author Time
cannot install 9.4 on trusty because of the libpq5 version rawi 14:01
Re: cannot install 9.4 on trusty because of the libpq5 version Adrian Klaver 14:31
Re: cannot install 9.4 on trusty because of the libpq5 version rawi 14:49

July 23, 2014

Thread Author Time
Is CREATE TABLE non-blocking ? Benjamin Dugast 10:33
Re: Is CREATE TABLE non-blocking ? hubert depesz lubaczewski 13:43
Re: Is CREATE TABLE non-blocking ? David G Johnston 14:18
Re: Is CREATE TABLE non-blocking ? Benjamin Dugast 15:13
Re: Is CREATE TABLE non-blocking ? Rob Sargent 15:52

July 24, 2014

Thread Author Time
Re: Is CREATE TABLE non-blocking ? Benjamin Dugast 08:36

July 25, 2014

Thread Author Time
Re: PGsql function timestamp issue Vinayak Pokale 08:59

July 29, 2014

Thread Author Time
Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 09:52
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 09:56
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 09:59
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:01
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:05
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:12
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:21
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 10:27
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:38
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 10:49
Re: Update columns in the same table in a deferred constraint trigger Pavel Stehule 11:22
Re: Update columns in the same table in a deferred constraint trigger Andreas Joseph Krogh 11:31

July 30, 2014

Thread Author Time
Reg: Sql Join CrashBandi 22:08
Re: Reg: Sql Join David G Johnston 22:45
Re: Reg: Sql Join David G Johnston 22:49
Re: Reg: Sql Join Oliver d'Azevedo Christina 23:09
Re: Reg: Sql Join Gavin Flower 23:34
Re: Reg: Sql Join Gavin Flower 23:43

July 31, 2014

Thread Author Time
Re: Reg: Sql Join CrashBandi 19:34

Aug. 1, 2014

Thread Author Time
PostgreSQL add id column that increments based on data DerekW 09:15
Re: PostgreSQL add id column that increments based on data Jonas Xie 09:55
Re: PostgreSQL add id column that increments based on data Adrian Klaver 13:30
Re: PostgreSQL add id column that increments based on data David G Johnston 16:12

Aug. 4, 2014

Thread Author Time
Re: PostgreSQL add id column that increments based on data DerekW 08:35

Aug. 5, 2014

Thread Author Time
function call Marcin Krawczyk 11:28
Re: function call Adrian Klaver 12:56
Re: function call Adrian Klaver 13:01

Aug. 6, 2014

Thread Author Time
Re: function call Marcin Krawczyk 07:05
Re: function call Marcin Krawczyk 07:41
Re: function call John L. Poole 12:03
Re: function call Adrian Klaver 13:58

Aug. 10, 2014

Thread Author Time
Update Returning as subquery pascal+postgres 16:15
Re: Update Returning as subquery Tom Lane 17:17
Re: Update Returning as subquery David G Johnston 18:10

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

Browse Archives

Prev | Next