Home > mailing lists

Mailing lists [pgsql-sql]

1 June 2002

03:06 Any way to handle exceptions in PL/pgSQL ? Jorg Janke
09:02 Re: Any way to handle exceptions in PL/pgSQL ? PG Explorer
09:35 Re: problem with sql D'Arcy J.M. Cain
09:44 Fw: Postgres function call problems Sandeep Chibber

2 June 2002

00:58 Problem with the result set of postgres Sandeep Chibber
02:55 Postgres Function Call Problem Sandeep Chibber
05:10 alternate idioms for large "IN (...)" lists russm
17:01 Re: alternate idioms for large "IN (...)" lists Christopher Kings-Lynne
23:54 to_date() Paul

3 June 2002

10:20 Re: Syntax error in plpgsql crashes backend Bruce Momjian
10:33 Re: alternate idioms for large "IN (...)" lists russm
11:03 How to update Andre Schubert
12:08 Re: How to update Manfred Koizar
12:53 Re: How to update Andre Schubert
15:09 Re: to_date() Kaare Rasmussen
20:40 passing a list to a function and returning a recordset Marie G. Tuite
22:38 Re: alternate idioms for large "IN (...)" lists Tom Lane

4 June 2002

05:55 Postgres Function Problem Sandeep Chibber
06:39 Re: Postgres Function Problem Achilleus Mantzios
07:13 Is this a feature ? David BOURIAUD
07:18 new itoar function Achilleus Mantzios
07:34 Re: Is this a feature ? Achilleus Mantzios
09:10 Re: new itoar function Oleg Bartunov
11:45 Re: Syntax error in plpgsql crashes backend Joseph D. Barillari
11:45 passing a list to a function and returning a recordset Marie G. Tuite
13:35 Re: Is this a feature ? Jan Wieck
13:40 Re: Is this a feature ? Nick Fankhauser
13:50 Re: Is this a feature ? David BOURIAUD
16:26 Re: Is this a feature ? Joel Burton
19:40 Updating a table from another table Matthew Price
20:28 Re: Updating a table from another table Jean-Luc Lachance
21:03 Some problems with (my?) PlSQL Rui Pacheco
21:26 Re: Some problems with (my?) PlSQL Stephan Szabo
22:06 alter column - NOT NULL Tom Haddon
22:27 Re: Some problems with (my?) PlSQL Rui Pacheco

5 June 2002

03:19 Postgres Function Proble Sandeep Chibber
13:36 Re: Is this a feature ? James Orr
16:11 Re: Further info : Very high load average but no cpu utilization Bruce Momjian
17:11 Indexing Metaphone? Josh Berkus
17:22 extract and variables in PL/pgSQL Roberto Mello
17:38 Getting PID of current logged user Roberto Mello
17:41 Re: Indexing Metaphone? Richard Poole
17:56 Re: Indexing Metaphone? Josh Berkus
18:19 Re: Indexing Metaphone? Stephan Szabo

6 June 2002

01:11 simple select statement inquiry Joseph Syjuco
02:33 Re: simple select statement inquiry Ludwig Lim
07:39 Indexing timestamps Andre Schubert
09:35 Re: PostgreSQL on AIX D'Arcy J.M. Cain
10:18 how to reset serials Joseph Syjuco
10:46 Re: how to reset serials Bruno Wolff III
11:08 Re: how to reset serials Joseph Syjuco
11:22 Re: extract and variables in PL/pgSQL Jan Wieck
11:50 Re: PostgreSQL on AIX Travis Hoyt
15:02 Re: Indexing timestamps Josh Berkus
15:09 Re: extract and variables in PL/pgSQL Roberto Mello
15:12 Re: simple select statement inquiry Joel Burton
16:01 Re: Indexing timestamps Stephan Szabo
16:06 TWO PROBLEMS Ricardo Javier Aranibar León
16:55 Re: Indexing timestamps Josh Berkus
19:24 Old documentation Wei Weng
19:53 Re: Old documentation Manfred Koizar
21:33 Re: Indexing timestamps Stephan Szabo

