Home > mailing lists

Mailing lists [pgsql-sql]

1 June 2006

11:07 Table design question David Clarke
13:26 SELECT DISTINCT too slow Miroslav Šulc
13:42 Re: Table design question Rod Taylor
13:53 Re: SELECT DISTINCT too slow Alvaro Herrera
14:50 Re: SELECT DISTINCT too slow Miroslav Šulc
14:53 Re: SELECT DISTINCT too slow Alvaro Herrera
15:03 Re: SELECT DISTINCT too slow Miroslav Šulc
15:20 Re: SELECT DISTINCT too slow Tom Lane
15:40 Re: SELECT DISTINCT too slow Miroslav Šulc
15:41 Re: Table design question Greg Stark
15:46 Re: SELECT DISTINCT too slow Alvaro Herrera
15:46 Re: SELECT DISTINCT too slow Greg Stark
16:07 Re: SELECT DISTINCT too slow Miroslav Šulc
17:03 Re: Table design question postgres@jal.org
17:43 Am I crazy or is this SQL not possible Collin Peters
17:44 Re: Table design question codeWarrior
18:00 Re: Am I crazy or is this SQL not possible Oisin Glynn
18:06 Re: Am I crazy or is this SQL not possible Aaron Bono
18:31 Re: Am I crazy or is this SQL not possible Yasir Malik
18:53 Re: Am I crazy or is this SQL not possible Yasir Malik
18:59 Re: SELECT DISTINCT too slow Florian Weimer
19:21 Re: Am I crazy or is this SQL not possible Tom Lane
19:30 Re: Am I crazy or is this SQL not possible Aaron Bono
19:48 Re: Am I crazy or is this SQL not possible Yasir Malik
19:54 Re: Am I crazy or is this SQL not possible Alvaro Herrera
19:55 Re: Am I crazy or is this SQL not possible Scott Marlowe
20:04 Re: Table design question Chris Browne
20:06 Re: Am I crazy or is this SQL not possible
20:27 Re: Am I crazy or is this SQL not possible Rod Taylor
23:09 Advanced Query
23:44 Re: Table design question postgres@jal.org

2 June 2006

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

4 June 2006

01:25 Get max value from an comma separated string Mauro Bertoli
01:25 distinct aggregate with complex type dont see the equality operator Thomas Chille
01:26 Re: distinct aggregate with complex type dont see the equality operator [solved] Thomas Chille
01:26 Re: Am I crazy or is this SQL not possible maTKO
01:26 Re: Am I crazy or is this SQL not possible Aaron Bono
01:26 Re: Am I crazy or is this SQL not possible Aaron Bono
01:26 Fwd: Stalled post to pgsql-sql Aaron Bono
01:27 datestyle on windows environment: how to set? filippo
02:10 Re: datestyle on windows environment: how to set? Tom Lane

5 June 2006

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

6 June 2006

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

7 June 2006

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

8 June 2006

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

9 June 2006

04:47 Re: empty set Aaron Bono
07:31 Re: empty set Bruno Wolff III
13:00 Re: empty set CG
20:03 Problems Testing User-Defined Function Rommel the iCeMAn
20:33 Re: Problems Testing User-Defined Function George Weaver
21:55 Re: Problems Testing User-Defined Function Jim Buttafuoco

10 June 2006

01:21 Re: Problems Testing User-Defined Function Rommel the iCeMAn
18:11 Re: Problems Testing User-Defined Function Tom Lane

11 June 2006

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

12 June 2006

01:39 COPY to table with array columns (Longish) Phillip Smith
14:42 Fwd: COPY to table with array columns (Longish) Aaron Bono
18:11 Refactor Query...
20:20 Re: Refactor Query... SOLVED
23:46 Re: COPY to table with array columns (Longish) Phillip Smith

13 June 2006

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

14 June 2006

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

15 June 2006

11:02 UTF-8 Problem ? Milen Kulev
11:07 Re: UTF-8 Problem ? Andrew Sullivan
11:10 Re: UTF-8 Problem ? Volkan YAZICI
13:00 Re: UTF-8 Problem ? Milen Kulev
13:19 Re: UTF-8 Problem ? Thomas Beutin
13:34 Re: UTF-8 Problem ? Thomas Beutin
13:42 Re: UTF-8 Problem ? Tom Lane
14:13 listen_addresses = '*' ok, specific address(es) no Geoffrey Knauth
14:37 Re: listen_addresses = '*' ok, specific address(es) no Andrew Sullivan
14:40 Re: listen_addresses = '*' ok, specific address(es) no Tom Lane
15:49 sessions and prepared statements chester c young
19:45 Re: UTF-8 Problem ? Aarni Ruuhimäki
20:59 SQL Technique Question
21:03 Re: SQL Technique Question Andrew Sullivan
21:23 Re: SQL Technique Question Rod Taylor
21:41 Re: SQL Technique Question Michael Glaesemann
22:16 Re: SQL Technique Question
22:19 Re: SQL Technique Question
22:34 Re: SQL Technique Question Michael Glaesemann

