pgsql-sql - December 2001

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

Dec. 1, 2001

Thread Author Time
Re: contracting tables Tom Lane 05:21
Error in executing plpgsql function ananth 06:23
update returns 1, but no changes have been made James Thornton 09:44

Dec. 2, 2001

Thread Author Time
Unexpected Return from Function Anthony Bouvier 02:00
Re: Unexpected Return from Function Stephan Szabo 02:23
Re: problems with single quotes.. Horst Herb 07:44
Re: problems with single quotes.. Stephan Szabo 07:48
Re: problems with single quotes.. Joe Conway 14:52
Re: problems with single quotes.. Tom Lane 15:00
Re: Unexpected Return from Function Anthony Bouvier 20:43
Re: problems with single quotes.. postgresql 21:48
Re: contracting tables Roberto Mello 22:20
Re: problems with single quotes.. Stephan Szabo 22:21
Re: problems with single quotes.. Roberto Mello 22:25

Dec. 3, 2001

Thread Author Time
Re: problems with single quotes.. postgresql 03:20
ODBC queries die; "Unexpected protocol character from backend" Steve Frampton 05:03
Re: problems with single quotes.. Stephan Szabo 05:23
Inline IF condition Tapan Trivedi 12:04
update with RE Vigny Christophe 13:37
Re: persistent connections, AOLserver (Was: maybe Offtopic : Stephan Szabo 19:07
Re: Need help with a college SQL exam question... Josh Berkus 19:13
Re: An easy question about creating a primary key Stephan Szabo 19:16
Re: An easy question about creating a primary key Josh Berkus 19:20
Re: Error in executing plpgsql function Tom Lane 19:23

Dec. 4, 2001

Thread Author Time
Re: An easy question about creating a primary key Christopher Kings-Lynne 01:36
Re: An easy question about creating a primary key Tom Lane 02:12
Re: [SQL] An easy question about creating a primary key Christopher Kings-Lynne 02:23
Re: [SQL] An easy question about creating a primary key Tom Lane 02:29
Re: [SQL] An easy question about creating a primary key Tom Lane 02:40
Re: [SQL] An easy question about creating a primary key Christopher Kings-Lynne 02:50
Re: [SQL] An easy question about creating a primary key Tom Lane 02:54
Re: creating a primary key Keith Gray 05:16
Re: Error in executing plpgsql function ananth 05:23
Re: need some help understanding sloq query Arian Prins 08:31
Re: Need help with a college SQL exam question... Arian Prins 08:54
problems with this wiew Manuel Trujillo 11:10
Re: update returns 1, but no changes have been made James Thornton 11:57
Re: update returns 1, but no changes have been made James Thornton 13:29
Re: Need help with a college SQL exam question... Roland Roberts 14:47
Re: need some help understanding sloq query Josh Berkus 17:09
Re: problems with this wiew Stephan Szabo 18:07
make query faster?? DI Hasenöhrl 20:58
Re: make query faster?? Stephan Szabo 21:26
Memory exhausted in AllocSetAlloc(269039) Jeff Barrett 21:36
Re: problems with this wiew Aasmund Midttun Godal 22:31
Re: Memory exhausted in AllocSetAlloc(269039) Tom Lane 22:43

Dec. 5, 2001

Thread Author Time
plpgsql before insert update delete kiyo taka 05:47
Re: make query faster?? DI Hasenöhrl 08:52
Any patch for delete and insert same row in a function ( transaction ) MindTerm 10:37
Fw: Creating Postgres DB from Remote Machine Dinesh Parikh 12:07
how to chane the type tinar 13:12
Cursor Variables Alex 14:56
Re: problems with this wiew Masaru Sugawara 15:07
Re: problems with this wiew Masaru Sugawara 15:16
Re: Memory exhausted in AllocSetAlloc(269039) Roberto Mello 15:55
Re: Memory exhausted in AllocSetAlloc(269039) Tom Lane 16:48
Re: Any patch for delete and insert same row in a function ( Stephan Szabo 18:14
Re: Any patch for delete and insert same row in a function ( transaction Bruce Momjian 18:16
Re: Any patch for delete and insert same row in a function ( transaction Bruce Momjian 18:17
Re: make query faster?? Stephan Szabo 18:28
Getting matching and non-matching results (long) Roberto Mello 19:37
INT OR VARCHAR Martín Marqués 20:41
Re: INT OR VARCHAR Aasmund Midttun Godal 21:03
Re: Getting matching and non-matching results (long) Stephan Szabo 21:07
Re: INT OR VARCHAR Martín Marqués 21:19
Re: PL/pgSQL examples NOT involving functions Jan Wieck 21:26
Re: PL/pgSQL examples NOT involving functions Jan Wieck 21:29
Re: Getting matching and non-matching results (long) Roberto Mello 21:54
Re: Getting matching and non-matching results (long) Stephan Szabo 22:05

Dec. 6, 2001

Thread Author Time
Select into Christopher Kings-Lynne 03:01
Re: Select into Bruce Momjian 04:10
Re: Select into Stephan Szabo 04:18
Re: need some help understanding sloq query Esger Abbink 13:34
Re: Inline IF condition Roberto Mello 15:48
Re: need some help understanding sloq query Stephan Szabo 16:25
Re: how to chane the type Stephan Szabo 16:31
Re: update returns 1, but no changes have been made Gregory Wood 18:24
type casting bpchar Joachim Trinkwitz 18:33
Re: update with RE 20:05
view rules Oleg Lebedev 20:17
Re: update returns 1, but no changes have been made Gregory Wood 20:37
Re: view rules Ross J. Reedstrom 21:32
Re: Select into Jean-Michel Chabanne 21:43
Re: view rules Oleg Lebedev 22:14
Re: Inline IF condition Keith Gray 22:42
Trigger for logging stuff... Larry Rosenman 23:02
Re: type casting bpchar Stephan Szabo 23:18
Trigger for logging stuff... Larry Rosenman 23:36

Dec. 7, 2001

Thread Author Time
Re: how to chane the type Christopher Kings-Lynne 01:45
Re: how to chane the type Stephan Szabo 02:05
Re: [SQL] how to change the type Christopher Kings-Lynne 02:09
Re: [SQL] how to change the type Stephan Szabo 02:41
Replacing "LIKE" with "=" sharmad 03:46
anyone can help? Melisa 06:05
Re: [SQL] how to change the type Tom Lane 15:36
Vacuum analyze decreases speed 📎 David M. Richter 15:39
Re: Vacuum analyze decreases speed Tom Lane 17:11
Just comments about math Edipo Elder Fernandes de Melo 17:34
DISCTINCT and literals - Unable to identify an ordering operator mcornell 18:40
serial sequences not automatically dropped mcornell 18:44
Variable Length Binary String (not large) Jonathan Nichols 21:14
Re: [SQL] how to change the type Stephan Szabo 21:41
How to rename a database? Ligia Pimentel 22:06

Dec. 8, 2001

Thread Author Time
Re: plpgsql before insert update delete Ian Barwick 03:01

Dec. 9, 2001

Thread Author Time
Poolman/mySQL transaction exception on connect Dominic Da Silva 20:29

Dec. 10, 2001

Thread Author Time
Re: [SQL] how to change the type Christopher Kings-Lynne 02:32
Can anybody help me with SQL? Richard Lockwood 08:42
Re: Trigger for logging stuff... Bruce Momjian 10:33
Re: Just comments about math Andrew G. Hammond 15:12
Re: anyone can help? Nick Fankhauser 18:10
Re: Can anybody help me with SQL? Andrew Bell 18:10
Re: anyone can help? Roberto Mello 19:08
Re: Poolman/mySQL transaction exception on connect Jason Earl 19:11
Re: anyone can help? Jason Earl 19:33
Re: Poolman/mySQL transaction exception on connect Josh Berkus 19:38
Re: Replacing "LIKE" with "=" Josh Berkus 19:43
postgresql v 7.1.3 error Ivan Manuel Andrade Muñoz 19:48
Re: serial sequences not automatically dropped Stephan Szabo 21:09
Re: [SQL] Can anybody help me with SQL? Stephan Szabo 21:33

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

Browse Archives

Prev | Next