7 June 2002

03:19 Re: PL/pgSQL TODO Bruce Momjian
09:45 UPDATE ... FROM vs standard SQL Richard Huxton
10:09 arrays as pgsql function parameters Joseph Syjuco
10:23 Re: arrays as pgsql function parameters Achilleus Mantzios
13:50 Re: arrays as pgsql function parameters Joseph Syjuco
14:10 Re: arrays as pgsql function parameters Achilleus Mantzios
14:12 select failure Ian Cass
14:31 Re: UPDATE ... FROM vs standard SQL Jan Wieck
15:12 Re: UPDATE ... FROM vs standard SQL Josh Berkus
15:12 Re: PL/pgSQL TODO Josh Berkus
15:12 Re: PL/pgSQL TODO Josh Berkus
15:31 Re: PL/pgSQL TODO Bruce Momjian
15:40 Re: PL/pgSQL TODO Josh Berkus
15:47 Re: arrays as pgsql function parameters Josh Berkus
15:47 Re: PL/pgSQL TODO Bruce Momjian
16:25 Re: UPDATE ... FROM vs standard SQL Stephan Szabo
16:36 Re: UPDATE ... FROM vs standard SQL Richard Huxton
18:22 Re: PL/pgSQL TODO Jan Wieck
18:37 Re: UPDATE ... FROM vs standard SQL Josh Berkus
18:47 Limiting database size Maurício Sessue Otta
19:41 Re: PL/pgSQL TODO Bruce Momjian
19:43 encryp pass Ricardo Javier Aranibar León
19:48 Re: passing a list to a function and returning a recordset Marie G. Tuite
20:42 Re: Limiting database size Josh Berkus

8 June 2002

01:48 Re: Indexing timestamps Bruce Momjian
01:51 Re: PostgreSQL on AIX Bruce Momjian
01:56 Re: PostgreSQL on AIX Bruce Momjian
01:57 Re: [HACKERS] PostgreSQL on AIX Bruce Momjian
03:16 Re: Indexing timestamps Stephan Szabo

9 June 2002

16:08 Q: will GROUP BY make use of an index to return tuples early? Gunther Schadow
16:43 Support for distributed queries with semijoins could be possible, if ... Gunther Schadow
17:12 Re: select failure Gunther Schadow
17:55 Re: select failure Ian Cass
17:59 Re: Q: will GROUP BY make use of an index to return tuples early? Tom Lane
18:06 Re: Support for distributed queries with semijoins could be possible, if ... Tom Lane
18:28 Re: select failure Tom Lane
19:02 Re: select failure Gunther Schadow
19:10 Re: select failure Ian Cass

10 June 2002

00:03 Re: arrays as pgsql function parameters Joseph Syjuco
07:28 Rule to fill in value on column on insert Bradley Kieser
07:44 Re: Rule to fill in value on column on insert Christopher Kings-Lynne
10:42 Efficient DELETE Strategies Christoph Haller
11:08 VIEWs and FOREIGN keys Achilleus Mantzios
12:29 multiple primary keys and reference Matt
12:30 Re: Limiting database size Tulio Oliveira
12:31 Re: [HACKERS] PostgreSQL on AIX Zeugswetter Andreas SB SD
12:46 Re: Rule to fill in value on column on insert Tom Lane
14:21 Re: Efficient DELETE Strategies Tom Lane
14:32 Re: multiple primary keys and reference Achilleus Mantzios
15:30 Re: multiple primary keys and reference Stephan Szabo
15:49 Re: VIEWs and FOREIGN keys Stephan Szabo
16:29 Re: Efficient DELETE Strategies Bruce Momjian
17:13 Re: VIEWs and FOREIGN keys Jan Wieck
18:10 Re: [HACKERS] Efficient DELETE Strategies Bruce Momjian
18:37 Re: [GENERAL] VIEWs and FOREIGN keys Jan Wieck
19:11 Re: Temporary table weirdness Bruce Momjian
19:54 Re: Efficient DELETE Strategies Manfred Koizar
19:57 Re: [HACKERS] Efficient DELETE Strategies Tom Lane
20:00 Re: [GENERAL] VIEWs and FOREIGN keys Tom Lane
20:52 Re: Efficient DELETE Strategies Tom Lane
21:44 Re: Efficient DELETE Strategies Josh Berkus