16 June 2006

01:33 Repetitive code Joe
02:27 Re: Repetitive code Aaron Bono
02:39 Re: listen_addresses = '*' ok, specific address(es) no Geoffrey Knauth
02:47 Re: listen_addresses = '*' ok, specific address(es) no Tom Lane
02:50 Re: listen_addresses = '*' ok, specific address(es) no (.... and a thread hi-jack!) Phillip Smith
02:52 Re: listen_addresses = '*' ok, specific address(es) no Phillip Smith
03:04 Re: listen_addresses = '*' ok, specific address(es) no (.... and a thread hi-jack!) Tom Lane
03:13 Re: listen_addresses = '*' ok, specific address(es) no (.... and a thread hi-jack!) Phillip Smith
04:14 concurrency problem sathish kumar shanmugavelu
06:28 Re: concurrency problem Richard Huxton
12:28 Re: sessions and prepared statements John DeSoi
12:57 Re: sessions and prepared statements Rod Taylor
13:09 Re: sessions and prepared statements Michael Fuhr
13:28 Re: Repetitive code Joe
13:39 concurrency problem sathish kumar shanmugavelu
14:00 Re: concurrency problem Aaron Bono
14:08 Re: Repetitive code Richard Broersma Jr
14:09 Re: concurrency problem Ash Grove
14:26 Re: Repetitive code Tom Lane
14:29 Re: sessions and prepared statements Aaron Bono
14:34 Re: concurrency problem Aaron Bono
14:40 Re: listen_addresses = '*' ok, specific address(es) no Geoffrey Knauth
14:44 Re: Repetitive code Aaron Bono
15:13 Re: Repetitive code Joe
15:57 Re: Repetitive code Greg Stark
20:20 Re: sessions and prepared statements PFC

17 June 2006

02:29 keeping last 30 entries of a log table Jeff Frost
03:54 Re: concurrency problem sathish kumar shanmugavelu
12:16 Re: keeping last 30 entries of a log table Daniel CAUNE
14:53 Re: concurrency problem Aaron Bono
20:08 any additional date_time functions? Richard Broersma Jr
22:24 Re: concurrency problem Ash Grove

18 June 2006

09:51 Re: any additional date_time functions? Bruno Wolff III
15:28 Re: any additional date_time functions? Richard Broersma Jr
21:24 Re: concurrency problem Aaron Bono

19 June 2006

15:29 Re: concurrency problem Andrew Sullivan
16:16 Re: keeping last 30 entries of a log table Jeff Frost
17:13 Re: keeping last 30 entries of a log table Daniel CAUNE

20 June 2006

13:48 Re: keeping last 30 entries of a log table Dirk Jagdmann
14:12 Re: keeping last 30 entries of a log table Jeff Frost
19:09 Problema com função UPPER Eduardo Giovany Schweigert
19:44 unknown sqlstate code Juliann Meyer
20:16 Re: unknown sqlstate code Tom Lane
22:01 Re: [SQL] Problema com função UPPER Hélder M. Vieira

21 June 2006

14:56 Displaying first, last, count columns Worky Workerson
15:10 Re: Displaying first, last, count columns Aaron Bono
15:22 Re: Displaying first, last, count columns Frank Bax
17:50 How to get a result in one row virgi@lettere.unipd.it
17:57 Re: keeping last 30 entries of a log table Jeff Frost
18:07 Re: How to get a result in one row Frank Bax
18:25 Re: How to get a result in one row Richard Broersma Jr
19:16 Re: How to get a result in one row Frank Bax

22 June 2006

06:06 join on next row Sim Zacks
06:06 Date ranges + DOW select question joseppi c
06:07 Doubt in stored procedure satheesh Gnanasekaran
06:07 Re: keeping last 30 entries of a log table Ben K.
06:25 Re: join on next row Justin Lintz
09:19 Start up question about triggers Forums @ Existanze
13:09 Re: Start up question about triggers Forums @ Existanze
15:25 Re: Date ranges + DOW select question Aaron Bono
15:44 Re: join on next row Aaron Bono
16:03 Re: Start up question about triggers Aaron Bono
16:58 Re: Start up question about triggers Forums @ Existanze

23 June 2006

03:17 Fwd: Start up question about triggers Aaron Bono
05:09 Re: Fwd: Start up question about triggers Richard Broersma Jr
07:15 Re: Fwd: Start up question about triggers Forums @ Existanze
12:37 Re: Fwd: Start up question about triggers George Weaver
14:27 Re: Fwd: Start up question about triggers Richard Broersma Jr
15:48 Re: Fwd: Start up question about triggers Forums @ Existanze
17:28 Re: Fwd: Start up question about triggers Forums @ Existanze
17:35 Re: Fwd: Start up question about triggers Andrew Sullivan
17:48 Re: Fwd: Start up question about triggers Tom Lane

