pgsql-sql - July 2004

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 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 1, 2004

Thread Author Time
Re: finding if a foreign key is in use Kenneth Gonsalves 02:13
Re: finding if a foreign key is in use Stephan Szabo 06:54
Re: finding if a foreign key is in use Achilleus Mantzios 09:36
Re: finding if a foreign key is in use Phil Endecott 09:57
Re: FW: "=" operator vs. "IS" Jeff Boes 15:02
How to make a portable application? Bob Hobart 18:11

July 2, 2004

Thread Author Time
best method to copy data across databases ctrl 03:42
Re: quoting Tom Lane 03:56
Re: quoting Michael Kleiser 07:04
Re: best method to copy data across databases Tony Reina 11:10
Re: best method to copy data across databases Tom Lane 14:12
Re: Question about a CIDR based query George Siganos 17:39

July 3, 2004

Thread Author Time
Error in DatabaseMetaData.getColumns() with Views Dario Fassi 01:14
Re: Error in DatabaseMetaData.getColumns() with Views Kris Jurka 08:45
Re: Error in DatabaseMetaData.getColumns() with Views Dario V. Fassi 17:06
Re: best method to copy data across databases ctrl 18:19
Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views 📎 Dario V. Fassi 18:39

July 4, 2004

Thread Author Time
Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Kris Jurka 19:16
Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Dario V. Fassi 20:58
Why no exprs in format string to RAISE Markus Bertheau 21:21
Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Stephan Szabo 22:51
Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Dario V. Fassi 23:28

July 5, 2004

Thread Author Time
Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Stephan Szabo 00:46
Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Dario V. Fassi 01:10
Re: [JDBC] Error in DatabaseMetaData.getColumns() with Views Stephan Szabo 01:41
Re: Why no exprs in format string to RAISE Richard Huxton 11:34
What is PG best practice for storing temporary data in functions? Ben 12:29
Custom type where not all elements are comparable Markus Bertheau 15:31
Re: Custom type where not all elements are comparable Tom Lane 16:32
Re: Custom type where not all elements are comparable Peter Eisentraut 19:39

July 6, 2004

Thread Author Time
Immutable function in index SZŰCS Gábor 08:58
Re: [SQL] Immutable function in index Tom Lane 13:37
Re: Why no exprs in format string to RAISE Bruce Momjian 17:26
How to filter on timestamps? B.W.H. van Beest 18:37

July 7, 2004

Thread Author Time
Re: How to filter on timestamps? Mike Rylander 03:28
Help with sql statement grouping and distinct David Inglis 04:38
ResultSerMetaData.getColumnDisplaySize() with timestamp error Dario V. Fassi 06:31
Triggers - need help !!! Pradeepkumar, Pyatalo (IE10) 06:45
Re: Triggers - need help !!! Tomasz Myrta 07:20
Re: Triggers - need help !!! Pradeepkumar, Pyatalo (IE10) 08:48
Re: Triggers - need help !!! Richard Huxton 11:03
Re: Triggers - need help !!! Mischa Sandberg 12:43
append columns that are null Gerwin Philippo 15:01
Re: append columns that are null nobody 15:25
Re: append columns that are null Hans de Bruin 19:35

July 8, 2004

Thread Author Time
Re: ResultSerMetaData.getColumnDisplaySize() with timestamp Kris Jurka 06:46
Re: append columns that are null Gerwin Philippo 07:26
Re: append columns that are null nobody 08:53
Constraint->function dependency and dump in 7.3 SZŰCS Gábor 11:09
Re: Triggers - need help !!! SZUCS Gábor 11:19
Re: append columns that are null Gerwin Philippo 12:53
Newbie (to postgres) question Pedro B. 13:36
Secure DB Systems - How to Sarah Tanembaum 15:49

July 9, 2004

Thread Author Time
Re: Constraint->function dependency and dump in 7.3 Együd Csaba 05:15
Re: [PHP] Secure DB Systems - How to Bruno Wolff III 15:27
Re: Constraint->function dependency and dump in 7.3 Verebes Gabor 15:34
Re: ResultSerMetaData.getColumnDisplaySize() with timestamp Kris Jurka 23:55

July 10, 2004

Thread Author Time
Problem in Stored Procedures Pradeepkumar, Pyatalo (IE10) 06:31

July 11, 2004

Thread Author Time
Re: Problem in Stored Procedures Rajesh Kumar Mallah 06:35
please help me with text cast to int .... Theodore Petrosky 16:22
Re: please help me with text cast to int .... Phil Endecott 17:01
Re: please help me with text cast to int .... Stephan Szabo 17:06
Re: please help me with text cast to int .... Theodore Petrosky 18:52

July 12, 2004