11 June 2002

01:51 Re: [HACKERS] Efficient DELETE Strategies Barry Lind
01:58 Re: [HACKERS] Efficient DELETE Strategies Bruce Momjian
02:22 Re: [HACKERS] Efficient DELETE Strategies Christopher Kings-Lynne
05:43 Re: [GENERAL] VIEWs and FOREIGN keys Achilleus Mantzios
08:18 Re: Efficient DELETE Strategies Christoph Haller
13:29 Re: Efficient DELETE Strategies Tom Lane
14:22 Unicode and escaping single quotes Olaf Frączyk
15:48 Re: [HACKERS] Efficient DELETE Strategies Hannu Krosing
15:49 Re: [GENERAL] VIEWs and FOREIGN keys terry@greatgulfhomes.com
15:49 Re: [GENERAL] VIEWs and FOREIGN keys terry@greatgulfhomes.com
15:49 Re: [HACKERS] Efficient DELETE Strategies Dann Corbit
15:50 Re: [HACKERS] Efficient DELETE Strategies Hannu Krosing
15:53 inheritance problems Matt
22:04 temporary tables Marie G. Tuite
22:34 Re: temporary tables Bruce Momjian
22:48 make a unique index for foreign keys? Beth Gatewood
23:23 Re: make a unique index for foreign keys? Josh Berkus

12 June 2002

05:02 Re: Unicode and escaping single quotes Tatsuo Ishii
06:28 Re: Unicode and escaping single quotes Olaf Frączyk
06:45 General trigger function GRIMOIS Eric
10:57 Select * (but exclude columns) Adam
10:58 Domains Andy Pearce
10:58 Timestamp problem kumar
13:04 Re: Efficient DELETE Strategies Manfred Koizar
13:52 Re: Efficient DELETE Strategies Tom Lane
13:57 Re: Timestamp problem Stephan Szabo
15:19 How to remove contraint Vernon Wu
15:36 Re: Efficient DELETE Strategies Bruce Momjian
16:55 Re: Domains Bruce Momjian
17:16 Re: Efficient DELETE Strategies Manfred Koizar
19:44 Re: General trigger function Jan Wieck
22:34 Re: make a unique index for foreign keys? Josh Berkus
22:49 Re: make a unique index for foreign keys? Beth Gatewood
23:45 Case insensitive select isaac flemmin

13 June 2002

