pgsql-sql since 2002-08-29 00:00

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

Aug. 29, 2002

Thread Author Time
trigger viewing Kemin Zhou 00:15
Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian 01:14
Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Larry Rosenman 02:16
Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Rod Taylor 02:18
Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Robert Treat 02:29
union optimization in views JOE 04:47
Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian 05:03
Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Tom Lane 05:34
Re: SELECT ... WHERE ... NOT IN (SELECT ...); Yon Den Baguse Ngarso 06:14
Re: signed/unsigned integers Bruno Wolff III 13:41
Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian 15:16
Why must the function that a trigger calls return "opaque" ??? Greg Patnude 15:35
the optimizer and exists Thomas F. O'Connell 16:13
Re: union optimization in views Josh Berkus 17:52
Re: [SQL] Why must the function that a trigger calls return "opaque" ??? Josh Berkus 18:05
record count Marie G. Tuite 18:37
Re: How to Select with more than one AND in a Where SQL Clause? Josh Berkus 18:59
Re: record count Bruno Wolff III 19:06
How to Select with more than one AND in a Where SQL Clause? Zenith Vivas 19:20
Re: query problem Josh Berkus 20:45

Aug. 30, 2002

Thread Author Time
Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian 03:18
Re: record count Bhuvan A 05:31
RFC822 Checker Matthew Price 14:07
Re: RFC822 Checker Bruno Wolff III 14:26
query problem Marco Muratori 16:38
Large number of lookups Jeff Boes 19:40
Re: query problem Jean-Luc Lachance 20:00
Re: query problem Jean-Luc Lachance 20:02

Sept. 2, 2002

Thread Author Time
Re: [SQL] Retrieving the new "nextval" for primary keys.... GB Clark 19:50
Re: Retrieving the new nextval... GB Clark 19:57

Sept. 3, 2002

