Home > mailing lists

Mailing lists [pgsql-sql]

1 August 2000

00:34 Re: What's ETA for read/write Views? Tom Lane
16:14 Re: New book on Postgres Christopher Sawtell
16:19 on line numbers, drop table errors, and log files Jon Lapham
16:22 copy with libpq? Jerome Raupach
16:37 PL/Tcl Roberto Mello
17:32 Re: on line numbers, drop table errors, and log files Michael Richards
19:35 SQL Question Daryl Herzmann

2 August 2000

06:34 Antw: SQL Question Gerhard Dieringer
11:59 Re: on line numbers, drop table errors, and log files Jon Lapham
12:42 Time Aggregates Itai Zukerman
14:25 Re: Time Aggregates Thomas Lockhart
14:52 Re: Time Aggregates Itai Zukerman
14:55 Re: Time Aggregates David Lloyd-Jones
19:20 postgresql and java2 JavierG
20:42 Re: on line numbers, drop table errors, and log files Michael Richards
20:55 Re: on line numbers, drop table errors, and log files Tom Lane

3 August 2000

04:09 What is happening? Carolyn Lu Wong
07:41 a question about dates and timestamp Ange Michel POZZO
07:59 Re: a question about dates and timestamp Karel Zak
08:59 Re: a question about dates and timestamp Ange Michel POZZO
09:39 Re: a question about dates and timestamp Karel Zak
10:44 Re: What is happening? The Hermit Hacker
12:50 Extracting data by months Antti Linno
14:06 Re: What is happening? Tom Lane
14:21 Re: a question about dates and timestamp Tom Lane
14:25 SQL (table transposition) Dana.Reed@clinicaldatacare.com
14:30 PL/pgSQL evaluation order Mark Volpe
14:33 Re: PL/pgSQL Mark Volpe
14:46 Re: SQL (table transposition) Mark Volpe
16:52 A question about indexes... Alexaki Sofia
18:22 Re: Extracting data by months John McKown
19:21 Re: A question about indexes... Tom Lane
20:53 Re: PL/pgSQL evaluation order Mark Volpe

4 August 2000

02:10 Recursive SQL
04:54 Re: Extracting data by months Daniel Kalchev
06:25 Re: SQL (table transposition) Volker Paul
07:39 Re: Extracting data by months Sandis
08:35 Strange strategy with COALESCE? Philip Warner
09:03 Re: A question about indexes... Alexaki Sofia
11:59 RE: SQL (table transposition) Henry Lafleur
12:25 Re: Extracting data by months Daniel Kalchev
13:46 Re: Extracting data by months Karel Zak
17:49 Database in recovery mode Michael Richards
20:57 Re: What's ETA for read/write Views? Peter Eisentraut

6 August 2000

04:34 Re: A question about indexes... Tom Lane
06:11 Re: Database in recovery mode Tom Lane
22:33 Rules, Select, Union Itai Zukerman

7 August 2000

00:09 Re: Rules, Select, Union Tom Lane
08:18 Functions too slow, even with iscachable? Ang Chin Han
08:56 Re: Functions too slow, even with iscachable? Philip Warner
11:15 Re: Functions too slow, even with iscachable? Philip Warner
13:43 Subselect and limit/order? Philip Warner
13:47 Re: Functions too slow, even with iscachable? Ross J. Reedstrom
13:58 Re: Functions too slow, even with iscachable? Tom Lane
14:07 Re: Functions too slow, even with iscachable? Philip Warner
14:20 Changing user passwords Rob van der Leek
14:52 Re: Functions too slow, even with iscachable? Tom Lane
18:39 foreign key take too much time to check Jie Liang
18:57 Re: foreign key take too much time to check Mark Volpe
19:00 PL/pgSQL Jie Liang

8 August 2000

03:09 Re: Subselect and limit/order? Philip Warner
05:24 Re: Subselect and limit/order? Philip Warner
11:55 Re: Changing user passwords Nagy Laszlo Zsolt , KLTE TTK pm1
12:45 Re: Changing user passwords Rob van der Leek
13:09 returning a recordset with pl/pgsql Keith Wong
14:58 Re: Changing user passwords Bernie Huang

9 August 2000

05:59 Re: Functions too slow, even with iscachable? Ang Chin Han
06:02 Aggregate functions, fast! (long) Ang Chin Han
06:43 Re: Aggregate functions, fast! (long) Ang Chin Han
12:42 any tool "return query results to a grid " luc00
15:04 Rules aren't doing what I expect Mark Volpe