00:07 Re: Case insensitive select Josh Berkus
00:28 Re: Case insensitive select isaac flemmin
00:34 Re: Case insensitive select Stephan Szabo
00:53 Re: make a unique index for foreign keys? Christopher Kings-Lynne
01:07 Re: Case insensitive select isaac flemmin
03:38 Re: Case insensitive select Josh Berkus
04:29 Re: How to remove contraint Christopher Kings-Lynne
08:00 Re: General trigger function Richard Huxton
09:15 Rule problem Svenn Helge Grindhaug
10:04 How to unsubscribe? SDX
10:18 Another postgres 'file not found' error Ian Cass
12:20 Re: Another postgres 'file not found' error Achilleus Mantzios
13:18 join question - three tables, two with foreign keys to the first Dmitri Colebatch
13:35 Re: join question - three tables, two with foreign keys to the first Dmitri Colebatch
13:48 Re: Rule problem Tom Lane
14:21 Re: join question - three tables, two with foreign keys to the first Manfred Koizar
14:25 Re: join question - three tables, two with foreign keys to Stephan Szabo
15:07 how do i provide array parameters for my functions in php joseph@asti.dost.gov.ph
15:07 Re: Another postgres 'file not found' error Josh Berkus
15:18 Re: Another postgres 'file not found' error Ian Cass
15:31 Re: make a unique index for foreign keys? Beth Gatewood
15:32 Re: how do i provide array parameters for my functions in php Achilleus Mantzios
16:08 Re: make a unique index for foreign keys? Jan Wieck
17:02 Re: Another postgres 'file not found' error Josh Berkus
18:45 Isn't there a better way? Josh Berkus
19:12 serial column vs. explicit sequence question Charlie Toohey
19:51 Re: Another postgres 'file not found' error Tom Lane
20:10 Please help me out on this insert error Vernon Wu
20:29 Re: serial column vs. explicit sequence question Josh Berkus
20:30 Re: serial column vs. explicit sequence question Stephan Szabo
21:10 Re: serial column vs. explicit sequence question Tom Lane
21:35 Re: Another postgres 'file not found' error Oliver Elphick
21:44 Re: Please help me out on this insert error Joe Conway
21:45 Re: serial column vs. explicit sequence question Jason Earl
21:47 Re: serial column vs. explicit sequence question Charlie Toohey
21:53 Re: serial column vs. explicit sequence question Stephan Szabo
22:00 Re: serial column vs. explicit sequence question Charlie Toohey
22:02 Re: Please help me out on this insert error Stephan Szabo
22:02 Re: Please help me out on this insert error Stephan Szabo
22:12 Re: Please help me out on this insert error Manfred Koizar
22:17 Re: Please help me out on this insert error Vernon Wu
22:43 Re: join question - three tables, two with foreign keys to the first Dmitri Colebatch
23:06 Re: Please help me out on this insert error Vernon Wu
23:47 simple recursive function in plpgsql fails Andrew Hammond

14 June 2002

01:10 Re: join question - requesting for a simple C program where it can INSERT data into database as reference joo
01:30 Re: make a unique index for foreign keys? Christopher Kings-Lynne
04:15 Re: simple recursive function in plpgsql fails Tom Lane
07:11 Function not running after upgrade 7.03 to 7.2 juerg.rietmann@pup.ch
07:20 Re: Function not running after upgrade 7.03 to 7.2 Christopher Kings-Lynne
12:40 ON DELETE CASCADE question Wei Weng
15:06 Re: ON DELETE CASCADE question Josh Berkus
16:31 Re: ON DELETE CASCADE question Jan Wieck
17:44 function not running after upgrade from 7.03 to 7.2 juerg.rietmann@pup.ch
17:44 inheritance problems Matt
19:22 Re: function not running after upgrade from 7.03 to 7.2 Jan Wieck
20:28 Re: inheritance problems Stephan Szabo

17 June 2002

05:16 template1 - recreate Rudi Starcevic
10:46 join question - requesting for a simple C program where it can INSERT data into database as reference Christoph Haller
12:33 check Matt
14:52 Re: check Christopher Kings-Lynne
14:59 Re: check Stephan Szabo
16:39 Re: check Manfred Koizar
16:55 Re: Limiting database size Jeff Boes
18:04 Re: template1 - recreate Josh Berkus
19:36 Request for builtin function: Double_quote Josh Berkus
22:48 Users Andy Pearce

18 June 2002

06:52 Re: Request for builtin function: Double_quote Christoph Haller
11:01 Re: Limiting database size Ulrich Sprick
11:53 function text_ge(text, text), how to use on version 7.2 juerg.rietmann@pup.ch
12:38 Re: function text_ge(text, text), how to use on version 7.2 Achilleus Mantzios
14:33 Re: Request for builtin function: Double_quote Tom Lane
16:05 Re: Request for builtin function: Double_quote Josh Berkus
16:20 Re: Users Bruno Wolff III
21:33 text vs varchar Wei Weng
22:22 Re: text vs varchar Josh Berkus
22:36 date_part Rudi Starcevic
23:40 Re: text vs varchar Michelle Murrain
23:43 Re: text vs varchar Wei Weng

19 June 2002

