pgsql-sql - August 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 22 23 24 25 26 27 28 29 30 31

Aug. 1, 2004

Thread Author Time
Need help form inherits 📎 Patrice OLIVER 16:07

Aug. 2, 2004

Thread Author Time
Re: How to create an aggregate? Greg Stark 04:25
Help on triggers Pradeepkumar, Pyatalo (IE10) 05:27
error in compiling the function -- need help !!! 📎 Pradeepkumar, Pyatalo (IE10) 05:33
org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) Smita Marda 06:51
Re: Help on triggers Scott Marlowe 08:19
Sum and count weird results Michalis Kabrianis 11:30
Re: How to create an aggregate? Ray Aspeitia 13:00
Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev 15:53
Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev 16:09
Re: Problems with UNION ALL and ORDER BY Tom Lane 16:35
Re: Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev 16:39
Re: Problems with UNION ALL and ORDER BY Gaetano Mendola 16:45
Re: Problems with UNION ALL and ORDER BY Tom Lane 17:09
Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev 17:37
Re: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) Kris Jurka 17:44
Query execution differences Ray Aspeitia 19:00
Trigger and function not on speaking terms Jeff Boes 20:20
Re: Trigger and function not on speaking terms Richard Poole 21:20
Re: Trigger and function not on speaking terms Stephan Szabo 21:21

Aug. 3, 2004

Thread Author Time
Re: Trigger and function not on speaking terms Kevin Davis 02:11
Re: error in compiling the function -- need help !!! mike g 03:31
Datetime Pedro B. 07:22
Re: Datetime Achilleus Mantzios 10:23
Re: Datetime Michael Glaesemann 10:56
Re: Datetime Devrim GUNDUZ 10:58
Re: Datetime Michael Glaesemann 11:31
Re: Datetime Achilleus Mantzios 11:50
Re: Datetime Michael Glaesemann 13:26
Re: Datetime Tom Lane 15:13
Re: Datetime Michael Glaesemann 22:16
Re: Datetime Tom Lane 22:55

Aug. 4, 2004

Thread Author Time
Re: Datetime Michael Glaesemann 01:32

Aug. 5, 2004

Thread Author Time
SQL syntax extentions - to put postgres ahead in the race Ram Nathaniel 08:28
contrib/tablefunc crosstab Caleb Simonyi-Gindele 17:21
Re: contrib/tablefunc crosstab Joe Conway 18:18

Aug. 6, 2004

Thread Author Time
Re: SQL syntax extentions - to put postgres ahead in the race Stephan Szabo 05:22
Re: SQL syntax extentions - to put postgres ahead in the race Tom Lane 07:07
Re: retrieve the tables names based on the owner Achilleus Mantzios 09:17
retrieve the tables names based on the owner Antonis Antoniou 09:53
New PHP + PostgreSQL group on Google Groups2 N. David 14:02
Re: SQL syntax extentions - to put postgres ahead in the race Tom Lane 14:30
Make a column case insensitive Gordon Ross 15:29
UNIQUE constraint Sascha Ziemann 18:25
Grouping by week Caleb Simonyi-Gindele 21:29
Re: Grouping by week Oliver Elphick 22:08
Re: surrogate key or not? Josh Berkus 22:42
Re: Grouping by week Tom Lane 22:52

Aug. 7, 2004

Thread Author Time
Re: surrogate key or not? Kenneth Gonsalves 04:00
reply to setting Kenneth Gonsalves 04:03
Re: reply to setting Tom Lane 07:09
select Knut P Lehre 11:54

Aug. 8, 2004

Thread Author Time
Re: surrogate key or not? Kenneth Gonsalves 00:29
Re: surrogate key or not? Oliver Elphick 01:06
Re: Make a column case insensitive Rod Taylor 19:27
Re: Make a column case insensitive Thomas Wegner 20:39
Re: surrogate key or not? Josh Berkus 22:19
Re: UNIQUE constraint Michael Glaesemann 23:55

Aug. 9, 2004

Thread Author Time
Re: Make a column case insensitive Jan Wieck 03:40
Re: Make a column case insensitive Pierre-Frédéric Caillaud 06:09
Re: Make a column case insensitive Tom Lane 06:21
Re: UNIQUE constraint Sascha Ziemann 09:41
Re: select Christoph Haller 14:53
Suggestions on storing re-occurring calendar events Matt Nuzum 14:56
Exception handling from trigger Vlad Dimitriu 16:47
Re: Exception handling from trigger Rod Taylor 16:52
Re: Exception handling from trigger Tom Lane 17:14
Re: surrogate keys and replication. Josh Berkus 17:33
Re: Exception handling from trigger Vlad Dimitriu 17:38
Re: Suggestions on storing re-occurring calendar events Josh Berkus 17:39
Re: Exception handling from trigger Vlad Dimitriu 17:48
UPDATE FROM problem, multiple updates of same row don't seem to work David Stanaway 20:16