10 August 2000

01:30 Re: Rules aren't doing what I expect Ang Chin Han
13:23 Re: Rules aren't doing what I expect Mark Volpe

11 August 2000

01:46 Problem with SQL query (eats swap) pgsql-sql@ruby.sartorelli.gen.nz (Mailing List Expander)
13:10 Re: Rules aren't doing what I expect Tom Lane
14:54 Re: Problem with SQL query (eats swap) Tom Lane
15:04 Re: Rules aren't doing what I expect Mark Volpe
16:15 Trying to Creat a Rule Madel, Kurt
22:25 [Fwd: I will be at Linux World] Zot O'Connor

12 August 2000

00:15 non-cachable 'C' language functions Forest Wilkinson
00:21 Week of the Year? David Lloyd-Jones
00:34 Re: non-cachable 'C' language functions Tom Lane
01:41 Re: Week of the Year? David Lloyd-Jones
01:52 Re: Week of the Year? John McKown
04:48 Operator Precedence problem? Philip Warner
12:47 Re: Week of the Year? John McKown
12:51 Re: Operator Precedence problem? John McKown
12:58 Re: Operator Precedence problem? Philip Warner
14:56 Re: Operator Precedence problem? Tom Lane

13 August 2000

06:05 Re: Operator Precedence problem? Jesus Aneiros

14 August 2000

13:15 select an entry with a NULL date field Web Manager
16:06 Re: select an entry with a NULL date field Kate Collins
16:16 Re: select an entry with a NULL date field
16:38 Re: select an entry with a NULL date field Mark Volpe
17:16 RE: select an entry with a NULL date field Henry Lafleur
19:06 Re: select an entry with a NULL date field Jesus Aneiros
19:36 copy from Adam Lang
19:46 Creating A Rule to Increment a class size when a student adds tha t class to their schedule Madel, Kurt
20:37 RE: select an entry with a NULL date field Jesus Aneiros

15 August 2000

05:23 Functions with Null Arguments? Thomas Swan
07:34 My Indices doesn't work Martin Dolog
07:43 Language dependent fields Volker Krebs
10:08 8K Limit, whats the best strategy? Keith Wong
10:09 Re: postgresql and java2 Peter Mount
11:10 Re: Functions with Null Arguments? DalTech - CTE
11:28 Re: copy from Adam Lang
11:29 data integrity Sandis
12:08 Re: data integrity Jesus Aneiros
12:25 Re: Language dependent fields Volker Krebs
13:12 Re[2]: data integrity Sandis
13:27 ERROR: unexpected SELECT query in exec_stmt_execsql() Branden R. Williams
14:39 Re: 8K Limit, whats the best strategy? Thomas Swan
14:47 Re: 8K Limit, whats the best strategy? Adam Lang
15:43 Re: copy from Adam Lang
16:13 PL/pgSQL Jie Liang
16:39 PL/PGSQL Function problem. Dirk Elmendorf
17:01 Use a rule or a transaction Madel, Kurt
17:04 Re: 8K Limit, whats the best strategy? Poul L. Christiansen
17:16 Re: copy from Adam Lang
17:55 RE: Use a rule or a transaction Madel, Kurt
18:03 % escape Jie Liang
18:44 RE: Use a rule or a transaction Madel, Kurt
18:49 Re: Functions with Null Arguments? Jesus Aneiros
19:20 Re: % escape Jesus Aneiros
19:21 RE: Use a rule or a transaction Madel, Kurt
19:27 Accessing field properties Campbell, Scott
20:30 RE: Use a rule or a transaction Jesus Aneiros
22:18 Re: Functions with Null Arguments? Thomas Swan
22:19 Re: copy from Stephan Szabo
22:20 Re: My Indices doesn't work Stephan Szabo
22:20 Re: PL/PGSQL Function problem. Stephan Szabo
22:21 Re: copy from Stephan Szabo
22:23 Re: Copwatch database Qiron Adhikary
22:23 Re: Use a rule or a transaction Antoine Reid
22:23 Re: Functions with Null Arguments? Thomas Swan
22:25 Re: Use a rule or a transaction Antoine Reid
22:25 Re: Use a rule or a transaction Antoine Reid
22:26 sql programming Michael Wagner
22:27 Re: copy from Stephan Szabo

16 August 2000

