pgsql-sql since 2001-12-11 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

Dec. 11, 2001

Thread Author Time
Indices sharmad 03:48
Re: Indices Stephan Szabo 18:46
How would i do this? John Hughes 19:21
Re: How would i do this? Andrew Snow 20:09
Re: How would i do this? David A Dickson 20:16
Re: How would i do this? Vince Vielhaber 20:26
Re: How would i do this? Shaun Thomas 21:47
how does one replace a row in Postgresql? (ala MySQL REPLACE) Terrence Brannon 22:09

Dec. 12, 2001

Thread Author Time
Re: how does one replace a row in Postgresql? (ala MySQL REPLACE) Philip Hallstrom 00:39
Re: Poolman/mySQL transaction exception on connect Andrew G. Hammond 04:43
Re: How would i do this? Arian Prins 07:23
Re: Variable Length Binary String (not large) Haller Christoph 11:53
Re: how does one replace a row in Postgresql? (ala MySQL REPLACE) 12:45
Re: Variable Length Binary String (not large) Jason Earl 17:40

Dec. 13, 2001

Thread Author Time
cidr question Mir S Islam 01:38
cidr question (resent) Mir S Islam 02:32
Re: cidr question (resent) Alex Pilosov 03:37
Re: cidr question (resent) David Stanaway 03:39
Varying bit field: to set and query a particular bit S P Arif Sahari Wibowo 15:45
performance tuning in large function / transaction MindTerm 16:27
Re: performance tuning in large function / transaction Jason Earl 18:56
Re: performance tuning in large function / transaction Stephan Szabo 19:17

Dec. 14, 2001

Thread Author Time
Re: performance tuning in large function / transaction Christopher Kings-Lynne 02:09
Re: performance tuning in large function / transaction MindTerm 02:46
Re: performance tuning in large function / transaction Stephan Szabo 03:02
Re: performance tuning in large function / transaction MindTerm 03:34
Re: performance tuning in large function / transaction Christopher Kings-Lynne 03:43
Re: performance tuning in large function / transaction Stephan Szabo 06:40
Re: performance tuning in large function / transaction Stephan Szabo 06:42
Re: performance tuning in large function / transaction Stephan Szabo 06:47
weird duplicate data problem Carolyn Lu Wong 07:29
Re: performance tuning in large function / transaction MindTerm 08:05
Re: performance tuning in large function / transaction Stephan Szabo 08:40
Display of Japanese character Anil Kumar Narule 08:42
Re: performance tuning in large function / transaction 📎 MindTerm 09:06
Re: performance tuning in large function / transaction Stephan Szabo 14:44
Re: cidr question D'Arcy J.M. Cain 15:03
Re: [NOVICE] Storing number '001' ? Josh Berkus 16:03
Re: weird duplicate data problem Jeff Self 18:42
Re: weird duplicate data problem Josh Berkus 19:22
Re: weird duplicate data problem Jan Wieck 20:54

Dec. 15, 2001

Thread Author Time
won't drop the view Oleg Lebedev 02:28
queries per second Timur V. Irmatov 05:23
Re: queries per second Horst Herb 06:11
Re: won't drop the view Josh Berkus 22:19
Re: won't drop the view Chris Ruprecht 23:20
Re: queries per second Chris Ruprecht 23:34

Dec. 16, 2001

Thread Author Time
should this be a trigger or a rule? Marc Spitzer 00:16
Re: should this be a trigger or a rule? Tom Lane 02:04
Re: should this be a trigger or a rule? Marc Spitzer 02:25
Numbering Rows (SEQUENCE, OID) questions Terrence Brannon 11:56
What happens if you delete a row containing a BLOB? Terrence Brannon 19:39
Re: Numbering Rows (SEQUENCE, OID) questions Stephan Szabo 19:42
temp tables versus the global sql area Terrence Brannon 23:54

Dec. 17, 2001