Aug. 10, 2004

Thread Author Time
function expression in FROM may not refer to other relations of same query level Philippe Lang 13:09
Re: Stored procedures and "pseudo" fields Christoph Haller 13:44
sleep function John DeSoi 14:05
Re: sleep function Bruce Momjian 14:57
Re: function expression in FROM may not refer to other relations Joe Conway 17:41

Aug. 11, 2004

Thread Author Time
LIKE '%%' does not return NULL Traci Sumpter 01:22
ERROR: Cross-database references are not implemented Theo Galanakis 02:23
Re: ERROR: Cross-database references are not implemented Joe Conway 03:35
Re: ERROR: Cross-database references are not implemented - Theo Galanakis 04:04
Wierded error in recursive function; debugging ideas? Josh Berkus 04:56
Re: Wierded error in recursive function; debugging ideas? Joe Conway 05:05
Re: function expression in FROM may not refer to other relations of same query level Philippe Lang 06:41
Re: function expression in FROM may not refer to other relations of same query level Philippe Lang 08:24
Inserts with incomplete rows... NOT NULL constraints Lars Erik Thorsplass 12:35
Re: Inserts with incomplete rows... NOT NULL constraints Peter Eisentraut 13:02
Re: Inserts with incomplete rows... NOT NULL constraints Richard Huxton 13:34
Displaying two tables side by side David Garamond 14:11
COMMENT ON CONSTRAINT Sascha Ziemann 14:29
Re: function expression in FROM may not refer to other relations of same query level Rosser Schwarz 14:41
Re: Displaying two tables side by side Michael Kleiser 16:44
Re: Sum and count weird results Michalis Kabrianis 17:04
Re: Displaying two tables side by side Andreas Haumer 17:37
Re: Wierded error in recursive function; debugging ideas? Josh Berkus 17:58
Re: Displaying two tables side by side Rod Taylor 18:32
Re: Displaying two tables side by side David Garamond 18:55
Re: reply to setting Bruno Wolff III 19:13
Re: sleep function John DeSoi 19:47
Re: Displaying two tables side by side Gaetano Mendola 20:15
Fwd: Inserts with incomplete rows... NOT NULL constraints Lars Erik Thorsplass 20:19
Wierd Error on update Thomas Seeber 20:21
Re: reply to setting Joe Conway 20:45
Re: reply to setting Rod Taylor 21:18
Re: Wierded error in recursive function; debugging ideas? Joe Conway 22:18
Re: Wierd Error on update Tom Lane 22:48
Re: Wierded error in recursive function; debugging ideas? Josh Berkus 22:52
Re: UPDATE FROM problem, multiple updates of same row don't seem to work Bruno Wolff III 23:52

Aug. 12, 2004

Thread Author Time
Re: reply to setting Bruno Wolff III 02:15
Re: UPDATE FROM problem, multiple updates of same row don't seem to work Bruno Wolff III 02:27
Re: function expression in FROM may not refer to other relations of same query level Philippe Lang 07:35
Inserting into point[] type. Theo Galanakis 07:58
Maybe install debian on your home pc? Stef 07:59
Re: Maybe install debian on your home pc? Stef 08:01
Re: Inserting into point[] type. Markus Bertheau 08:27
Returning A Varchar From A Function Richard Hurst 09:04
duplicate table in two databases Fabio Ferrero 13:42
Sending errors from psql to error file Devin Whalen 14:20
Re: function expression in FROM may not refer to other relations of same query level Tom Lane 14:30
Re: function expression in FROM may not refer to other relations Stephan Szabo 14:36
how to cast localtimestamp to bigint??? Pradeepkumar, Pyatalo (IE10) 14:47
Re: Sending errors from psql to error file Oliver Elphick 14:50
Re: Sending errors from psql to error file Richard Huxton 15:00
Re: Sending errors from psql to error file Devin Whalen 15:01
Re: Sending errors from psql to error file Oliver Elphick 15:09
Re: Sending errors from psql to error file Oliver Elphick 15:13
Re: Sending errors from psql to error file Devin Whalen 15:53
Re: [SQL] how to cast localtimestamp to bigint??? Edmund Bacon 16:58
Getting points from polygon Sebastian Albrecht 16:59
Re: Suggestions on storing re-occurring calendar events --CELKO-- 19:45
Performance Problem With Postgresql! Arash Zaryoun 20:09

Aug. 13, 2004

