pgsql-sql - October 2005

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 17 18 19 20 21 22 24 25 26 27 28 29 31

Oct. 1, 2005

Thread Author Time
BirthDay SQL Issue brett 22:32

Oct. 2, 2005

Thread Author Time
Getting user created tables from SQL Cenk KIZILDAG 13:30

Oct. 3, 2005

Thread Author Time
Re: combination of function to simple query makes query slow jan aerts (RI) 10:21
Re: combination of function to simple query makes query slow Jaime Casanova 19:21
MOVE in SQL vs PLPGSQL andrew 20:57
regular expression gurkan 22:08

Oct. 4, 2005

Thread Author Time
Re: combination of function to simple query makes query slow jan aerts (RI) 08:27
Re: combination of function to simple query makes query slow Tom Lane 14:50
using pg_tables and tablename in queries solarsail 16:30
Re: using pg_tables and tablename in queries Tom Lane 17:01
Re: using pg_tables and tablename in queries solarsail 18:40
Re: using pg_tables and tablename in queries Yasir Malik 19:23
Re: using pg_tables and tablename in queries Jim Buttafuoco 19:45
Re: using pg_tables and tablename in queries solarsail 19:50
Re: using pg_tables and tablename in queries Gregory S. Williamson 22:33
Re: Help with multistage query Jim C. Nasby 22:34
Re: Why doesn't the SERIAL data type automatically have a Jim C. Nasby 22:52
Re: Why doesn't the SERIAL data type automatically have a Richard Huxton 23:23
Re: Why doesn't the SERIAL data type automatically have a Ferindo Middleton Jr 23:50
Re: Why doesn't the SERIAL data type automatically have a Ferindo Middleton Jr 23:54

Oct. 5, 2005

Thread Author Time
Re: Why doesn't the SERIAL data type automatically have a Jim C. Nasby 00:06
Re: using pg_tables and tablename in queries Jim Buttafuoco 01:01
Re: regular expression Gnanavel S 04:56
Re: regular expression Michael Fuhr 05:56
Re: MOVE in SQL vs PLPGSQL Richard Huxton 08:18
Re: creating postgres tables by passing a string to function Richard Huxton 08:20
Re: BirthDay SQL Issue Richard Huxton 08:30
Re: Getting user created tables from SQL Richard Huxton 08:32
Help with simple SQL query? Joost Kraaijeveld 11:35
Re: Help with simple SQL query? Gregory S. Williamson 11:47
Re: Help with simple SQL query? Frank van Vugt 12:21
Re: Help with simple SQL query? Joost Kraaijeveld 13:19
Re: MOVE in SQL vs PLPGSQL Richard Huxton 15:01
Re: BirthDay SQL Issue Andreas Kretschmer 15:12
Use of partial index Leif B. Kristensen 15:17
Re: using pg_tables and tablename in queries codeWarrior 15:24
Re: BirthDay SQL Issue Kenneth Gonsalves 15:30
Re: MOVE in SQL vs PLPGSQL Tom Lane 15:43
Re: Use of partial index Dmitri Bichko 16:44
Re: Use of partial index Stephan Szabo 16:48
Re: Use of partial index Tom Lane 16:49
Re: Use of partial index Leif B. Kristensen 17:20
Re: Use of partial index Leif B. Kristensen 17:21

Oct. 6, 2005

Thread Author Time
Scripting GRANT on functions Stewart Ben (RBAU/EQS4) * 05:27
catching errors in function padmanabha konkodi 06:55
Re: catching errors in function Eugene E. 07:11
Noob question about types and lists xchris 10:40
Re: Noob question about types and lists Richard Huxton 11:20
Re: Noob question about types and lists xchris 11:52
Re: Noob question about types and lists Richard Huxton 12:19
DATESTYLE and 0000-00-00 Joshua Kramer 13:01
Re: Scripting GRANT on functions Russell Simpkins 13:06
Re: Scripting GRANT on functions Tom Lane 13:33
Re: catching errors in function John DeSoi 13:51
UNION index use help Dmitri Bichko 15:59
Re: UNION index use help Tom Lane 16:32
Re: UNION index use help Dmitri Bichko 17:25
Re: DATESTYLE and 0000-00-00 Andrew Sullivan 18:15
Re: DATESTYLE and 0000-00-00 D'Arcy J.M. Cain 18:16
Re: DATESTYLE and 0000-00-00 Michael Fuhr 18:37
Selecting records not present in related tables Hector Rosas 19:43
Re: Selecting records not present in related tables Anthony Molinaro 20:11
Re: Selecting records not present in related tables Scott Marlowe 20:13
Re: Selecting records not present in related tables Frank Bax 20:28
Re: MOVE in SQL vs PLPGSQL Greg Stark 20:39

