pgsql-sql - October 2002

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Oct. 1, 2002

Thread Author Time
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

Oct. 2, 2002

Thread Author Time
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

Oct. 3, 2002

Thread Author Time
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

Oct. 4, 2002

Thread Author Time
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

Oct. 5, 2002

Thread Author Time
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

Oct. 6, 2002

Thread Author Time
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

Oct. 7, 2002

Thread Author Time
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

Oct. 8, 2002

Thread Author Time
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

Oct. 9, 2002

Thread Author Time
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

Oct. 10, 2002

Thread Author Time
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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31