24 June 2006

03:29 Re: Fwd: Start up question about triggers Aaron Bono

26 June 2006

12:33 Re: Fwd: Start up question about triggers Andrew Sullivan
13:59 Re: Fwd: Start up question about triggers Forums @ Existanze
14:15 Re: Fwd: Start up question about triggers Richard Broersma Jr
14:43 Re: Fwd: Start up question about triggers Andrew Sullivan
15:38 Re: Fwd: Start up question about triggers Scott Marlowe
19:43 Re: Fwd: Start up question about triggers Andrew Sullivan
21:22 avg(interval) Jeremiah Elliott
21:37 Re: avg(interval) Tom Lane
22:11 Re: avg(interval) Joe
23:04 Problem w/ Join... Using (...) Syntax
23:16 Re: Problem w/ Join... Using (...) Syntax Alvaro Herrera

27 June 2006

00:52 permissions from system catalogs Kyle Bateman
00:53 Re: avg(interval) Aaron Bono
01:29 Re: permissions from system catalogs Tom Lane
01:36 Re: permissions from system catalogs Michael Fuhr
02:49 Re: avg(interval) Erik Jones
03:19 Re: avg(interval) Joe
08:16 Re: Fwd: Start up question about triggers Forums @ Existanze
11:39 Re: Fwd: Start up question about triggers Andrew Sullivan
11:48 Re: Fwd: Start up question about triggers Forums @ Existanze
12:13 Re: Fwd: Start up question about triggers Joe
14:02 Joins between int and int[] Rodrigo Sakai
15:22 Schema management tool Kyle Bateman
16:26 Re: Schema management tool Josh Berkus
18:37 Re: Fwd: Start up question about triggers Andrew Sullivan
18:39 Re: Fwd: Start up question about triggers Andrew Sullivan
20:13 Re: Fwd: Start up question about triggers Richard Broersma Jr
20:25 Re: Fwd: Start up question about triggers Alvaro Herrera

28 June 2006

05:46 i need solution to this problem Penchalaiah P.
07:33 Re: i need solution to this problem Ragnar
11:44 Re: i need solution to this problem Richard Broersma Jr
14:31 RES: Joins between int and int[] Rodrigo Sakai
15:04 Re: RES: Joins between int and int[] Achilleus Mantzios
16:00 "CASE" is not a variable Keith Worthington
16:16 Re: "CASE" is not a variable Tom Lane
16:19 generate_series with left join Pedro B.
17:35 Re: "CASE" is not a variable Keith Worthington
18:16 Re: "CASE" is not a variable Bricklen Anderson
18:34 Re: generate_series with left join Aaron Bono
19:27 Re: generate_series with left join Pedro B.
20:11 Re: generate_series with left join Aaron Bono
20:16 Re: generate_series with left join Aaron Bono
20:29 Re: generate_series with left join Pedro B.

29 June 2006

04:23 SELECT Aggregate Phillip Smith
04:57 Re: SELECT Aggregate Aaron Bono
05:23 Re: SELECT Aggregate Richard Broersma Jr
05:39 Re: SELECT Aggregate Richard Broersma Jr
06:28 can any one solve this problem Penchalaiah P.
08:00 Re: "CASE" is not a variable Patrick Jacquot
13:40 Data Entry and Query forms Anthony Kinyage
13:50 Re: Data Entry and Query forms Markus Schaber
15:25 Re: SELECT Aggregate Aaron Bono
15:30 Re: can any one solve this problem Aaron Bono
15:42 Re: Data Entry and Query forms Aaron Bono
15:58 Re: Data Entry and Query forms Joe
18:09 Re: Data Entry and Query forms
20:22 Using In Clause For a Large Text Matching Query Jason Farmer
20:32 Documentation Generator for pl/pgsql Daniel Caune
20:52 Re: Using In Clause For a Large Text Matching Query Richard Broersma Jr
21:04 Re: Documentation Generator for pl/pgsql Jonah H. Harris

30 June 2006

00:17 Re: Using In Clause For a Large Text Matching Query Richard Broersma Jr
00:38 Re: SELECT Aggregate Phillip Smith
00:51 Re: SELECT Aggregate Richard Broersma Jr
02:55 Re: SELECT Aggregate Phillip Smith
04:48 Re: SELECT Aggregate Richard Broersma Jr
10:16 Re: Data Entry and Query forms Jure Kodzoman
12:31 Re: Using In Clause For a Large Text Matching Query Jason Farmer
12:35 Views and query planner Mario Splivalo
12:47 Re: Views and query planner Michael Glaesemann
13:23 Re: Views and query planner Mario Splivalo
14:13 Re: Views and query planner Markus Schaber
21:55 Alternative to Select in table check constraint Richard Broersma Jr
22:49 Re: How To Exclude True Values Richard Broersma Jr