Oct. 7, 2005

Thread Author Time
RULES on SELECT with JDBC/perlDBI from other RDBMS products? Bath, David 01:07
How to delete Large Object from Database? Premsun Choltanwanich 04:27
Re: How to delete Large Object from Database? Richard Huxton 07:30
Re: RULES on SELECT with JDBC/perlDBI from other RDBMS products? Richard Huxton 07:31
Re: RULES on SELECT with JDBC/perlDBI from other RDBMS Sean Davis 10:23
Re: using pg_tables and tablename in queries solarsail 19:54

Oct. 8, 2005

Thread Author Time
Re: How to delete Large Object from Database? Volkan YAZICI 11:20

Oct. 9, 2005

Thread Author Time
convert time Simon Law 23:20

Oct. 10, 2005

Thread Author Time
Re: convert time Michael Fuhr 03:13
Re: How to delete Large Object from Database? Premsun Choltanwanich 08:57
Re: How to delete Large Object from Database? Richard Huxton 10:06

Oct. 11, 2005

Thread Author Time
Re: How to delete Large Object from Database? Premsun Choltanwanich 02:11
Re: How to delete Large Object from Database? Tom Lane 03:00
Re: How to delete Large Object from Database? Premsun Choltanwanich 03:10
Problem -Postgre sql Vikas J 07:20
SEVEN cross joins?!?!? Frank Bax 11:15
Re: SEVEN cross joins?!?!? Richard Huxton 12:29
question re. count, group by, and having Rick Schumeyer 12:50
Re: question re. count, group by, and having Sean Davis 13:07
Difference from average Neil Saunders 13:20
Re: question re. count, group by, and having Tom Lane 14:03
ichar Judith Altamirano Figueroa 14:22
Re: Difference from average Richard Huxton 14:24
Returning NULL results? Mario Splivalo 14:27
Re: ichar Tom Lane 14:37
Re: ichar Richard Huxton 14:37
Re: Returning NULL results? Richard Huxton 14:39
Double query (limit and offset) Michael Landin Hostbaek 15:11
Re: generating a sequence table against which to do a LEFT OUTER JOIN David Fetter 18:35
Re: SEVEN cross joins?!?!? Frank Bax 20:06
pg, mysql comparison with "group by" clause Rick Schumeyer 21:12
Re: pg, mysql comparison with "group by" clause Scott Marlowe 21:21
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 21:22
Re: question re. count, group by, and having Muralidharan Ramakrishnan 21:27
Re: pg, mysql comparison with "group by" clause Stephan Szabo 21:32
Re: SEVEN cross joins?!?!? Greg Patnude 22:14

Oct. 12, 2005

Thread Author Time
Very Urgent Req for SQL-DBS In Chennai farhin 06:53
Re: Returning NULL results? Mario Splivalo 07:36
Re: SEVEN cross joins?!?!? Richard Huxton 10:34
Re: SEVEN cross joins?!?!? Daryl Richter 13:00
Strange join...maybe some improvements??? Andy 13:52
Text->Date conversion in a WHERE clause Collin Peters 20:59
Re: regular expression Michael Fuhr 21:03
Re: Text->Date conversion in a WHERE clause cadiolis 21:37
Re: pg, mysql comparison with "group by" clause Greg Stark 21:54
Re: regular expression Yasir Malik 21:55
Re: Text->Date conversion in a WHERE clause Greg Stark 22:01
Re: Text->Date conversion in a WHERE clause Tom Lane 22:20
Re: pg, mysql comparison with "group by" clause Scott Marlowe 22:24
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 22:35
Re: Text->Date conversion in a WHERE clause Tom Lane 23:00

Oct. 13, 2005

