Peripheral Links

• Home
• About
• Download
• Documentation
• Community
• Developers
• Support
• Your account

pgsql-sql - October 2002

2002-10-01

• Re: [SQL] arrays Achilleus Mantzios (07:49)
• How slow is distinct - 2nd Michael Contzen (12:18)
• alter user does not changes password Lucas Brasilino (14:46)
• Re: alter user does not changes password dima (14:49)
• Re: alter user does not changes password Tom Lane (14:52)
• Re: [GENERAL] arrays Roland Roberts (17:43)
• Re: [SQL] arrays Josh Berkus (17:52)
• Stored Procedures bcschnei (18:16)
• Re: Stored Procedures Roberto Mello (19:08)

2002-10-02

• please help with converting a view in oracle into postgresql readably code Matthew Geddert (03:46)
• please help with converting a view in oracle into postgresql readably code mgeddert (05:41)
• Re: please help with converting a view in oracle into postgresql readably code Roberto Mello (06:12)
• split function for pl/pgsql Frederic Logier (10:30)
• Re: PROBLEM SOLVED RE: please help with converting a view in oracle into postgresql readably code Roberto Mello (13:25)
• Re: split function for pl/pgsql Joe Conway (15:44)
• Re: Stored Procedures david williams (15:47)
• Re: Stored Procedures david williams (15:50)
• Re: Stored Procedures Joe Conway (16:34)
• indexing on char vs varchar Beth Gatewood (16:39)
• Re: split function for pl/pgsql Frederic Logier (16:54)
• Re: indexing on char vs varchar Bruce Momjian (17:06)
• Updating from select Thrasher (17:11)
• Re: indexing on char vs varchar Beth Gatewood (17:11)
• Re: Updating from select Manfred Koizar (17:45)
• Re: Stored Procedures bcschnei (17:53)
• Re: indexing on char vs varchar Josh Berkus (17:55)
• Re: indexing on char vs varchar Josh Berkus (17:56)
• Re: Stored Procedures david williams (17:57)
• Re: indexing on char vs varchar Beth Gatewood (18:01)
• Re: Stored Procedures Joe Conway (18:09)
• schedule of v7.3 Jie Liang (19:06)
• celko nested set functions Robert Treat (19:48)
• Re: schedule of v7.3 Bruce Momjian (21:24)
• Re: celko nested set functions Josh Berkus (22:11)

2002-10-03

• Re: split function for pl/pgsql Joe Conway (03:14)
• Re: Updating from select Thrasher (08:18)
• Large databases, performance Shridhar Daithankar (12:36)
• Re: Large databases, performance Charles H. Woloszynski (12:54)
• Re: Large databases, performance Nigel J. Andrews (12:56)
• Re: Large databases, performance Shridhar Daithankar (14:03)
• Can Postgres cache a table in memory? Kevin Traub (14:03)
• Re: Large databases, performance Charles H. Woloszynski (14:26)
• Formatting current_time output Thomas Good (14:46)
• Re: Formatting current_time output Josh Berkus (15:03)
• epoch to date Roberto Mello (15:09)
• Re: Formatting current_time output Thomas Good (15:10)
• Re: Formatting current_time output Charles H. Woloszynski (15:22)
• Re: Formatting current_time output Karel Zak (15:28)
• Re: Formatting current_time output Achilleus Mantzios (15:28)
• Re: epoch to date Achilleus Mantzios (15:42)
• Re: Large databases, performance Shridhar Daithankar (15:50)
• Re: Large databases, performance Shridhar Daithankar (15:56)
• Re: Large databases, performance Robert Treat (15:57)
• drop constraint primary key Marie G. Tuite (16:06)
• Re: Large databases, performance Shridhar Daithankar (16:07)
• Re: [HACKERS] Large databases, performance Justin Clift (16:16)
• Re: Large databases, performance Shridhar Daithankar (16:17)
• Re: [HACKERS] Large databases, performance Greg Copeland (16:23)
• Re: Large databases, performance Robert Treat (16:26)
• Re: [HACKERS] Large databases, performance Shridhar Daithankar (16:30)
• Re: Large databases, performance Shridhar Daithankar (16:35)
• Re: Large databases, performance Manfred Koizar (16:44)
• Re: [HACKERS] Large databases, performance Hans-Jürgen Schönig (16:51)
• Re: [HACKERS] Large databases, performance Manfred Koizar (16:53)
• Re: drop constraint primary key Tom Lane (17:09)
• Re: Large databases, performance Ron Johnson (17:38)
• Rule creation Edoardo Causarano (19:34)
• Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Bruce Momjian (20:18)
• Re: [HACKERS] Large databases, performance Ron Johnson (20:55)
• Re: [HACKERS] Large databases, performance Andrew Sullivan (21:09)
• use [PERF] instead of Jean-Luc Lachance (21:12)
• Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Andrew Sullivan (22:03)
• Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Bruce Momjian (22:15)
• Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Tom Lane (23:09)
• Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Andrew Sullivan (23:58)