Thread Author Time
Re: function expression in FROM may not refer to other relations of same query level Philippe Lang 08:52
Re: [SQL] how to cast localtimestamp to bigint??? Guy Fraser 14:44
Re: Wierd Error on update Pentilian 16:05
Re: Wierd Error on update Thomas Seeber 16:21
Re: [PERFORM] Performance Problem With Postgresql! Josh Berkus 17:19
Re: [SQL] how to cast localtimestamp to bigint??? george young 17:34
Re: Wierd Error on update Tom Lane 17:54
tablefunc's in 8.0 Beta Win32 - where? Thomas Wegner 20:56

Aug. 14, 2004

Thread Author Time
Re: tablefunc's in 8.0 Beta Win32 - where? Thomas Wegner 22:20

Aug. 15, 2004

Thread Author Time
Re: LIKE '%%' does not return NULL Stephan Szabo 18:56
Re: LIKE '%%' does not return NULL Frank Finner 19:17
Re: Getting points from polygon Tom Lane 19:43
CROSS-TAB query help? I have read it cant be done in one SQL, pro ve them wrong! Theo Galanakis 23:46

Aug. 16, 2004

Thread Author Time
Re: COMMENT ON CONSTRAINT Andreas Seltenreich 01:03
Inheriting text[] field Kaloyan Iliev Iliev 07:06
Re: duplicate table in two databases Richard Huxton 08:01
Re: CROSS-TAB query help? I have read it cant be done in one Richard Huxton 08:06
Re: Returning A Varchar From A Function George Weaver 12:40
SQL_ASCII and UNICODE server_encoding Achilleus Mantzios 13:56
Re: Inheriting text[] field Tom Lane 14:28
Re: SQL_ASCII and UNICODE server_encoding Achilleus Mantzios 14:42
Re: SQL_ASCII and UNICODE server_encoding Tom Lane 15:04
any chance SQL ASSERTIONS will be implemented? Markus Bertheau 20:15
Re: any chance SQL ASSERTIONS will be implemented? Peter Eisentraut 20:41
Verifying data type Elieser Leão 21:16
Re: Verifying data type Tom Lane 23:30

Aug. 17, 2004

Thread Author Time
Re: CROSS-TAB query help? I have read it cant be done in on Theo Galanakis 02:47
multi column foreign key for implicitly unique columns Markus Bertheau 09:25
Re: multi column foreign key for implicitly unique columns Oliver Elphick 09:39
Re: CROSS-TAB query help? I have read it cant be done in on Richard Huxton 09:48
Re: multi column foreign key for implicitly unique columns Markus Bertheau 09:49
Re: multi column foreign key for implicitly unique columns Richard Huxton 09:52
only last records in subgroups Dino Vliet 10:44
SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau 11:07
Re: only last records in subgroups Achilleus Mantzios 11:35
Re: Inheriting text[] field Kaloyan Iliev Iliev 13:16
Re: Verifying data type Elieser Leão 13:48
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III 14:12
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau 14:21
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance 14:26
Re: multi column foreign key for implicitly unique columns Stephan Szabo 14:26
Re: multi column foreign key for implicitly unique columns Tom Lane 14:46
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau 14:51
Re: multi column foreign key for implicitly unique columns Markus Bertheau 14:57
Re: multi column foreign key for implicitly unique columns Stephan Szabo 15:06
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Stephan Szabo 15:09
Re: multi column foreign key for implicitly unique columns Markus Bertheau 15:12
Re: multi column foreign key for implicitly unique columns Stephan Szabo 15:24
Re: multi column foreign key for implicitly unique columns Tom Lane 15:38
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance 15:54
Possible rounding error of large float values? Adam Lancaster 17:21
Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III 17:31

Aug. 18, 2004

Thread Author Time
Re: multi column foreign key for implicitly unique columns Josh Berkus 02:45
SQL Challenge: Arbitrary Cross-tab Josh Berkus 02:55
Re: SQL Challenge: Arbitrary Cross-tab elein 03:18
Re: SQL Challenge: Arbitrary Cross-tab Stephan Szabo 03:35
Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane 03:36
Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus 03:41
Re: SQL Challenge: Arbitrary Cross-tab Joe Conway 05:15
Re: multi column foreign key for implicitly unique columns Markus Bertheau 06:00
[No subject] Theo Galanakis 06:11
Re: SQL Challenge: Arbitrary Cross-tab Gaetano Mendola 11:01
Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane 11:47
Re: multi column foreign key for implicitly unique columns Jan Wieck 13:33
Re: multi column foreign key for implicitly unique columns Markus Bertheau 13:49
Re: multi column foreign key for implicitly unique columns Jan Wieck 14:06
Re: multi column foreign key for implicitly unique columns Markus Bertheau 14:28
Re: multi column foreign key for implicitly unique columns Stephan Szabo 14:38
Re: SQL Challenge: Arbitrary Cross-tab Gaetano Mendola 14:48

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 22 23 24 25 26 27 28 29 30 31