03:53 Re: sql programming Webb Sprague
04:23 Re: sql programming kumar1@home.com (Prasanth A. Kumar)
06:35 variables in SQL?? Francisco Hernandez
06:38 lo_export and files permissions mike.baroukh@netcourrier.com
08:56 Re: lo_export and files permissions Guo Bin
08:56 Re: returning a recordset with pl/pgsql Kovacs Zoltan Sandor
09:04 Re: lo_export and files permissions Mike Baroukh
10:41 Re: variables in SQL?? Volker Paul
11:08 Re: variables in SQL?? DalTech - CTE
12:34 Many-to-one subquery Martin Christensen
15:17 Trigger vs rule Richard E Nairn

17 August 2000

00:41 Re: car mileage summation / sledgehammer method Francisco Hernandez
03:45 Help on some SQL command... Ang Sei Heng
03:55 car mileage summation / sledgehammer method Oliver Seidel
07:52 optimization in C Jerome Raupach
08:32 Re: Help on some SQL command... Guo Bin
11:02 Re: car mileage summation / sledgehammer method Maarten Boekhold
12:01 Re: Help on some SQL command... Jesus Aneiros
12:31 optimization in C Jerome Raupach
13:09 Beginner problems with functions (Was: Is this the wrong list?) Andreas Tille
13:38 Re: car mileage summation / sledgehammer method Ross J. Reedstrom
13:43 Continuous inserts... Joerg Hessdoerfer
13:54 Re: Continuous inserts... Poul L. Christiansen
14:24 CREATE USER through SQL possible? Adams, Joe
14:37 ... Joerg Hessdoerfer
14:49 Re: Beginner problems with functions (Was: Is this the wrong list?) Stephan Szabo
15:49 Re: Continuous inserts... Stephan Szabo
16:01 Fetch the latest log for each product Bernie Huang
16:36 Re: Fetch the latest log for each product Jeff Hoffmann
17:40 Re: Continuous inserts... Webb Sprague

18 August 2000

03:13 Re: Continuous inserts... brianb-pgsql@edsamail.com
07:03 database design and diagraming book recommendations.. Francisco Hernandez
07:07 Re: Continuous inserts... Joerg Hessdoerfer
07:09 Re: Continuous inserts... Joerg Hessdoerfer
07:24 [Fwd: Optimization in C] Jerome Raupach
10:02 Re: Continuous inserts... Poul L. Christiansen
10:58 Re: Continuous inserts... Joerg Hessdoerfer
11:49 sequences in functions Graham Vickrage
13:22 Re: sequences in functions Yury Don
14:14 update rule loops Poul L. Christiansen
14:21 Re: Continuous inserts... Stephan Szabo
14:24 Re: update rule loops Stephan Szabo
15:16 Re: [GENERAL] Re: variables in SQL?? Craig Johannsen
15:20 Re: [HACKERS] [Fwd: Optimization in C] Thomas Lockhart
16:32 RE: sequences in functions Graham Vickrage
18:07 Creating sequences Adam Lang

19 August 2000

05:35 Tuple size limit. Christopher Sawtell
18:32 Failing query... Shaun
20:34 Re: Failing query... Tom Lane
20:38 Re: Tuple size limit. Tom Lane

20 August 2000

14:59 Speed or configuration Franz J Fortuny
15:29 protecting a field after creation Louis-David Mitterrand
16:32 Re: protecting a field after creation Tom Lane
17:00 Re: Speed or configuration The Hermit Hacker
17:20 Re: Speed or configuration Tom Lane
17:25 Re: Speed or configuration Stephan Szabo
17:47 datatype SET Marc Roos
18:07 update syntax error? k.c. hemelstrand
18:21 Re: database design and diagraming book recommendations.. David Lloyd-Jones
18:27 Re: update syntax error? The Hermit Hacker
21:04 RE: Speed or configuration Franz J Fortuny
21:08 RE: Speed or configuration Franz J Fortuny
22:01 RE: Speed or configuration The Hermit Hacker

21 August 2000

13:11 Re: update syntax error? mikeo
13:34 Re: Beginner problems with functions Andreas Tille
14:36 Re: 8K Limit, whats the best strategy? Poul L. Christiansen
14:46 Best way to create DML/DDL log? Ingram, Bryan
15:20 Re: Best way to create DML/DDL log? Webb Sprague
15:51 Re: Re: Beginner problems with functions Stephan Szabo
16:30 NULL function arguments? Mark Volpe
16:57 Upper case or lower case.... Franz J Fortuny
16:58 Speed or configuration Franz J Fortuny
18:35 Re: Creating sequences Adam Lang
18:35 Re: Best way to create DML/DDL log? Ingram, Bryan
19:26 Re: 8K Limit, whats the best strategy? Jan Wieck
22:04 Copying data with triggers Keith Wong
22:26 copy DELETES to audit table jason watkins
22:27 Re: Copying data with triggers Tom Lane
23:15 Re: 8K Limit, whats the best strategy? Jan Wieck
23:25 RE: [GENERAL] Re: database design and diagraming book recom mendations.. Craig L. Ching

