pgsql-sql - June 2006

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

June 1, 2006

Thread Author Time
Table design question David Clarke 11:05
SELECT DISTINCT too slow 📎 Miroslav Šulc 13:26
Re: Table design question Rod Taylor 13:41
Re: SELECT DISTINCT too slow Alvaro Herrera 13:53
Re: distinct aggregate with complex type dont see the equality operator [solved] Thomas Chille 14:21
Re: SELECT DISTINCT too slow 📎 Miroslav Šulc 14:49
Re: SELECT DISTINCT too slow Alvaro Herrera 14:53
Re: SELECT DISTINCT too slow 📎 Miroslav Šulc 15:03
Re: SELECT DISTINCT too slow Tom Lane 15:20
Re: SELECT DISTINCT too slow 📎 Miroslav Šulc 15:39
Re: Table design question Greg Stark 15:40
Re: SELECT DISTINCT too slow Alvaro Herrera 15:46
Re: SELECT DISTINCT too slow Greg Stark 15:46
Re: SELECT DISTINCT too slow 📎 Miroslav Šulc 16:06
Re: Table design question postgres 16:44
Am I crazy or is this SQL not possible Collin Peters 17:43
Re: Table design question codeWarrior 17:45
Re: Am I crazy or is this SQL not possible Oisin Glynn 17:59
Re: Am I crazy or is this SQL not possible Aaron Bono 18:05
Re: Am I crazy or is this SQL not possible Yasir Malik 18:13
Re: Am I crazy or is this SQL not possible maTKO 18:29
Re: Am I crazy or is this SQL not possible Aaron Bono 18:38
Re: Am I crazy or is this SQL not possible Aaron Bono 18:39
Fwd: Stalled post to pgsql-sql Aaron Bono 18:42
Re: Am I crazy or is this SQL not possible Yasir Malik 18:53
Re: SELECT DISTINCT too slow Florian Weimer 18:59
Re: Am I crazy or is this SQL not possible Tom Lane 19:21
Re: Am I crazy or is this SQL not possible Aaron Bono 19:30
Re: Am I crazy or is this SQL not possible Yasir Malik 19:47
Re: Am I crazy or is this SQL not possible Alvaro Herrera 19:54
Re: Am I crazy or is this SQL not possible Scott Marlowe 19:54
Re: Table design question Chris Browne 19:56
Re: Am I crazy or is this SQL not possible mark.dingee 20:06
Re: Am I crazy or is this SQL not possible Rod Taylor 20:26
Advanced Query operationsengineer1 23:09
Re: Table design question postgres 23:44

June 2, 2006

Thread Author Time
Re: Advanced Query Michael Fuhr 00:00
Re: Advanced Query operationsengineer1 00:30
Re: Table design question David Clarke 01:19
Re: Am I crazy or is this SQL not possible Aaron Bono 01:44
Re: Am I crazy or is this SQL not possible Tom Lane 02:41
Re: Am I crazy or is this SQL not possible Patrick Jacquot 08:45
Re: Am I crazy or is this SQL not possible 📎 Klay Martens 11:53
Re: Am I crazy or is this SQL not possible Aaron Bono 15:23
Re: Advanced Query Michael Fuhr 17:43
Using Query Result in WHERE Clause operationsengineer1 20:06

June 4, 2006

Thread Author Time
Re: datestyle on windows environment: how to set? Tom Lane 02:10

June 5, 2006

Thread Author Time
Re: Get max value from an comma separated string Bruno Wolff III 02:12
Re: Using Query Result in WHERE Clause Andrew Sullivan 11:10
Re: Get max value from an comma separated string Bricklen Anderson 14:49

June 6, 2006

Thread Author Time
How To Exclude True Values operationsengineer1 00:17
Re: How To Exclude True Values operationsengineer1 02:07
Re: How To Exclude True Values operationsengineer1 02:24
Re: How To Exclude True Values Richard Broersma Jr 02:36
Re: Update Problem Andrew Sullivan 11:10
Update Problem Christian Paul Cosinas 13:04
Re: Advanced Query codeWarrior 14:48
Re: Advanced Query Richard Broersma Jr 15:30
Re: Advanced Query Oisin Glynn 15:41
Re: Advanced Query Scott Marlowe 16:20
Re: Advanced Query codeWarrior 16:20
Re: Advanced Query Andrew Sullivan 16:30
Re: Advanced Query Andrew Sullivan 16:32
Re: Advanced Query Aaron Bono 16:37
Re: How To Exclude True Values operationsengineer1 17:07
Re: How To Exclude True Values Richard Broersma Jr 17:36
Join issue Burak Seydioglu 18:10
Re: Join issue Andrew Sullivan 18:27
Re: How To Exclude True Values operationsengineer1 18:56
How to get list of days between two dates? Christine Desmuke 21:06
Re: How to get list of days between two dates? Aaron Bono 21:17
Re: How to get list of days between two dates? Scott Marlowe 21:22
Re: How To Exclude True Values Richard Broersma Jr 22:13
Re: Join issue operationsengineer1 22:33
Re: How To Exclude True Values operationsengineer1 23:01
Re: How To Exclude True Values Richard Broersma Jr 23:40
Re: Join issue Kenneth B Hill 23:53