00:09 Re: date_part Josh Berkus
00:33 Re: text vs varchar Josh Goldberg
06:30 Help with a "recursive" query alet@unice.fr (Jerome Alet)
06:44 Re: text vs varchar Achilleus Mantzios
07:05 Aggregates not allowed in WHERE clause? Joachim Trinkwitz
07:13 Re: Aggregates not allowed in WHERE clause? Christopher Kings-Lynne
07:16 Re: Aggregates not allowed in WHERE clause? Achilleus Mantzios
07:21 Re: Aggregates not allowed in WHERE clause? Christoph Haller
07:45 Re: Help with a "recursive" query Oleg Bartunov
09:14 Joining three data sources. Janning Vygen
10:27 Mirar y reenviar por favor!!! son 2 segundos Marta Beatriz Caldentey
12:30 SQL performance issue with PostgreSQL compared to MySQL Jeff Self
13:12 Re: Joining three data sources. Masaru Sugawara
13:57 Re: SQL performance issue with PostgreSQL compared to MySQL Tom Lane
14:42 Re: SQL performance issue with PostgreSQL compared to Josh Berkus
16:10 Tagging rows into collections? Steve Wampler
16:53 Re: SQL performance issue with PostgreSQL compared to MySQL Bruce Momjian
17:55 syntax for access an alias in the where clause ? Michael Agbaglo
19:07 Which one is faster? Wei Weng
19:22 Re: syntax for access an alias in the where clause ? Wei Weng
19:38 Re: Which one is faster? Bruce Momjian
19:50 Assign values to array afa
20:21 Re: syntax for access an alias in the where clause ? Michael Agbaglo
20:21 Re: Tagging rows into collections? Tom Lane
21:04 Re: syntax for access an alias in the where clause ? Tom Lane
21:08 Re: syntax for access an alias in the where clause ? Jeff Eckermann
21:19 Re: syntax for access an alias in the where clause ? Stephan Szabo
23:00 Re: syntax for access an alias in the where clause ? Ross J. Reedstrom

20 June 2002

03:00 Rows affected Rudi Starcevic
05:07 Re: Joining three data sources. Janning Vygen
06:17 Re: SQL performance issue with PostgreSQL compared to Achilleus Mantzios
06:26 Re: Rows affected Gaetano Mendola
07:06 Re: Aggregates not allowed in WHERE clause? Joachim Trinkwitz
07:39 psql -E Floating exception (coredump) Christoph Haller
11:23 Re: Which one is faster? Jan Wieck
12:32 Re: psql -E Floating exception (coredump) Tom Lane
12:32 slow DELETE queries Denis
12:54 Re: Tagging rows into collections? Steve Wampler
12:59 Re: Joining three data sources. Masaru Sugawara
14:06 Re: Assign values to array Arve Fahlvik
14:07 Re: slow DELETE queries Manfred Koizar
15:12 Re: Which one is faster? Bruce Momjian
17:38 Re: Tagging rows into collections? Richard Huxton
18:11 how to sort a birthday list ? Michael Agbaglo
21:45 Re: how to sort a birthday list ? David Stanaway

21 June 2002

00:04 Re: SQL performance issue with PostgreSQL compared to Josh Berkus
00:06 Re: how to sort a birthday list ? Josh Berkus
00:09 SQL Challenge: Skip Weekends Josh Berkus
04:33 Re: SQL Challenge: Skip Weekends Joe Conway
05:06 Re: skip weekends Rudi Starcevic
06:44 Re: skip weekends Cliff Wells
07:38 Re: how to sort a birthday list ? Michael Agbaglo
08:23 Re: how to sort a birthday list ? Michael Agbaglo
08:35 date_ge and time_ge juerg.rietmann@pup.ch
08:42 Re: date_ge and time_ge Achilleus Mantzios
11:36 Re: how to sort a birthday list ? Bruno Wolff III
12:22 Re: how to sort a birthday list ? Jan Wieck
13:31 Optimizer question with equivalent joins Dirk Lutzebaeck
14:33 Re: Optimizer question with equivalent joins Tom Lane
15:05 Re: [ADMIN] Incredible.. Cliff Wells
15:12 Re: [ADMIN] Incredible.. Larry Rosenman
15:29 rowtype and ecpg alla@sergey.com (Alla)
16:29 Re: Joining three data sources. Janning Vygen
17:04 is it easy to change the create sequence algorithm? Kevin Brannen
17:53 Re: SQL Challenge: Skip Weekends Jean-Luc Lachance
19:03 Presenting consistent data Ian Lynagh
19:57 FW: RESTORE A TABLE Jie Liang
20:01 Re: SQL Challenge: Skip Weekends Josh Berkus
20:21 Re: skip weekends Josh Berkus
20:36 Re: SQL Challenge: Skip Weekends Josh Berkus
20:55 Can somebody help me to optimize this huge query? Dirk Lutzebaeck
21:20 Re: is it easy to change the create sequence algorithm? Josh Berkus
22:01 Re: is it easy to change the create sequence algorithm? Andrew Hammond