Thread Author Time
Sorting problem Ruggero 08:27
Comparing tsearch2 vectors. Rajesh Kumar Mallah 08:46
Re: Comparing tsearch2 vectors. Achilleus Mantzios 10:59
Re: Comparing tsearch2 vectors. Achilleus Mantzios 12:03
Re: Constraint->function dependency and dump in 7.3 SZŰCS Gábor 12:29
Re: Comparing tsearch2 vectors. Rajesh Kumar Mallah 12:34
Re: Constraint->function dependency and dump in 7.3 Rod Taylor 12:51
Re: Constraint->function dependency and dump in 7.3 Együd Csaba 13:06
Re: Comparing tsearch2 vectors. Achilleus Mantzios 13:40
Re: Comparing tsearch2 vectors. Rajesh Kumar Mallah 14:06
Re: Secure DB Systems - How to Rajesh Kumar Mallah 14:07
Order of execution of rules Hilary Forbes 16:09
Re: Order of execution of rules Stef 16:43
Re: [PHP] Secure DB Systems - How to Sarah Tanembaum 21:48
Re: Secure DB Systems - How to Sarah Tanembaum 22:09

July 13, 2004

Thread Author Time
Re: Comparing tsearch2 vectors. Rajesh Kumar Mallah 03:31
Re: Comparing tsearch2 vectors. Achilleus Mantzios 06:36
Re: [PHP] Secure DB Systems - How to Daniel Struck 09:35
Re: Sorting problem Stu 10:54
[ocpfree] Query Optimization Help Needed. vaibhav singh 11:40
Re: [PHP] Secure DB Systems - How to Bruno Wolff III 12:38
Query plan discrepancies Bob Arens 12:56
Re: [PHP] Secure DB Systems - How to Daniel Struck 13:18
Re: [ADMIN] [PHP] Secure DB Systems - How to Mitch Pirtle 14:06
Re: Constraint->function dependency and dump in 7.3 SZŰCS Gábor 16:29
Re: Constraint->function dependency and dump in 7.3 Rod Taylor 17:20
Re: Constraint->function dependency and dump in 7.3 SZŰCS Gábor 17:42
Certain COPY's ignored from dump? SZŰCS Gábor 17:54
Re: Constraint->function dependency and dump in 7.3 Rod Taylor 18:03
Re: Constraint->function dependency and dump in 7.3 SZŰCS Gábor 18:20
How do I convice postgres to use an index? Vic Ricker 20:29

July 14, 2004

Thread Author Time
schemas Kenneth Gonsalves 02:10
Re: schemas Bruno Wolff III 05:36
FOR-IN-EXECUTE, why fail? Marcos Medina 15:13
Indexable (constant LIKE prefix_keyfield) ? Alexander M. Pravking 18:51

July 15, 2004

Thread Author Time
calling function , passing OLD as argument R.Welz 00:23
Re: Secure DB Systems - How to Christopher Browne 02:44
Re: How do I convice postgres to use an index? Achilleus Mantzios 14:00
Re: How do I convice postgres to use an index? SZUCS Gábor 14:29
Re: 'UPDATE OR INSERT' command Stephen Frost 17:49
Re: 'UPDATE OR INSERT' command Bruno Wolff III 17:53
'UPDATE OR INSERT' command Jeff Kowalczyk 18:20

July 16, 2004

Thread Author Time
Problem in age on a dates interval Luis Sousa 08:45
Re: Problem in age on a dates interval Theodore Petrosky 11:52
Re: Problem in age on a dates interval Tom Lane 14:34
Re: Sorting problem Stephan Szabo 19:14
BYTEA output presentation Peter Wang 20:18
Re: BYTEA output presentation Peter Eisentraut 20:48

July 17, 2004

Thread Author Time
Re: Query plan discrepancies Rod Taylor 02:28
Re: FOR-IN-EXECUTE, why fail? Gaetano Mendola 09:49
Migrate postgres databases from SQL_ASCII to UNICODE encoding Dario V. Fassi 20:03
Re: Migrate postgres databases from SQL_ASCII to UNICODE encoding Tom Lane 21:18
Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Dario V. Fassi 23:26

July 18, 2004