2002-10-04

• Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Bruce Momjian (00:41)
• order by x DESC, y ASC indexing problem Vincent-Olivier Arsenault (02:07)
• Re: order by x DESC, y ASC indexing problem Josh Berkus (02:30)
• Re: order by x DESC, y ASC indexing problem Bruno Wolff III (03:09)
• Re: order by x DESC, y ASC indexing problem Bruno Wolff III (03:12)
• Re: order by x DESC, y ASC indexing problem Tom Lane (03:14)
• Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Oliver Elphick (05:03)
• Re: [SQL] [GENERAL] CURRENT_TIMESTAMP Tom Lane (05:20)
• Re: [HACKERS] Large databases, performance Shridhar Daithankar (08:00)
• Re: Can Postgres cache a table in memory? Achilleus Mantzios (13:14)
• Re: Can Postgres cache a table in memory? Richard Huxton (13:35)
• Re: rows in order Achilleus Mantzios (13:36)
• Re: rows in order Richard Huxton (13:37)
• Self Join? bens_nospam (14:05)
• Re: Can Postgres cache a table in memory? Tom Lane (14:14)
• Re: please help with converting a view in oracle into postgresql readably code Tom Lane (14:17)
• Re: Rule creation Tom Lane (14:24)
• Re: How slow is distinct - 2nd Tom Lane (14:44)
• Re: rows in order Oleg Bartunov (15:05)
• Re: How slow is distinct - 2nd Bruno Wolff III (15:31)
• Re: Can Postgres cache a table in memory? Josh Berkus (15:34)
• Re: rows in order Joe Conway (15:51)
• Re: [HACKERS] Large databases, performance scott.marlowe (16:05)
• Re: [SQL] arrays scott.marlowe (16:08)
• Re: [HACKERS] Large databases, performance Hans-Jürgen Schönig (16:30)
• Re: Large databases, performance Michael Paesold (16:38)
• Pinning a table into memory David Blood (16:46)
• Re: Pinning a table into memory Tom Lane (18:47)
• sum function Dagoberto Torres (21:01)

2002-10-05

• Primary Key Help ! Waheed Rahuman (05:19)
• enforcing with unique indexes.. Rajesh Kumar Mallah. (06:49)
• Re: enforcing with unique indexes.. Rajesh Kumar Mallah. (07:18)
• Re: enforcing with unique indexes.. dev (14:13)
• problem with subqueries pete (22:19)

2002-10-06

• Re: problem with subqueries Tom Lane (01:01)
• Re: problem with subqueries Stephan Szabo (01:02)
• Get A Tree from a table Scott Yaung (05:37)
• Re: problem with subqueries pete (11:13)
• timestamp Brian Ward (14:41)
• Re: timestamp Brian Ward (15:38)
• Need some SQL help Brian Ward (15:41)
• Suggestion: md5/crypt functions in sql Aasmund Midttun Godal (15:57)
• Re: problem with subqueries Stephan Szabo (16:18)
• Re: Suggestion: md5/crypt functions in sql Joe Conway (16:26)
• Re: Suggestion: md5/crypt functions in sql Dan Langille (22:51)

2002-10-07