June 7, 2006

Thread Author Time
Re: Join issue Michael Glaesemann 00:05
Re: How to get list of days between two dates? Tim Middleton 05:06
Re: Advanced Query Daryl Richter 11:29
Re: Join issue Burak Seydioglu 17:51
Re: Join issue operationsengineer1 19:04
Re: How To Exclude True Values operationsengineer1 19:25
Re: How To Exclude True Values Richard Broersma Jr 20:07
Re: How To Exclude True Values operationsengineer1 20:18
Re: How To Exclude True Values Richard Broersma Jr 20:25
Re: How To Exclude True Values operationsengineer1 23:29

June 8, 2006

Thread Author Time
Query to return modified results at runtime? George Handin 00:29
Re: How To Exclude True Values Richard Broersma Jr 01:03
Re: Query to return modified results at runtime? Richard Broersma Jr 04:32
Concat two fields into one at runtime George Handin 15:50
Re: Query to return modified results at runtime? George Handin 15:50
Re: Query to return modified results at runtime? Kenneth B Hill 15:51
Re: Concat two fields into one at runtime Aaron Bono 15:53
Re: Concat two fields into one at runtime Kenneth B Hill 15:54
Re: Concat two fields into one at runtime Bricklen Anderson 15:54
Re: Concat two fields into one at runtime Oisin Glynn 15:56
pgxml & xpath_table Philippe Lang 16:00
Re: Query to return modified results at runtime? Dias Costa 16:32
empty set CG 21:40
Re: empty set Scott Marlowe 21:42
Re: pgxml & xpath_table Jim C. Nasby 23:09

June 9, 2006

Thread Author Time
Re: empty set Aaron Bono 04:47
Re: empty set Bruno Wolff III 07:33
Re: empty set CG 13:00
Problems Testing User-Defined Function Rommel the iCeMAn 20:01
Re: Problems Testing User-Defined Function George Weaver 20:33
Re: Problems Testing User-Defined Function Jim Buttafuoco 21:45

June 10, 2006

Thread Author Time
Re: Problems Testing User-Defined Function Rommel the iCeMAn 01:19
Re: Problems Testing User-Defined Function Tom Lane 18:11

June 11, 2006

Thread Author Time
Finding multiple events of the same kind Leif B. Kristensen 12:53
Re: Finding multiple events of the same kind Frank Bax 13:27
Re: Finding multiple events of the same kind Leif B. Kristensen 13:34
Re: Finding multiple events of the same kind Richard Broersma Jr 18:36
remove Owen Funkhouser 18:38
Re: Finding multiple events of the same kind Leif B. Kristensen 19:03

June 12, 2006

Thread Author Time
COPY to table with array columns (Longish) Phillip Smith 01:38
Fwd: COPY to table with array columns (Longish) Aaron Bono 14:42
Refactor Query... operationsengineer1 18:11
Re: Refactor Query... SOLVED operationsengineer1 20:19
Re: COPY to table with array columns (Longish) Phillip Smith 23:45

June 13, 2006

Thread Author Time
Re: COPY to table with array columns (Longish) Tom Lane 00:30
Re: COPY to table with array columns (Longish) Aaron Bono 02:58
Re: COPY to table with array columns (Longish) Phillip Smith 03:18
Re: COPY to table with array columns (Longish) Rod Taylor 03:18
Re: COPY to table with array columns (Longish) Richard Broersma Jr 03:51
Re: COPY to table with array columns (Longish) Aaron Bono 04:11
Re: COPY to table with array columns (Longish) Phillip Smith 05:29
Re: Finding multiple events of the same kind Leif B. Kristensen 10:58
Re: COPY to table with array columns (Longish) Aaron Bono 15:05
Re: COPY to table with array columns (Longish) operationsengineer1 18:21
Re: COPY to table with array columns (Longish) operationsengineer1 18:31
Efficient Searching of Large Text Fields Aaron Bono 20:30
Re: Efficient Searching of Large Text Fields Rod Taylor 20:43
Re: Efficient Searching of Large Text Fields PFC 20:52
Re: Efficient Searching of Large Text Fields Aaron Bono 21:04
Error with "limit" clause Rommel the iCeMAn 23:19
Re: COPY to table with array columns (Longish) Phillip Smith 23:22