Thread Author Time
Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Andrew Lazarus 02:00
Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Tom Lane 06:29
Re: [JDBC] [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Peter Eisentraut 08:28
Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Dario V. Fassi 19:47

July 19, 2004

Thread Author Time
Re: FOR-IN-EXECUTE, why fail? Tom Lane 04:23
Re: How do I convice postgres to use an index? SZUCS Gabor 08:47
Re: Problem in age on a dates interval Luis Sousa 09:00
Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Michael Stephenson 10:25
Re: Problem in age on a dates interval Alexander M. Pravking 10:46
Re: [ADMIN] Migrate postgres databases from SQL_ASCII to UNICODE Xavier Poinsard 12:46
C++ interface problem with libpq.so.3 Kemin Zhou 18:54
Re: C++ interface problem with libpq.so.3 Tom Lane 20:04
Group by failing on Null values Caleb Simonyi-Gindele 22:11
Re: Group by failing on Null values Rosser Schwarz 22:29

July 20, 2004

Thread Author Time
locks and triggers. give me an advice please sad 05:36
Re: Problem in age on a dates interval Luis Sousa 08:17
Stored procedures and "pseudo" fields.. Lars Erik Thorsplass 10:43
surrogate key or not? Markus Bertheau 12:16
Stored procedures and "pseudo" fields.. Lars Erik Thorsplass 13:34
Re: Stored procedures and "pseudo" fields.. Tomasz Myrta 13:57
Re: Stored procedures and "pseudo" fields.. Markus Bertheau 14:11
Re: How do I convice postgres to use an index? Vic Ricker 14:21
Inherited tables and new fields Jeff Boes 14:36
SELECT query/subquery problem Caleb Simonyi-Gindele 15:27
Re: Stored procedures and "pseudo" fields.. Scott Marlowe 15:45
fail to compare between bytea output in plpgsql Peter Wang 18:24
Re: locks and triggers. give me an advice please Steve Crawford 18:30
Re: [GENERAL] Stored procedures and "pseudo" fields.. Lars Erik Thorsplass 22:03

July 21, 2004

Thread Author Time
date_format in postresql azah azah 00:55
Re: surrogate key or not? Iain 01:31
Re: date_format in postresql Christopher Kings-Lynne 01:45
Re: date_format in postresql Rod Taylor 02:39
Re: date_format in postresql azah azah 03:53
Re: locks and triggers. give me an advice please sad 05:01
Re: surrogate key or not? Josh Berkus 07:00
Re: Inherited tables and new fields Oliver Elphick 07:11
Re: surrogate key or not? Josh Berkus 07:30
Re: surrogate key or not? sad 07:44
Please help me.. problem in to_char azah azah 08:33
Re: surrogate key or not? sad 10:30
Re: surrogate key or not? Markus Bertheau 10:58
? on announcement of 7.5 sad 11:42
Re: Please help me.. problem in to_char Markus Bertheau 12:15
Re: Please help me.. problem in to_char Theodore Petrosky 12:35
Re: date_format in postresql Frank Bax 13:17
immutable function calling stable function Markus Bertheau 14:04
Re: date_format in postresql Rod Taylor 14:45
Re: immutable function calling stable function Tom Lane 14:45
MySQL-style "create temporary table foo select ..." Geoff Richards 14:49
Re: immutable function calling stable function Stephan Szabo 14:51
Re: MySQL-style "create temporary table foo select ..." Michael Kleiser 15:07
Sorry too many conecctions Javier Tesis Tolosa Trabajo 15:08
Re: surrogate key or not? Rod Taylor 15:10
Re: MySQL-style "create temporary table foo select ..." Geoff Richards 15:28
Re: surrogate key or not? Josh Berkus 17:25
Re: Sorry too many conecctions Gregory S. Williamson 19:34
Re: ? on announcement of 7.5 Josh Berkus 23:19

July 22, 2004

Thread Author Time
Re: surrogate key or not? Iain 02:42
Re: Please help me.. problem in to_char azah azah 02:43
next integer in serial key Kenneth Gonsalves 02:45
Re: Please help me.. problem in to_char azah azah 02:59
Re: date_format in postresql azah azah 03:13
Re: next integer in serial key terry 04:55
Re: next integer in serial key Oliver Elphick 05:31
LIKE on index not working Chris Cox 07:38
Re: connection delay Achilleus Mantzios 08:07
connection delay cristi 08:12
Issue with plpgsql trigger Oeln 10:17
Re: next integer in serial key Kenneth Gonsalves 11:40
Re: next integer in serial key terry 11:48
Re: next integer in serial key Kenneth Gonsalves 11:51
Re: next integer in serial key Oliver Elphick 12:15
Re: surrogate key or not? Karsten Hilbert 12:20
Re: LIKE on index not working Peter Eisentraut 12:41
Re: next integer in serial key terry 13:10
Re: next integer in serial key terry 13:38
Re: next integer in serial key Stephan Szabo 13:52
PSQL Syntax errors running PL/SQL scripts Oleg Konovalov 13:54
Re: LIKE on index not working Chris Browne 14:42
Converting a plperlu function to a plpgsql function Devin Whalen 14:49
Problem with transaction in functions and tempory tables Gerardo Castillo 16:49
Re: surrogate key or not? Josh Berkus 17:05
Re: LIKE on index not working Tom Lane 17:10
Re: Problem with transaction in functions and tempory tables Stephan Szabo 17:27

Browse Archives

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