22 August 2000

06:40 Re: Beginner problems with functions Andreas Tille
06:47 Re: Continuous inserts... Joerg Hessdoerfer
09:03 using INTERSECT and UNION in IN clause Alex Guryanow
10:56 tip: weird parse error for pl/pgsql Keith Wong
10:57 Time Help Brian C. Doyle
13:25 Re: Time Help Brian C. Doyle
13:27 Re: using INTERSECT and UNION in IN clause Tom Lane
13:29 Re: Time Help Mark Volpe
13:37 Re: Time Help Mark Volpe
14:03 Re: Time Help Mark Volpe
14:04 Re: tip: weird parse error for pl/pgsql Tom Lane
15:01 Re: Continuous inserts... Stephan Szabo
15:02 Null function parameters Graham Vickrage
15:37 Re: Time Help Brian C. Doyle
16:22 Re: Null function parameters Tom Lane
16:29 Re: Continuous inserts... Jan Wieck
17:23 Re: Continuous inserts... Tom Lane

23 August 2000

07:52 Re: Continuous inserts... Joerg Hessdoerfer
09:16 Using SETOF in plpgsql function hlefebvre
09:17 Date of creation and of change Andreas Tille
09:25 Re: Date of creation and of change hlefebvre
11:20 Re: Null function parameters tolik@aaanet.ru (Anatoly K. Lasareff)
11:22 RE: Using SETOF in plpgsql function Graham Vickrage
11:26 Re: Using SETOF in plpgsql function hlefebvre
11:28 RE: Null function parameters Graham Vickrage
12:24 Re: Using SETOF in plpgsql function Jan Wieck
12:38 Re: Null function parameters tolik@aaanet.ru (Anatoly K. Lasareff)
12:50 Re: Using SETOF in plpgsql function Karel Zak
12:50 Re: Using SETOF in plpgsql function Andreas Tille
12:51 Re: Date of creation and of change Andreas Tille
12:55 Re: Date of creation and of change Andreas Tille
13:13 Re: Null function parameters Tom Lane
13:22 Re: Re: Date of creation and of change hlefebvre
13:25 Re: Using SETOF in plpgsql function Tom Lane
13:36 Re: Re: Date of creation and of change Tom Lane
13:37 Copy To - fixed width Adam Lang
13:49 Re: Copy To - fixed width Adam Lang
13:51 Create table in functions Andreas Tille
14:37 Re: Create table in functions Tom Lane
15:07 Re: Using SETOF in plpgsql function Jan Wieck
15:49 Re: Create table in functions Jie Liang
16:03 db benchmarks drfrog@smartt.com
16:03 Re: Speed or configuration Franz J Fortuny
23:55 RE: Create table in functions Hiroshi Inoue

24 August 2000

04:51 Re: Create table in functions Tom Lane
05:28 RE: Create table in functions Hiroshi Inoue
06:10 Re: Null function parameters tolik@aaanet.ru (Anatoly K. Lasareff)
08:33 Re: Create table in functions hlefebvre
13:10 sorting in UNICODE table Alex Guryanow
16:25 Is there a way to tell if db has changed? Ingram, Bryan
17:24 Question on string value expression wildcarding Steve Wampler
17:30 weird structure rdg@viafractal.com.br
17:56 Re: weird structure Ryan Williams
17:57 Re: Question on string value expression wildcarding Stephan Szabo
18:38 Dynamic SQL BouSaada Nabil
21:36 Re: weird structure Renato De Giovanni

25 August 2000

02:17 Regular expression query Rodger Donaldson
02:30 Re: weird structure Yury Don
02:34 Re: [GENERAL] Getting the result of a query using COUNT(*) Yury Don
03:23 Re: Regular expression query Tom Lane
06:34 RE: Create table in functions Andreas Tille
10:12 Re: Date of creation and of change Andreas Tille
10:44 Re: Re: Date of creation and of change hlefebvre
12:05 Re: Date of creation and of change Andreas Tille
13:13 Re: Re: Date of creation and of change hlefebvre
13:24 Re: Re: Date of creation and of change Tom Lane
13:51 Re: Date of creation and of change Andreas Tille
13:53 Re: Re: Date of creation and of change hlefebvre
14:03 Re: Date of creation and of change Andreas Tille
14:12 Re: Re: Date of creation and of change hlefebvre
14:14 Re: weird structure Renato De Giovanni
18:25 queries and inserts Rini Dutta