June 14, 2006

Thread Author Time
Re: COPY to table with array columns (Longish) Aaron Bono 00:41
Re: COPY to table with array columns (Longish) Phillip Smith 00:51
Re: Error with "limit" clause Tom Lane 01:58
Good examples of calling slony stored procedures Mark Adan 02:30
Re: Error with "limit" clause Rommel the iCeMAn 02:37
Re: Good examples of calling slony stored procedures Tom Lane 03:27
to_char with time chester c young 04:09
Re: to_char with time Aaron Bono 04:27
Re: to_char with time Phillip Smith 04:27
Re: Efficient Searching of Large Text Fields Oleg Bartunov 07:07
Re: Efficient Searching of Large Text Fields Oleg Bartunov 07:17
Re: Efficient Searching of Large Text Fields Achilleus Mantzios 07:24
how to replace 0xe28093 char with another one? Sergey Levchenko 09:09
Prepared statements in PGSQL functions Milen Kulev 13:12
Re: Prepared statements in PGSQL functions A. Kretschmer 13:30
Re: how to replace 0xe28093 char with another one? Aaron Bono 13:54
Re: Prepared statements in PGSQL functions Tom Lane 14:35
Re: Prepared statements in PGSQL functions Milen Kulev 15:16
Re: Good examples of calling slony stored procedures Mark Adan 15:50
Re: Good examples of calling slony stored procedures Jim Buttafuoco 15:53
Re: Good examples of calling slony stored procedures Mark Adan 15:55
Re: Good examples of calling slony stored procedures Andrew Sullivan 16:14
Re: Good examples of calling slony stored procedures Mark Adan 16:24
Re: Efficient Searching of Large Text Fields Oleg Bartunov 17:20
About sequences that works BAD !!!! Alexis Palma Espinosa 18:02
Re: About sequences that works BAD !!!! Richard Huxton 18:28
Re: About sequences that works BAD !!!! Terry Lee Tucker 18:39
Requirement for PostgreSQL Database Developer Mark 18:56
Re: Requirement for PostgreSQL Database Developer Tom Lane 19:57
Re: Good examples of calling slony stored procedures Christopher Browne 20:55

June 15, 2006

Thread Author Time
Date ranges + DOW select question joseppi c 10:14
UTF-8 Problem ? Milen Kulev 11:01
Re: UTF-8 Problem ? Andrew Sullivan 11:07
Re: UTF-8 Problem ? Volkan YAZICI 11:08
Re: UTF-8 Problem ? Aarni Ruuhimäki 11:08
Re: UTF-8 Problem ? Thomas Beutin 12:44
Re: UTF-8 Problem ? Milen Kulev 12:59
Re: UTF-8 Problem ? Thomas Beutin 13:33
Re: UTF-8 Problem ? Tom Lane 13:42
listen_addresses = '*' ok, specific address(es) no Geoffrey Knauth 14:05
Re: listen_addresses = '*' ok, specific address(es) no Andrew Sullivan 14:37
Re: listen_addresses = '*' ok, specific address(es) no Tom Lane 14:40
sessions and prepared statements chester c young 15:49
SQL Technique Question operationsengineer1 20:59
Re: SQL Technique Question Andrew Sullivan 21:03
Re: SQL Technique Question Rod Taylor 21:21
Re: SQL Technique Question Michael Glaesemann 21:41
Re: SQL Technique Question operationsengineer1 22:15
Re: SQL Technique Question operationsengineer1 22:19
Re: SQL Technique Question Michael Glaesemann 22:34

June 16, 2006

Thread Author Time
Repetitive code Joe 01:34
Re: listen_addresses = '*' ok, specific address(es) no Geoffrey Knauth 02:06
Re: Repetitive code Aaron Bono 02:26
Re: listen_addresses = '*' ok, specific address(es) no Tom Lane 02:46
Re: listen_addresses = '*' ok, specific address(es) no (.... and a thread hi-jack!) Phillip Smith 02:49
Re: listen_addresses = '*' ok, specific address(es) no Phillip Smith 02:52
Re: listen_addresses = '*' ok, specific address(es) no (.... and a thread hi-jack!) Tom Lane 03:04
Re: listen_addresses = '*' ok, specific address(es) no (.... and a thread hi-jack!) Phillip Smith 03:11
concurrency problem sathish kumar shanmugavelu 04:14
Re: concurrency problem Richard Huxton 06:28
Re: sessions and prepared statements John DeSoi 12:27
Re: sessions and prepared statements Rod Taylor 12:55

Browse Archives

Prev | Next