22 June 2002

09:36 Obtaining primary key information from pg system tables Kris
09:43 Re: Obtaining primary key information from pg system tables Dmitri Colebatch
10:13 Re: Obtaining primary key information from pg system tables Kris
16:15 A problem on running a sql script in DBVisualizer Vernon Wu

23 June 2002

10:36 Select + min question Devrim GUNDUZ
11:19 Re: Select + min question Christopher Kings-Lynne
11:23 Re: Select + min question Mathieu Arnold

24 June 2002

11:51 variance aggregate function incorrect? Reference Materials reg create aggregate Joseph Syjuco
11:51 Re: Select + min question Devrim GUNDUZ
11:52 Re: rowtype and ecpg Christoph Haller
11:55 assign count() result to a declared variable in plpgsql Joseph Syjuco
12:22 Re: slow DELETE queries Denis
13:53 index problem Oleg Lebedev
15:59 Slow SELECT with distinct, in a TIMESTAMP type column Marcos Garcia
17:21 Re: variance aggregate function incorrect? Reference Materials reg create aggregate Tom Lane
17:38 Re: assign count() result to a declared variable in plpgsql Tom Lane
20:12 Re: variance aggregate function incorrect? Reference Materials Bruce Momjian
20:16 Re: assign count() result to a declared variable in plpgsql Jeff Eckermann
21:50 Re: Slow SELECT with distinct, in a TIMESTAMP type column Stephan Szabo
21:56 Re: Slow SELECT with distinct, in a TIMESTAMP type column Stephan Szabo
22:28 Re: Slow SELECT with distinct, in a TIMESTAMP type column Marcos Garcia
22:53 Re: Can somebody help me to optimize this huge query? Josh Berkus
22:58 Re: Request for builtin function: Double_quote Tom Lane

25 June 2002

03:11 Re: Request for builtin function: Double_quote Josh Berkus
05:47 altering column width
10:58 Re: rowtype and ecpg alla@sergey.com (Alla)
17:10 unique index on function and column Bruno Wolff III
18:20 Re: unique index on function and column Tom Lane
18:21 Re: unique index on function and column Bruno Wolff III
19:55 Re: unique index on function and column Josh Berkus
20:16 Re: unique index on function and column Bruno Wolff III
21:48 PostgreSQL Cookbook update Roberto Mello
23:55 what is the difference between default 0 vs default '0' Beth Gatewood

26 June 2002

05:51 Re: what is the difference between default 0 vs default '0' Christopher Kings-Lynne
09:18 Quickest way to insert unique records? Ian Cass
11:42 2 Selects 1 is faster, why? Eric
11:42 Performance Ideas Eric
11:42 Re: Limiting database size Eric
11:42 Re: what is the difference between default 0 vs default '0' Lee Harr
11:42 sequence chages after firing update Subhashini Karthikeyan
14:21 Re: Performance Ideas Tom Lane
14:47 Re: sequence chages after firing update Stephan Szabo
14:57 Efficient Query For Mapping IP Addresses To Country Code. Rajesh Kumar Mallah.
15:13 Re: sequence chages after firing update Rajesh Kumar Mallah.
16:11 Re: 2 Selects 1 is faster, why? Alvar Freude
18:02 Possibility of Index-Only access in PostgreSQL? Gunther Schadow
19:14 Re: Limiting database size Josh Berkus
22:29 Re: Limiting database size terry
22:41 Re: Possibility of Index-Only access in PostgreSQL? Tom Lane
23:35 Re: Limiting database size Thomas Swan
23:48 pg_restore cannot restore function Jie Liang