27 August 2000

11:31 Time Results Conversion Brian C. Doyle
19:01 Select subset of rows Paulo Roberto Siqueira
20:13 Re: Select subset of rows Stephan Szabo
20:16 Re: Select subset of rows Stephan Szabo
20:58 Re: queries and inserts Mitch Vincent
23:48 Complex query J. Fernando Moyano

28 August 2000

02:50 Re: weird structure Yury Don
03:02 Re: Select subset of rows John McKown
03:22 Re: Select subset of rows Stephan Szabo
06:01 Sql and paradox Lalit
06:02 Re: [GENERAL] sorting in UNICODE table Tatsuo Ishii
06:09 Re: Re: [GENERAL] Getting the result of a query using COUNT(*) Alexandru COSTIN
06:20 Re: Regular expression query Oliver Seidel
06:51 Tutorial Alessandro Valenti
07:08 Argument variables for select Andreas Tille
07:16 shared memory leak in 7.0.2? pierre@kahuna.versions.com
08:24 Re: Argument variables for select Yury Don
09:19 Re: Argument variables for select Andreas Tille
10:03 Can I get this all in one query? Richard Rowell
10:21 Re: Sql and paradox Fabrice Scemama
10:59 Re: Tutorial Christopher Sawtell
13:04 Re: shared memory leak in 7.0.2? Tom Lane
16:30 Re: shared memory leak in 7.0.2? Tom Lane
17:51 Re: shared memory leak in 7.0.2? Pierre Padovani
20:49 better way Sherwin Daganato
23:02 pg_attribute_relid_attnam_index problem after log disk filled up Palle Girgensohn
23:56 Re: pg_attribute_relid_attnam_index problem after log disk filled up Tom Lane

29 August 2000

00:06 Re: better way Renato De Giovanni
00:23 Re: Can I get this all in one query? Renato De Giovanni
02:35 Re: pg_attribute_relid_attnam_index problem after log disk filled up Palle Girgensohn
03:10 Test Stuart Foster
10:22 How do you detect row version changes in PostgreSQL? Craig Manley
11:37 Re: Argument variables for select Andreas Tille
11:45 performance on insert/update Jerome Raupach
12:26 Re: Re: Argument variables for select Keith Wong
13:40 Re: Re: Argument variables for select hlefebvre
13:43 Re: How do you detect row version changes in PostgreSQL? Tom Lane
14:12 Re: performance on insert/update Tom Lane
14:34 Re: Re: Argument variables for select Webb Sprague
15:21 Viewing a function Stuart Foster
21:17 Fw: Viewing a function stuart
21:52 Problems with complex queries ... J. Fernando Moyano
22:44 Re: Problems with complex queries ... Tom Lane
22:48 Re: Problems with complex queries ... Stephan Szabo
23:05 Optimizing huge inserts/copy's Webb Sprague
23:34 Create Primary Key? Webb Sprague

30 August 2000

00:28 Re: Create Primary Key? Stephan Szabo
00:43 Re: Optimizing huge inserts/copy's Jie Liang
00:53 Re: Create Primary Key? Jie Liang
00:55 Re: Optimizing huge inserts/copy's Stephan Szabo
02:52 Re: Create Primary Key + Massive Copy's? Webb Sprague
10:45 Re: Create Primary Key? darcy@druid.net (D'Arcy J.M. Cain)
13:55 Re: Create Primary Key? Stephan Szabo
14:48 Re: Viewing a function Ryan Williams
14:59 function Normunds
15:39 Re: Optimizing huge inserts/copy's Jie Liang
17:56 Re: Optimizing huge inserts/copy's Webb Sprague
18:24 Re: Optimizing huge inserts/copy's Jie Liang
19:11 Re: Optimizing huge inserts/copy's Stephan Szabo
19:34 Re: Optimizing huge inserts/copy's Tom Lane
20:12 7.0.2 questions on encoding and compilation
20:40 Re: [ADMIN] 7.0.2 questions on encoding and compilation Max Pyziur
21:01 Re: [GENERAL] function Jan Wieck

31 August 2000

06:15 Re: Outer join statement ? Alexandru COSTIN
18:25 optimal performance for inserts Rini Dutta