Thread Author Time
Re: union optimization in views Stephan Szabo 04:06
Re: UPDATE & LIMIT together? tp 08:37
Re: RFC822 Checker Hubert depesz Lubaczewski 08:41
convert sum (interval) to seconds Doppelganger 10:45
Re: convert sum (interval) to seconds Oliver Elphick 11:11
tree structures in sql - my point of view (with request of comment from joe celko) Hubert depesz Lubaczewski 13:22
Re: convert sum (interval) to seconds Tom Lane 13:37
Re: Why must the function that a trigger calls return Darren Ferguson 14:56
Update help [email protected] 16:19
Update Help [email protected] 16:38
Re: Update Help Oliver Elphick 18:01
Outer Join with For Update alexandre :: aldeia digital 18:05
Re: tree structures in sql - my point of view (with request of comment from joe celko) Josh Berkus 18:17
Re: UPDATE & LIMIT together? Bruce Momjian 18:39
Re: tree structures in sql - my point of view (with request Oleg Bartunov 18:42
Re: Update Help Peter Eisentraut 18:55
Re: Outer Join with For Update Tom Lane 21:31
Re: tree structures in sql - my point of view (with request mallah 21:59
Re: tree structures in sql - my point of view (with request Bruce Momjian 22:07

Sept. 4, 2002

Thread Author Time
Re: tree structures in sql - my point of view (with request of comment from joe celko) knut.suebert 17:46

Sept. 5, 2002

Thread Author Time
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian 05:27
fumbling for join syntax Daniel Kelley 14:29
Re: fumbling for join syntax Josh Berkus 15:55
new calculated column andres javier garcia garcia 16:53
new calculated column andres javier garcia garcia 16:58
Re: Update help Ligia Pimentel 17:29
Re: new calculated column mallah 18:49
Character translation? Linn Kubler 22:15

Sept. 6, 2002

Thread Author Time
Hardware performance for large updates Josh Berkus 00:41
Re: Hardware performance for large updates Joe Conway 04:33
Slow Multi-joins performance 10:59
Re: Hardware performance for large updates Josh Berkus 16:10

Sept. 7, 2002

Thread Author Time
Re: Hardware performance for large updates Joe Conway 03:57

Sept. 9, 2002

Thread Author Time
Efficiency Question Colin Fox 00:13
the best way to get the topest 3 record in every group jack 00:21
Re: the best way to get the topest 3 record in every group dima 06:34
Cross tables Like% Jason Davis 07:20
Re: Character translation? Troy 07:47
Re: the best way to get the topest 3 record in every group jack 08:08
Database joins Jay 08:58
Re: the best way to get the topest 3 record in every group 📎 Viacheslav N Tararin 09:35
Re: the best way to get the topest 3 record in every group 📎 Viacheslav N Tararin 11:48
Re: the best way to get the topest 3 record in every group Viacheslav N Tararin 12:23
Re: Efficiency Question Bruno Wolff III 13:57
Re: new calculated column Viacheslav N Tararin 14:01
Re: Cross tables Like% Viacheslav N Tararin 14:05
Re: Character translation? Richard Huxton 14:50
Re: Slow Multi-joins performance [DEVELOPERS attn please] Richard Huxton 15:24
Re: Character translation? Stephan Szabo 15:37
Re: Database joins Stephan Szabo 15:44
Re: the best way to get the topest 3 record in every group Masaru Sugawara 16:23
Re: Slow Multi-joins performance [DEVELOPERS attn please] Ross J. Reedstrom 16:37
Changing Column Type Peter Atkins 16:49
Displaying current queries on the database? Sloan Bowman 17:34
Re: Displaying current queries on the database? mallah 17:52
stored procedures: sybase -> postgreSQL ? Charles Hauser 18:15
Re: Slow Multi-joins performance [DEVELOPERS attn please] Tom Lane 20:26
Re: stored procedures: sybase -> postgreSQL ? Reinoud van Leeuwen 21:02
How the R-Tree index works?. Andres Sommerhoff 21:51

Sept. 10, 2002

Thread Author Time
Transaction Newbie Michelle Murrain 02:37
Re: Transaction Newbie Christopher Kings-Lynne 02:52
Re: How the R-Tree index works?. Markus Gieppner 03:34
pgsql-performance mailing list / newsgroup created Marc G. Fournier 03:44
Help Bc. Šimko Juraj 08:29
POSIX-style regular expressions Goran Buzic 09:32
Re: POSIX-style regular expressions Josh Jore 13:35
Re: POSIX-style regular expressions Goran Buzic 13:51
Re: stored procedures: sybase -> postgreSQL ? Ross J. Reedstrom 14:49
Re: POSIX-style regular expressions Stephan Szabo 15:04
Re: POSIX-style regular expressions Ross J. Reedstrom 15:13
Re: POSIX-style regular expressions Tom Lane 15:15
Rules and Triggers Michael Paesold 18:52
Re: Rules and Triggers Adam Erickson 19:24
Re: Rules and Triggers Michael Paesold 19:45
Re: Changing Column Type Kevin Brannen 19:51
Year and month comparison Del Mistro, Enzo 20:16
Do the datatypes have set id/oid that are constant? Mark Worsdall 21:50
Re: Transaction Newbie Lee Harr 23:27
Re: Rules and Triggers Ross J. Reedstrom 23:28

Sept. 11, 2002

Thread Author Time
R-Tree, GiST or B-Tree? I will need it? Andres Sommerhoff 03:43
Re: Rules and Triggers Michael Paesold 07:28
Re: POSIX-style regular expressions Goran Buzic 12:21
writing a function to mimic mysql last_insert_id Beth Gatewood 17:23
Re: writing a function to mimic mysql last_insert_id Josh Berkus 17:30
Re: writing a function to mimic mysql last_insert_id Ross J. Reedstrom 17:32
Re: writing a function to mimic mysql last_insert_id Beth Gatewood 17:43
Re: writing a function to mimic mysql last_insert_id Josh Berkus 17:53
reset sequence Ricardo Javier Aranibar León 20:02

Sept. 12, 2002

Thread Author Time
Re: writing a function to mimic mysql last_insert_id Christopher Kings-Lynne 02:05
Re: writing a function to mimic mysql last_insert_id Chris 02:21
Re: writing a function to mimic mysql last_insert_id Beth Gatewood 02:37
Re: writing a function to mimic mysql last_insert_id Joe Conway 03:07
htdig & postgresql Rudi Starcevic 05:41
how to cast this ? juerg.rietmann 09:22
Re: how to cast this ? Oliver Elphick 09:45
still sorting and casting problems juerg.rietmann 10:01
Re: reset sequence Ludwig Lim 10:12
Re: reset sequence Michael Paesold 10:28
Re: Rules and Triggers: another question Michael Paesold 12:52
Select the max on a field Gaetano Mendola 13:09
Re: Select the max on a field Gaetano Mendola 13:15
Re: still sorting and casting problems Stephan Szabo 13:54
Re: still sorting and casting problems Jeff Eckermann 13:57
Re: Select the max on a field Stephan Szabo 14:02
Re: Select the max on a field Jeff Eckermann 14:03
Performance inside and outside view ( WAS Re: Select the max on a field ) Gaetano Mendola 14:31
Re: Performance inside and outside view ( WAS Re: Select the max on a field ) Tom Lane 14:50
Re: Performance inside and outside view ( WAS Re: Select the Stephan Szabo 15:22
Re: Performance inside and outside view ( WAS Re: Select the max on a field ) Gaetano Mendola 15:53
Table alias in DELETE statements Hanno Wiegard 15:57
Re: Performance inside and outside view ( WAS Re: Select the Stephan Szabo 16:05
Latitude / Longitude Tim Perdue 17:44
Re: [SQL] Latitude / Longitude Larry Rosenman 17:49
Returning a reference to a cursor from a function david williams 18:12
Re: Performance inside and outside view ( WAS Re: Select the Tom Lane 18:57
LIMIT within UNION? Andrew Perrin 19:11
Re: [SQL] Latitude / Longitude Jeff Hoffmann 19:19
Re: LIMIT within UNION? Tom Lane 19:34
Re: LIMIT within UNION? Roland Roberts 19:35
Re: LIMIT within UNION? Andrew Perrin 19:40
Re: LIMIT within UNION? Andrew Perrin 19:41
Re: [SQL] Latitude / Longitude Bruno Wolff III 19:46
Re: [SQL] Latitude / Longitude Tim Perdue 19:49
Re: LIMIT within UNION? Stephan Szabo 19:52
Re: LIMIT within UNION? Andrew Perrin 20:03
Re: LIMIT within UNION? Tom Lane 20:18
Re: LIMIT within UNION? Josh Berkus 20:20
Re: Latitude / Longitude Joe Conway 20:54
Re: [SQL] Latitude / Longitude James Orr 22:10

Sept. 13, 2002

Thread Author Time
Re: DISTINCT Christopher Kings-Lynne 02:30
DISTINCT Rudi Starcevic 02:31
Re: DISTINCT Rudi Starcevic 02:44
Re: DISTINCT ON Christopher Kings-Lynne 02:48
DISTINCT ON Rudi Starcevic 02:49
How can unique columns being case-insensitive be accomplished? Jrg 09:07
sql group by statement Albrecht Berger 10:29
Re: sql group by statement dima 10:33
Re: sql group by statement Albrecht Berger 10:39
Assignments in PL/pgSQL Michael Paesold 10:43
Table alias in DELETE statements Hanno Wiegard 12:10
Re: sql group by statement Manfred Koizar 12:16
Re: Table alias in DELETE statements Manfred Koizar 12:46
Re: DISTINCT ON Chad Thompson 14:35
Timestamp Fractions Problem Florian Mader 14:38
Timestamp Fractions Problem Florian Mader 14:49
Re: [SQL] Latitude / Longitude Jan Wieck 15:19
Re: sql group by statement Jean-Luc Lachance 15:39
Re: LIMIT within UNION? Andrew Perrin 15:45
Re: Assignments in PL/pgSQL Josh Berkus 17:51
Re: Assignments in PL/pgSQL Jan Wieck 18:04
Re: Assignments in PL/pgSQL Joe Conway 18:04
Re: Assignments in PL/pgSQL Josh Berkus 18:10
Want to test beta, but ... Josh Berkus 18:31
Re: Want to test beta, but ... Joe Conway 18:59
Re: Want to test beta, but ... Josh Berkus 19:04
How to select and result row number?? Yudie 19:17
does table names have a format and size jaya prakash 23:04
"Inverting" a table, OLAP-style pacquet 23:18

Sept. 14, 2002

Thread Author Time
Re: Timestamp Fractions Problem Tom Lane 03:35
Re: Table alias in DELETE statements Christopher Kings-Lynne 06:07
Re: sql group by statement Tom Lane 15:03
cross tab (pivtor table) sql shahbaz 22:53

Sept. 15, 2002

Thread Author Time
Re: Timestamp Fractions Problem Florian Mader 09:00
Re: Timestamp Fractions Problem Tom Lane 14:51
Re: Slow Multi-joins performance [DEVELOPERS attn please] 21:34

Sept. 16, 2002

Thread Author Time
Re: Table alias in DELETE statements Bruce Momjian 04:03
Rules and Triggers: another question Jerome Chochon 06:57
Re: Timestamp Fractions Problem Florian Mader 08:29
Re: Want to test beta, but ... Richard Huxton 08:31
Re: Want to test beta, but ... Christopher Kings-Lynne 08:53

Browse Archives

Prev | Next