27 June 2002

02:58 Re: Possibility of Index-Only access in PostgreSQL? Christopher Kings-Lynne
10:44 graphical interface - admin q u a d r a
10:59 Calculating with sql Dennis Kaarsemaker
10:59 CHECK clause doesn't work with CASE clause Jörg Holetschek
13:32 Re: CHECK clause doesn't work with CASE clause Tom Lane
15:09 Re: 2 Selects 1 is faster, why? Masaru Sugawara
15:09 Re: CHECK clause doesn't work with CASE clause Richard Poole
15:15 Re: Possibility of Index-Only access in PostgreSQL? Gunther Schadow
15:43 Re: CHECK clause doesn't work with CASE clause Richard Huxton
16:26 Re: Slow SELECT -> Growing Database Marcos Garcia
17:03 Re: Calculating with sql Masaru Sugawara
17:13 Re: Slow SELECT -> Growing Database Stephan Szabo
18:18 Re: graphical interface - admin Ron Peterson
18:37 Re: Slow SELECT -> Growing Database Marc Spitzer
18:57 to_char() and order-by jboes@nexcerpt.com (Jeff Boes)
18:58 Unsubscription -- How? David Secret
22:43 Re: 2 Selects 1 is faster, why? Keith Gray

28 June 2002

00:47 Re: Slow SELECT -> Growing Database Tatsuo Ishii
02:53 time difference q u a d r a
02:57 Re: 2 Selects 1 is faster, why? Tom Lane
03:13 transaction in plpgsql Joseph Syjuco
05:09 Re: transaction in plpgsql Josh Berkus
05:32 Re: graphical interface - admin David BOURIAUD
05:54 Re: transaction in plpgsql Nils Höglund
07:00 Re: to_char() and order-by Karel Zak
10:09 creating functional index over multiple columns Chantal Ackermann
10:17 Re: creating functional index over multiple columns Chantal Ackermann
11:50 Re: to_char() and order-by Jeff Boes
11:58 Subtraction of Dates Valerie Goodman
11:58 Re: Calculating with sql Dennis Kaarsemaker
11:58 Function question David Hassell
13:15 Re: Function question Steve Brett
13:27 Re: Subtraction of Dates Steve Brett
13:48 Re: Calculating with sql Masaru Sugawara
15:05 Re: Function question Jie Liang
15:08 Re: graphical interface - admin Josh Berkus
15:12 Re: transaction in plpgsql Josh Berkus
15:17 Re: graphical interface - admin Robert Treat
16:39 pg_user and pg_group q u a d r a
16:41 Two-way query Vernon Wu
16:58 Re: graphical interface - admin terry
17:57 pg_restore cannot restore function Jie Liang
18:27 Re: graphical interface - admin Josh Berkus
19:12 Re: pg_restore cannot restore function Jan Wieck
19:15 something similar to "on delete cascade" ? Albrecht Berger
19:51 Re: pg_restore cannot restore function Jie Liang
19:51 Re: pg_restore cannot restore function Jie Liang
20:41 Re: something similar to "on delete cascade" ? Josh Berkus
21:25 pg_group members Kelly
22:27 Re: pg_group members Bruce Momjian

29 June 2002

03:23 Re: creating functional index over multiple columns Christopher Kings-Lynne
10:42 selecting from integer[] Kelly
13:32 Re: selecting from integer[] Christopher Kings-Lynne
20:11 Re: selecting from integer[] Stephan Szabo

30 June 2002

22:43 pl/pgsql capabilities? Ferenc Engard