• Re: foreign key problem Josh Berkus (00:11)
• Re: foreign key problem Josh Berkus (00:11)
• Re: Large databases, performance Curt Sampson (02:27)
• Re: Large databases, performance Curt Sampson (02:30)
• cross-posts (was Re: Large databases, performance) Tom Lane (03:20)
• Re: Large databases, performance Shridhar Daithankar (09:37)
• Re: [pgsql-performance] Large databases, performance Hans-Jürgen Schönig (10:01)
• Re: [HACKERS] cross-posts (was Re: Large databases, Larry Rosenman (11:50)
• Re: [HACKERS] cross-posts (was Re: Large databases, Michael Paesold (12:01)
• Re: [HACKERS] cross-posts (was Re: Large databases, Larry Rosenman (12:04)
• Re: How slow is distinct - 2nd Michael Contzen (12:21)
• Re: timestamp Larry Rosenman (12:25)
• Re: Need some SQL help Dan Langille (12:27)
• Re: timestamp Dan Langille (12:35)
• Re: timestamp Dan Langille (12:44)
• Re: Large databases, performance Manfred Koizar (14:10)
• Re: Large databases, performance Shridhar Daithankar (14:18)
• Re: [pgsql-performance] Large databases, performance Tom Lane (14:30)
• Re: [pgsql-performance] Large databases, performance Shridhar Daithankar (14:39)
• Re: [pgsql-performance] Large databases, performance Tom Lane (15:21)
• Re: Large databases, performance Manfred Koizar (15:22)
• Re: enforcing with unique indexes.. Jean-Luc Lachance (15:55)
• Re: Get A Tree from a table Josh Berkus (16:40)
• Re: Get A Tree from a table Joe Conway (16:54)
• Problems Formulating a SELECT Charles Hauser (19:24)
• Debug information Rafal Kedziorski (23:01)
• SQL Error Rafal Kedziorski (23:53)

2002-10-08

• foreign key problem Laurette Cisneros (00:03)
• Re: foreign key problem Stephan Szabo (00:21)
• Probs "compiling" a function gordoncl (02:14)
• Re: [pgsql-performance] Large databases, performance Shridhar Daithankar (05:44)
• Re: [pgsql-performance] Large databases, performance Martijn van Oosterhout (07:20)
• Temporary tables and indexes Ludwig Lim (07:28)
• Re: Probs "compiling" a function Richard Huxton (08:32)
• Re: Problems Formulating a SELECT Richard Huxton (08:38)
• Re: Pinning a table into memory Jan Wieck (13:32)
• foreign key, on delete cascade... Mathieu Arnold (13:47)
• Re: [GENERAL] Large databases, performance Ron Johnson (13:50)
• Re: [GENERAL] Large databases, performance Tom Lane (14:38)
• Re: [GENERAL] Large databases, performance Shridhar Daithankar (14:41)
• Re: foreign key, on delete cascade... Stephan Szabo (15:00)
• Re: Problems Formulating a SELECT Charles Hauser (15:04)
• Re: [GENERAL] Large databases, performance Ron Johnson (15:16)
• Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus (15:33)
• Re: Temporary tables and indexes Josh Berkus (15:36)
• Re: [NOVICE] update question Josh Berkus (15:39)
• Re: [GENERAL] Large databases, performance Tom Lane (15:51)
• Re: Temporary tables and indexes Ian Harding (16:13)
• Re: Problems Formulating a SELECT Richard Huxton (16:44)
• Re: CHAR, VARCHAR, TEXT (Was Large Databases) Ron Johnson (17:42)
• Re: Problems Formulating a SELECT Charles Hauser (18:19)
• Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus (22:44)
• Re: CHAR, VARCHAR, TEXT (Was Large Databases) Josh Berkus (23:36)

2002-10-09

• Table Rule Rudi Starcevic (00:20)
• Re: IN, EXISTS or ANY? Keith Gray (00:51)
• Re: IN, EXISTS or ANY? Josh Berkus (03:53)
• Re: Temporary tables and indexes Tom Lane (04:45)
• Re: Temporary tables and indexes Josh Berkus (04:49)
• Re: Large databases, performance Manfred Koizar (08:00)
• Re: Large databases, performance Shridhar Daithankar (08:07)
• Re: Large databases, performance Shridhar Daithankar (08:25)
• Re: Problems Formulating a SELECT Richard Huxton (08:47)
• PLPGSQL errors Rudi Starcevic (10:06)
• Re: PLPGSQL errors Richard Huxton (10:20)
• Complex SQL query and performance strategy Adam Witney (10:32)
• Re: [pgsql-performance] Large databases, performance Tom Lane (13:32)
• Re: [pgsql-performance] Large databases, performance Shridhar Daithankar (13:41)
• Re: Complex SQL query and performance strategy Tom Lane (13:47)
• problem with the Index Jose Antonio Leo (16:56)
• SELECT statement never completes. John Pauley (17:10)
• Re: SELECT statement never completes. Stephan Szabo (17:26)
• Re: [SQL] problem with the Index Stephan Szabo (17:31)
• Re: [pgsql-performance] Large databases, performance Manfred Koizar (18:09)
• Re: foreign key problem Laurette Cisneros (23:16)

2002-10-10

• Viewing stored procedure code Ludwig Lim (07:27)
• Re: Viewing stored procedure code Achilleus Mantzios (09:01)
• Re: SQL Error Christoph Haller (09:11)
• Re: SQL Error Achilleus Mantzios (11:23)
• SELECT with INNER data bases 2000 Informática (12:37)
• Re: SELECT with INNER data bases Bruno Wolff III (12:41)