Thread Author Time
why doesn't \d table_name show the table inheritance graph? Terrence Brannon 00:00
Re: why doesn't \d table_name show the table inheritance graph? Tom Lane 01:33
Re: What happens if you delete a row containing a BLOB? Stephan Szabo 01:41
Re: persistent connections, AOLserver (Was: maybe Offtopic : Marc Spitzer 02:01
Re: What happens if you delete a row containing a BLOB? Christopher Kings-Lynne 02:44
Re: performance tuning in large function / transaction MindTerm 02:58
Re: persistent connections, AOLserver (Was: maybe Offtopic : Stephan Szabo 03:40
Re: performance tuning in large function / transaction Stephan Szabo 03:41
Re: performance tuning in large function / transaction Christopher Kings-Lynne 04:06
Re: temp tables versus the global sql area Bruce Momjian 05:37
Re: performance tuning in large function / transaction Bruce Momjian 05:39
Re: performance tuning in large function / transaction Tom Lane 06:21
'IN' performance Christopher Kings-Lynne 06:33
Re: 'IN' performance Tom Lane 06:44
Re: Numbering Rows (SEQUENCE, OID) questions Terrence Brannon 10:41
how could a foreign key ever be NULL? Terrence Brannon 11:38
Difference between DB2 7.0 & latest version of PostgresSQL? Tarun Galarani 11:41
Re: Difference between DB2 7.0 & latest version of PostgresSQL? Tarun Galarani 12:42
Re: weird duplicate data problem Henshall, Stuart - WCP 15:20
Re: Numbering Rows (SEQUENCE, OID) questions Bruce Momjian 17:04
Re: how could a foreign key ever be NULL? Bruce Momjian 17:06
Re: how could a foreign key ever be NULL? Oliver Elphick 17:24
Re: how could a foreign key ever be NULL? Stephan Szabo 20:15
Re: won't drop the view Oleg Lebedev 20:56

Dec. 18, 2001

Thread Author Time
Re: won't drop the view Josh Berkus 01:08
Re: won't drop the view Tom Lane 01:21
Operation on bit strings with different length S P Arif Sahari Wibowo 05:33
Execution time problem Iklódi Lajos 06:03
Re: Execution time problem Stephan Szabo 06:57
Re: performance tuning in large function / transaction MindTerm 07:39
Re: performance tuning in large function / transaction Stephan Szabo 07:50
Re: performance tuning in large function / transaction MindTerm 09:34
Constructing a backup routine Johnny Jørgensen 11:50
Performance problem, what to do? 📎 Archibald Zimonyi 12:34
Re: Performance problem, what to do? Markus Bertheau 12:58
Re: Performance problem, what to do? 📎 Archibald Zimonyi 13:32
Re: Constructing a backup routine GB Clark II 14:39
Re: Performance problem, what to do? Tom Lane 15:36
Re: Performance problem, what to do? 📎 Archibald Zimonyi 15:50
Re: Operation on bit strings with different length Josh Berkus 16:37
HELP PLEASE: Error executing the example esql.xml on cocoon1.8.2 Ivan Manuel Andrade Muñoz 20:07
Re: Execution time problem Iklódi Lajos 20:36
Re: Operation on bit strings with different length Peter Eisentraut 22:23

Dec. 19, 2001

Thread Author Time
Maximum Execution Timeout Error!! Gurudutt 09:28
Re: Maximum Execution Timeout Error!! Martín Marqués 11:45
Re: [SQL] Maximum Execution Timeout Error!! Radu-Adrian Popescu 12:23
Stupid question on INDEXES Giorgio Ponza 13:03
Re: Stupid question on INDEXES Tom Lane 15:11
return a text agreggate from a subselect Louis-David Mitterrand 16:11
queryoptimizer force index use 📎 David M. Richter 19:11
Re: return a text agreggate from a subselect Andrew G. Hammond 19:28

Dec. 20, 2001

Thread Author Time
controlling process priority Peter T. Brown 02:58
Re: Constructing a backup routine Kovacs Zoltan 08:44
Connections? Archibald Zimonyi 08:56
Re: Connections? Jan Wieck 13:03
Re: controlling process priority Robert B. Easter 13:24
Transaction and cascade problem Glenn MacGregor 13:32
Transaction and cascade problem Glenn MacGregor 13:47
Re: subselects Carl van Tast 13:50
Re: controlling process priority Tom Lane 15:09
Re: Transaction and cascade problem Josh Berkus 16:08
Re: Transaction and cascade problem Tom Lane 17:09
Re: controlling process priority Peter T. Brown 17:27
should temporary tables show up in \dt as type "temporary" or as something? Terrence Brannon 19:49

Dec. 21, 2001

Thread Author Time
Re: subselects Christopher Kings-Lynne 02:45
Re: Transaction and cascade problem Christopher Kings-Lynne 02:57
NULL values or not? Archibald Zimonyi 09:53
getting the name of currenlty connected host.. mallah 10:42
Re: NULL values or not? Jan Wieck 12:29
Re: NULL values or not? D'Arcy J.M. Cain 12:37
Re: NULL values or not? Aasmund Midttun Godal 12:41
Re: should temporary tables show up in \dt as type "temporary" or as something? Greg Sabino Mullane 13:09
Re: Transaction and cascade problem Henshall, Stuart - WCP 14:12
Re: NULL values or not? Archibald Zimonyi 15:08
Re: NULL values or not? Aasmund Midttun Godal 15:24
Re: NULL values or not? Archibald Zimonyi 15:48
Re: NULL values or not? Josh Berkus 16:55
Re: NULL values or not? Archibald Zimonyi 17:22
Re: NULL values or not? Josh Berkus 21:09
Re: NULL values or not? Wei Weng 21:37

Dec. 22, 2001

Thread Author Time
Re: NULL values or not? Andrew G. Hammond 06:32
Re: NULL values or not? Archibald Zimonyi 09:30
JOIN question Frank Morton 19:26
Re: JOIN question Ian Barwick 22:57
Re: JOIN question Peter Eisentraut 23:27

Dec. 23, 2001

Thread Author Time
Re: [SQL] HELP PLEASE: Error executing the example esql.xml on Andrew G. Hammond 16:03
Re: PostgreSQL SELECT error Juan Riera 16:23

Dec. 26, 2001

Thread Author Time
Re: won't drop the view 📎 Oleg Lebedev 02:49
Re: won't drop the view Tom Lane 16:54
Re: won't drop the view Oleg Lebedev 19:40
Re: won't drop the view Tom Lane 22:25

Dec. 27, 2001

Thread Author Time
Re: won't drop the view 📎 Oleg Lebedev 01:48
Re: won't drop the view Tom Lane 04:54
Multiple counts Richard Rowell 05:36
left join and where andrea 20:28
Working with array value columns in PL/pgSQL triggers/functions Roland Roberts 21:14

Dec. 28, 2001

Thread Author Time
Conditional test Rick Dayao 02:54
pltcl function -> plpgsql guard 04:42
Re: [SQL] An easy question about creating a primary key Bruce Momjian 05:11
Re: [SQL] An easy question about creating a primary key Tom Lane 05:20
How to union tables and have a field with UNIQUE constraint? Katona Gabor 13:36
query by tableoid, oid Chester Carlton Young 17:49
Begin/Commit Linh Luong 22:27
Re: Begin/Commit Stephan Szabo 23:41
Retrieving information from System Tables Dempsey Bullock 23:54

Dec. 29, 2001

Thread Author Time
Re: Begin/Commit Tom Lane 00:26
Re: Multiple counts Andrew G. Hammond 01:15
Re: Begin/Commit Marc Spitzer 01:47
Re: Begin/Commit Tom Lane 03:54
Re: Begin/Commit Marc Spitzer 04:05
Re: Begin/Commit Tom Lane 04:34
difficult query (for me) QdlatY 15:20
query QdlatY 15:46
Re: difficult query (for me) Andrew G. Hammond 16:05
Tree structure index usage Aasmund Midttun Godal 20:06

Dec. 30, 2001

Thread Author Time
RIGHT JOIN Table Ordering Question Tara Piorkowski 18:55
Re: RIGHT JOIN Table Ordering Question Tom Lane 22:15

Dec. 31, 2001

Thread Author Time
Unpredictable text -> date implicit casting behaviour/to_date bug Aasmund Midttun Godal 14:38
Re: Unpredictable text -> date implicit casting behaviour/to_date bug Tom Lane 16:02

Jan. 1, 2002

Thread Author Time
Need help 📎 Shamik Majumder 11:51
Re: PostgreSQL SELECT error Calvin Dodge 23:50

Jan. 2, 2002

Thread Author Time
Re: [SQL] An easy question about creating a primary key Christopher Kings-Lynne 03:36
Re: [SQL] Unpredictable text -> date implicit casting behaviour/to_date bug 📎 Karel Zak 13:04
OUTER JOIN doesn't work on pgSQL 7.1.2 Alex Glikson 13:31
Re: [SQL] Unpredictable text -> date implicit casting behaviour/to_date Bruce Momjian 18:26
Re: Tree structure index usage Josh Berkus 19:38
Getting Hour From a Time in Different Time Zone Tom Kreiner 21:45
Re: [SQL] Unpredictable text -> date implicit casting behaviour/to_date bug Tom Lane 22:10

Jan. 3, 2002

Thread Author Time
to_char adds leading space, intended? Aasmund Midttun Godal 04:31
change null to 0 in SQL script Karl Raven 05:00
Re: to_char adds leading space, intended? rolf.ostvik 07:39
Re: change null to 0 in SQL script Markus Bertheau 14:59
Re: OUTER JOIN doesn't work on pgSQL 7.1.2 Tom Lane 15:11
Re: Getting Hour From a Time in Different Time Zone Tom Lane 15:43
Re: change null to 0 in SQL script Tibor Laszlo 15:45
Re: change null to 0 in SQL script Jason Earl 16:20
Re: Conditional test Bruce Momjian 17:04
Re: Retrieving information from System Tables Bruce Momjian 17:06
Re: How to union tables and have a field with UNIQUE constraint? Stephan Szabo 18:02
Re: How to union tables and have a field with UNIQUE constraint? Tom Lane 20:51
Re: pltcl function -> plpgsql Jan Wieck 21:01
Re: How to union tables and have a field with UNIQUE constraint? Stephan Szabo 21:44
Re: How to union tables and have a field with UNIQUE constraint? Tom Lane 23:26
top? Richard Rowell 23:27
Re: top? Stephan Szabo 23:48

Jan. 4, 2002

Thread Author Time
Re: top? Christopher Kings-Lynne 01:59

Browse Archives

Prev | Next