Thread Author Time
Update timestamp on update Jeff Williams 01:12
Re: pg, mysql comparison with "group by" clause Greg Stark 01:13
Re: Update timestamp on update Tom Lane 01:44
Re: SEVEN cross joins?!?!? Frank Bax 01:48
Re: pg, mysql comparison with "group by" clause Tom Lane 01:50
Re: SEVEN cross joins?!?!? Stewart Ben (RBAU/EQS4) * 02:02
Re: Update timestamp on update Jeff Williams 02:42
Re: [SQL] Update timestamp on update Tom Lane 02:52
Re: Update timestamp on update Stewart Ben (RBAU/EQS4) * 02:56
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 03:02
Re: Update timestamp on update Michael Glaesemann 03:07
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 03:20
Re: pg, mysql comparison with "group by" clause Greg Stark 03:43
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 03:49
Re: pg, mysql comparison with "group by" clause Greg Stark 04:24
UPDATE Trigger on multiple tables Ferindo Middleton Jr 04:29
Re: UPDATE Trigger on multiple tables Tom Lane 04:39
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 05:28
Storing images from Delphi to postgresql NSO 10:26
Query information needed djzanky 12:50
Re: SEVEN cross joins?!?!? Daryl Richter 13:04
Re: UPDATE Trigger on multiple tables Muralidharan Ramakrishnan 13:22
Re: pg, mysql comparison with "group by" clause Andrew Sullivan 14:11
Re: Update timestamp on update Andrew Sullivan 14:22
[No subject] Shavonne Marietta Wijesinghe 15:31
Re: pg, mysql comparison with "group by" clause Scott Marlowe 15:57
Re: Strange join...maybe some improvements??? Thomas F. O'Connell 16:58
Re: [SQL] Update timestamp on update Jim C. Nasby 17:20
Re: [DOCS] Update timestamp on update Mike Diehl 17:45
Re: pg, mysql comparison with "group by" clause Greg Stark 18:26
Re: Strange join...maybe some improvements??? Andy 18:28
Re: pg, mysql comparison with "group by" clause Scott Marlowe 18:37
Re: pg, mysql comparison with "group by" clause Andrew Sullivan 18:43
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 18:48
Re: pg, mysql comparison with "group by" clause Tom Lane 18:49
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 19:06
Re: pg, mysql comparison with "group by" clause Tom Lane 19:16
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 19:38

Oct. 14, 2005

Thread Author Time
copy tables Shavonne Marietta Wijesinghe 06:54
Re: pg, mysql comparison with "group by" clause Greg Stark 07:21
Re: copy tables A. Kretschmer 07:25
copy table Shavonne Marietta Wijesinghe 08:44
Design problemi : using the same primary keys for inherited objects. David Pradier 09:18
Re: copy table A. Kretschmer 09:39
Re: pg, mysql comparison with "group by" clause Anthony Molinaro 11:11
Re: Design problemi : using the same primary keys for inherited objects. Russell Simpkins 11:18
pgOleDb Alessandro Lima 11:51
Re: Design problem : using the same primary keys for inherited objects. David Pradier 12:43
sql function Shavonne Marietta Wijesinghe 12:47
Re: sql function Andreas Kretschmer 13:18
Re: copy table Muralidharan Ramakrishnan 14:48
Re: Design problem : using the same primary keys for inherited Daryl Richter 14:57
Re: Design problemi : using the same primary keys for inherited objects. codeWarrior 15:29
owner of data type "areas" appears to be invalid ? george young 15:53
Re: Design problem : using the same primary keys for inherited objects. Russell Simpkins 15:53
Re: owner of data type "areas" appears to be invalid ? Tom Lane 16:04
Re: owner of data type "areas" appears to be invalid ? george young 16:19
FULL OUTER JOIN Question Tyler Kellen 18:02
FULL OUTER JOIN Question (mistake) Tyler Kellen 18:06
cast Judith Altamirano Figueroa 18:08
Re: cast Andrew Sullivan 18:19
Re: cast Dan Feiveson 18:20
Re: FULL OUTER JOIN Question Tom Lane 18:28

Oct. 15, 2005

Thread Author Time
Re: copy tables Dau Sy Manh 02:38
problems with array paperinik 100 08:49

Oct. 17, 2005

Thread Author Time
Question about functions Mike Plemmons 03:24
Re: Question about functions Stewart Ben (RBAU/EQS4) * 04:41
Problem while using start transaction ans commit; Sri 07:23
Re: Question about functions Richard Huxton 08:17
Re: Question about functions Richard Huxton 08:22
Re: Question about functions Richard Huxton 11:17
Re: Design problem : using the same primary keys for inherited objects. David Pradier 13:56
Re: Design problem : using the same primary keys for inherited objects. David Pradier 14:03
Re: Design problemi : using the same primary keys for inherited objects. David Pradier 14:13
Re: Design problemi : using the same primary keys for inherited Richard Huxton 16:57

Oct. 18, 2005

Thread Author Time
Consulta! Adriana Marcela Aguirre 14:26
Re: Consulta! Mario Splivalo 14:49
What Am I Doing Wrong? Lane Van Ingen 19:38
Re: What Am I Doing Wrong? Lane Van Ingen 21:20
query to file Judith Altamirano Figueroa 23:03
Re: Problem while using start transaction ans commit; Stewart Ben (RBAU/EQS4) * 23:13
Re: What Am I Doing Wrong? Michael Fuhr 23:39
Re: Query information needed Michael Glaesemann 23:40
Re: Problem -Postgre sql Michael Glaesemann 23:44

Browse Archives

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