Home > mailing lists

Mailing lists [pgsql-sql]

1 August 2004

13:07 Need help form inherits Patrice OLIVER

2 August 2004

01:35 Re: How to create an aggregate? Greg Stark
02:29 Help on triggers Pradeepkumar, Pyatalo (IE10)
02:41 error in compiling the function -- need help !!! Pradeepkumar, Pyatalo (IE10)
03:51 org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) Smita Marda
10:00 Re: How to create an aggregate? Ray Aspeitia
12:57 Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev
13:13 Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev
13:36 Re: Problems with UNION ALL and ORDER BY Tom Lane
13:44 Re: Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev
13:48 Re: Problems with UNION ALL and ORDER BY Gaetano Mendola
14:11 Re: Problems with UNION ALL and ORDER BY Tom Lane
14:42 Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev
14:57 Re: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) Kris Jurka
16:00 Query execution differences Ray Aspeitia
17:55 Trigger and function not on speaking terms Jeff Boes
18:20 Re: Trigger and function not on speaking terms Richard Poole
18:21 Re: Trigger and function not on speaking terms Stephan Szabo

3 August 2004

07:45 Datetime Pedro B.
07:57 Re: Datetime Michael Glaesemann
07:58 Re: Datetime Devrim GUNDUZ
08:12 Re: Datetime Achilleus Mantzios
08:31 Re: Datetime Michael Glaesemann
09:39 Re: Datetime Achilleus Mantzios
10:26 Re: Datetime Michael Glaesemann
12:15 Re: Datetime Tom Lane
19:18 Re: Datetime Michael Glaesemann
19:55 Re: Datetime Tom Lane
22:33 Re: Datetime Michael Glaesemann

5 August 2004

14:20 contrib/tablefunc crosstab Caleb Simonyi-Gindele
15:19 Re: contrib/tablefunc crosstab Joe Conway

6 August 2004

01:00 Sum and count weird results Michalis Kabrianis
01:02 Re: Trigger and function not on speaking terms Kevin Davis
01:29 SQL syntax extentions - to put postgres ahead in the race Ram Nathaniel
02:22 Re: SQL syntax extentions - to put postgres ahead in the race Stephan Szabo
04:07 Re: SQL syntax extentions - to put postgres ahead in the race Tom Lane
06:53 retrieve the tables names based on the owner Antonis Antoniou
07:05 Re: retrieve the tables names based on the owner Achilleus Mantzios
11:30 Re: SQL syntax extentions - to put postgres ahead in the race Tom Lane
12:30 Make a column case insensitive Gordon Ross
14:42 New PHP + PostgreSQL group on Google Groups2 dguarneri@satx.rr.com (N. David)
18:31 Grouping by week Caleb Simonyi-Gindele
19:11 Re: Grouping by week Oliver Elphick
19:44 Re: surrogate key or not? Josh Berkus
19:54 Re: Grouping by week Tom Lane

7 August 2004

03:39 Re: surrogate key or not? Kenneth Gonsalves
03:42 reply to setting Kenneth Gonsalves
04:09 Re: reply to setting Tom Lane
22:06 Re: surrogate key or not? Oliver Elphick
23:23 Re: surrogate key or not? Kenneth Gonsalves

8 August 2004

16:27 Re: Make a column case insensitive Rod Taylor
20:15 Re: Make a column case insensitive Thomas Wegner
20:16 UNIQUE constraint Sascha Ziemann
20:21 select Knut P Lehre
20:56 Re: UNIQUE constraint Michael Glaesemann
22:33 Re: surrogate key or not? Josh Berkus

9 August 2004

00:40 Re: Make a column case insensitive Jan Wieck
03:08 Re: Make a column case insensitive Pierre-Frédéric Caillaud
03:21 Re: Make a column case insensitive Tom Lane
11:54 Re: select Christoph Haller
11:57 Suggestions on storing re-occurring calendar events Matt Nuzum
13:46 Exception handling from trigger Vlad Dimitriu
13:54 Re: Exception handling from trigger Rod Taylor
14:16 Re: Exception handling from trigger Tom Lane
14:34 Re: surrogate keys and replication. Josh Berkus
14:37 Re: Exception handling from trigger Vlad Dimitriu
14:40 Re: Suggestions on storing re-occurring calendar events Josh Berkus
14:47 Re: Exception handling from trigger Vlad Dimitriu
17:16 UPDATE FROM problem, multiple updates of same row don't seem to work David Stanaway

10 August 2004

10:10 function expression in FROM may not refer to other relations of same query level Philippe Lang
10:50 Re: Stored procedures and "pseudo" fields Christoph Haller
11:06 sleep function John DeSoi
14:06 Re: sleep function Bruce Momjian
19:51 Re: function expression in FROM may not refer to other relations Joe Conway

11 August 2004

00:03 ERROR: Cross-database references are not implemented Theo Galanakis
00:41 Re: ERROR: Cross-database references are not implemented Joe Conway
01:10 Re: ERROR: Cross-database references are not implemented - Theo Galanakis
01:56 Wierded error in recursive function; debugging ideas? Josh Berkus
02:05 Re: Wierded error in recursive function; debugging ideas? Joe Conway
03:41 Re: function expression in FROM may not refer to other relations of same query level Philippe Lang
05:24 Re: function expression in FROM may not refer to other relations of same query level Philippe Lang
09:35 Inserts with incomplete rows... NOT NULL constraints Lars Erik Thorsplass
10:08 Re: Inserts with incomplete rows... NOT NULL constraints Peter Eisentraut
10:34 Re: Inserts with incomplete rows... NOT NULL constraints Richard Huxton
11:17 Displaying two tables side by side David Garamond
12:54 Re: function expression in FROM may not refer to other relations of same query level Rosser Schwarz
14:49 Re: Displaying two tables side by side Andreas Haumer
14:59 Re: Displaying two tables side by side Michael Kleiser
15:29 Re: Wierded error in recursive function; debugging ideas? Josh Berkus
15:33 Re: Displaying two tables side by side Rod Taylor
16:23 Re: Displaying two tables side by side David Garamond
16:32 Re: reply to setting Bruno Wolff III
16:48 Re: sleep function John DeSoi
17:19 Fwd: Inserts with incomplete rows... NOT NULL constraints Lars Erik Thorsplass
17:21 Wierd Error on update Thomas Seeber
17:41 Re: Displaying two tables side by side Gaetano Mendola
17:47 Re: reply to setting Joe Conway
18:18 Re: reply to setting Rod Taylor
19:19 Re: Wierded error in recursive function; debugging ideas? Joe Conway
19:48 Re: Wierd Error on update Tom Lane
19:52 Re: Wierded error in recursive function; debugging ideas? Josh Berkus
20:44 Re: UPDATE FROM problem, multiple updates of same row don't seem to work Bruno Wolff III
23:07 Re: reply to setting Bruno Wolff III
23:19 Re: UPDATE FROM problem, multiple updates of same row don't seem to work Bruno Wolff III

12 August 2004

04:35 Re: function expression in FROM may not refer to other relations of same query level Philippe Lang
04:59 Maybe install debian on your home pc? Stef
05:00 Inserting into point[] type. Theo Galanakis
05:01 Re: Maybe install debian on your home pc? Stef
05:27 Re: Inserting into point[] type. Markus Bertheau
11:23 Sending errors from psql to error file Devin Whalen
11:32 Re: function expression in FROM may not refer to other relations of same query level Tom Lane
12:03 Re: Sending errors from psql to error file Richard Huxton
12:05 Re: Sending errors from psql to error file Devin Whalen
12:24 Re: Sending errors from psql to error file Oliver Elphick
12:33 how to cast localtimestamp to bigint??? Pradeepkumar, Pyatalo (IE10)
12:36 Re: function expression in FROM may not refer to other relations Stephan Szabo
13:31 Re: Sending errors from psql to error file Oliver Elphick
16:13 Re: Sending errors from psql to error file Devin Whalen

13 August 2004

05:53 Re: function expression in FROM may not refer to other relations of same query level Philippe Lang
13:33 Re: Wierd Error on update Thomas Seeber
15:47 Re: Wierd Error on update Tom Lane
16:04 Re: [PERFORM] Performance Problem With Postgresql! Josh Berkus

15 August 2004

15:07 Re: UNIQUE constraint Sascha Ziemann
15:09 LIKE '%%' does not return NULL Traci Sumpter
15:09 Re: Sum and count weird results Michalis Kabrianis
15:11 COMMENT ON CONSTRAINT Sascha Ziemann
15:11 Returning A Varchar From A Function Richard Hurst
15:27 duplicate table in two databases Fabio Ferrero
15:29 Re: Sending errors from psql to error file Oliver Elphick
15:29 Performance Problem With Postgresql! Arash Zaryoun
15:29 Getting points from polygon albrechtt@inseal.de (Sebastian Albrecht)
15:31 Re: Wierd Error on update Pentilian
15:31 Re: Suggestions on storing re-occurring calendar events jcelko212@earthlink.net (--CELKO--)
15:31 Re: tablefunc's in 8.0 Beta Win32 - where? Thomas Wegner
15:31 tablefunc's in 8.0 Beta Win32 - where? Thomas Wegner
15:56 Re: LIKE '%%' does not return NULL Stephan Szabo
16:18 Re: LIKE '%%' does not return NULL Frank Finner
16:43 Re: Getting points from polygon Tom Lane
20:48 CROSS-TAB query help? I have read it cant be done in one SQL, pro ve them wrong! Theo Galanakis
22:03 Re: COMMENT ON CONSTRAINT Andreas Seltenreich

16 August 2004

04:12 Inheriting text[] field Kaloyan Iliev Iliev
05:01 Re: duplicate table in two databases Richard Huxton
05:06 Re: CROSS-TAB query help? I have read it cant be done in one Richard Huxton
09:49 Re: Returning A Varchar From A Function George Weaver
11:30 Re: Inheriting text[] field Tom Lane
11:44 SQL_ASCII and UNICODE server_encoding Achilleus Mantzios
12:04 Re: SQL_ASCII and UNICODE server_encoding Tom Lane
12:29 Re: SQL_ASCII and UNICODE server_encoding Achilleus Mantzios
17:16 any chance SQL ASSERTIONS will be implemented? Markus Bertheau
17:42 Re: any chance SQL ASSERTIONS will be implemented? Peter Eisentraut
18:16 Verifying data type Elieser Leão
20:30 Re: Verifying data type Tom Lane
23:49 Re: CROSS-TAB query help? I have read it cant be done in on Theo Galanakis

17 August 2004

06:25 multi column foreign key for implicitly unique columns Markus Bertheau
06:39 Re: multi column foreign key for implicitly unique columns Oliver Elphick
06:48 Re: CROSS-TAB query help? I have read it cant be done in on Richard Huxton
06:50 Re: multi column foreign key for implicitly unique columns Markus Bertheau
06:52 Re: multi column foreign key for implicitly unique columns Richard Huxton
07:44 only last records in subgroups Dino Vliet
08:07 SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau
09:22 Re: only last records in subgroups Achilleus Mantzios
10:23 Re: Inheriting text[] field Kaloyan Iliev Iliev
10:49 Re: Verifying data type Elieser Leão
11:04 Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III
11:21 Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau
11:24 Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance
11:26 Re: multi column foreign key for implicitly unique columns Stephan Szabo
11:46 Re: multi column foreign key for implicitly unique columns Tom Lane
11:51 Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau
11:57 Re: multi column foreign key for implicitly unique columns Markus Bertheau
12:06 Re: multi column foreign key for implicitly unique columns Stephan Szabo
12:09 Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Stephan Szabo
12:12 Re: multi column foreign key for implicitly unique columns Markus Bertheau
12:25 Re: multi column foreign key for implicitly unique columns Stephan Szabo
12:38 Re: multi column foreign key for implicitly unique columns Tom Lane
12:52 Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance
14:23 Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III
23:46 Re: multi column foreign key for implicitly unique columns Josh Berkus
23:56 SQL Challenge: Arbitrary Cross-tab Josh Berkus

18 August 2004

00:21 Re: SQL Challenge: Arbitrary Cross-tab elein
00:36 Re: SQL Challenge: Arbitrary Cross-tab Stephan Szabo
00:36 Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane
00:42 Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus
02:16 Re: SQL Challenge: Arbitrary Cross-tab Joe Conway
03:00 Re: multi column foreign key for implicitly unique columns Markus Bertheau
03:14 Theo Galanakis
08:12 Re: SQL Challenge: Arbitrary Cross-tab Gaetano Mendola
08:47 Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane
10:33 Re: multi column foreign key for implicitly unique columns Jan Wieck
10:57 Re: multi column foreign key for implicitly unique columns Markus Bertheau
11:07 Re: multi column foreign key for implicitly unique columns Jan Wieck
11:29 Re: multi column foreign key for implicitly unique columns Markus Bertheau
11:38 Re: multi column foreign key for implicitly unique columns Stephan Szabo
12:12 Re: SQL Challenge: Arbitrary Cross-tab Gaetano Mendola
12:13 Re: SQL Challenge: Arbitrary Cross-tab Tom Lane
12:17 Re: multi column foreign key for implicitly unique columns Tom Lane
12:30 /contrib and win32 Bruce Momjian
12:45 Re: multi column foreign key for implicitly unique columns Rod Taylor
13:02 Re: multi column foreign key for implicitly unique columns Richard Huxton
13:14 Re: SQL Challenge: Arbitrary Cross-tab Chris Travers
13:18 Re: multi column foreign key for implicitly unique columns Tom Lane
13:27 Re: multi column foreign key for implicitly unique columns Jan Wieck
13:46 Re: multi column foreign key for implicitly unique columns Rod Taylor
13:51 Re: multi column foreign key for implicitly unique columns Tom Lane
13:57 Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus
14:06 Re: multi column foreign key for implicitly unique columns Josh Berkus
14:45 Re: multi column foreign key for implicitly unique columns Stephan Szabo
14:49 Re: multi column foreign key for implicitly unique columns Richard Huxton
14:54 Re: SQL Challenge: Arbitrary Cross-tab Joe Conway
15:02 Re: multi column foreign key for implicitly unique columns Jan Wieck
15:52 Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus
15:55 Re: multi column foreign key for implicitly unique columns Josh Berkus
16:16 Re: multi column foreign key for implicitly unique columns Bruno Wolff III
16:35 Re: multi column foreign key for implicitly unique columns Josh Berkus
19:31 Re: Theo Galanakis
19:33 Re: multi column foreign key for implicitly unique columns Jan Wieck
22:12 Function Issue! Theo Galanakis
22:36 Re: Function Issue! Tom Lane

19 August 2004

13:23 Re: multi column foreign key for implicitly unique columns Josh Berkus
13:52 Re: multi column foreign key for implicitly unique columns Oliver Elphick
18:41 Re: multi column foreign key for implicitly unique columns Jan Wieck
23:16 Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane

20 August 2004

00:25 Re: SQL Challenge: Arbitrary Cross-tab Tom Lane
04:54 Re: multi column foreign key for implicitly unique columns Richard Huxton
12:05 Re: multi column foreign key for implicitly unique columns Stephan Szabo
12:20 Problems importing data Devin Whalen
13:37 olympics ranking query David Garamond
13:46 Re: olympics ranking query Tom Lane
13:53 Re: olympics ranking query Bruno Wolff III
14:09 Re: olympics ranking query David Garamond
14:21 Re: olympics ranking query Tom Lane
14:25 Re: olympics ranking query David Garamond

21 August 2004

21:42 disable constrained (contd.) Roman Kunert

22 August 2004

16:58 Re: reply to setting Greg Stark
23:59 pg_dump/pg_restore question Worik

23 August 2004

00:52 Re: sleep function Greg Stark
01:09 Re: only last records in subgroups Greg Stark
01:58 Re: pg_dump/pg_restore question Iain
04:56 Re: pg_dump/pg_restore question Richard Huxton
08:46 array_in: '{}}'::text[] Markus Bertheau
08:50 Re: array_in: '{}}'::text[] Markus Bertheau
08:52 Re: disable constrained (contd.) Markus Bertheau
10:37 Re: sleep function John DeSoi
12:13 TSearch2 other languages Cavit Keskin
15:32 Re: array_in: '{}}'::text[] Joe Conway
18:06 Re: reply to setting Joe Conway
22:17 Re: TSearch2 other languages Josh Berkus

24 August 2004

02:23 Re: surrogate key or not? sad
04:42 Disable trigger with Postgresql 7.4.x? Philippe Lang
05:39 stored procedures and type of returned result. Patrice OLIVER
06:26 Re: stored procedures and type of returned result. Richard Huxton
06:56 Re: stored procedures and type of returned result. Philippe Lang
07:41 Re: stored procedures and type of returned result. Richard Huxton
08:20 Re: Disable trigger with Postgresql 7.4.x? Bruce Momjian
16:33 Possible rounding error of large float values? Adam Lancaster
16:52 Re: Possible rounding error of large float values? Josh Berkus
17:21 Re: Possible rounding error of large float values? Oliver Elphick
21:39 Re: Possible rounding error of large float values? Jan Wieck
22:32 Re: Possible rounding error of large float values? Iain
22:41 Re: Possible rounding error of large float values? Stephan Szabo
23:48 Re: Possible rounding error of large float values? Iain

25 August 2004

11:21 PQexec and SPI_exec Pedro B.
11:53 Re: PQexec and SPI_exec Jan Wieck
14:04 Complicated "group by" question Andrew Perrin
14:47 Re: Complicated "group by" question Josh Berkus
14:53 Re: Complicated "group by" question Jean-Luc Lachance
15:21 Re: Complicated "group by" question Andrew Perrin
22:10 problem with RULE Sreten Milosavljevic
22:10 view triggers/procedures SVGK, Raju (Raju)
22:10 Re: olympics ranking query Mischa Sandberg
22:10 help with scheme changes to live system. Tony Yang
22:20 ERROR: Invalid regular expression: parentheses ( ) not balanced Kathrine S
22:20 CREATE TYPE VARCHAR2 Sascha Ziemann
22:28 refer to computed columns Bruno Mueller
22:32 Optimizer Selecting Incorrect Index David Price
23:07 Re: CREATE TYPE VARCHAR2 Tom Lane
23:21 Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Tom Lane
23:43 Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Adrian Klaver
23:57 Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Tom Lane

26 August 2004

03:23 Aggregate query for multiple records Scott Gerhardt
07:04 from PG_DUMP to CVS Riccardo G. Facchini
07:32 Re: from PG_DUMP to CVS Philip Warner
07:42 Re: from PG_DUMP to CVS Riccardo G. Facchini
08:19 Re: from PG_DUMP to CVS Philip Warner
08:32 Re: from PG_DUMP to CVS Kenneth Gonsalves
08:48 Re: from PG_DUMP to CVS Riccardo G. Facchini
09:04 Re: from PG_DUMP to CVS Riccardo G. Facchini
10:07 Problem with stored procedure Patrice OLIVER
10:07 Auto-update script from dumps? Joerg Hessdoerfer
10:31 Re: Problem with stored procedure Richard Huxton
11:59 Re: Problem with stored procedure Antonis Antoniou
14:06 Re: from PG_DUMP to CVS Greg Stark
18:12 Pb with insert statement Patrice OLIVER

27 August 2004

01:38 Re: from PG_DUMP to CVS Josh Berkus
01:56 Re: Aggregate query for multiple records Josh Berkus
04:35 backup of a specific schema Kenneth Gonsalves
04:53 Re: backup of a specific schema Riccardo G. Facchini
06:32 Re: Aggregate query for multiple records Troy
08:13 Re: backup of a specific schema Kenneth Gonsalves
08:15 Re: from PG_DUMP to CVS Philip Warner
10:03 GRANT ON all tables Nosyman
10:06 Re: from PG_DUMP to CVS Riccardo G. Facchini
12:44 Re: Aggregate query for multiple records Josh Berkus
13:02 Re: from PG_DUMP to CVS Josh Berkus
16:00 Re: Aggregate query for multiple records Josh Berkus
16:11 Re: GRANT ON all tables Bruno Wolff III
16:35 Re: help with trigger Dino Vliet
17:16 Copy command freezes but INSERT works fine with trigger on insert. Artimenko Igor
17:30 Re: Copy command freezes but INSERT works fine with trigger oninsert. Gregory S. Williamson
17:53 Re: Copy command freezes but INSERT works fine with trigger on insert. Artimenko Igor
18:33 Re: [PERFORM] Why those queries do not utilize indexes? Artimenko Igor
23:33 Re: backup of a specific schema Gaetano Mendola

28 August 2004

05:36 Re: Aggregate query for multiple records Greg Stark
09:48 Re: backup of a specific schema Gaetano Mendola
13:10 Re: from PG_DUMP to CVS Philip Warner
13:19 Re: Aggregate query for multiple records Tom Lane
15:09 Re: Aggregate query for multiple records Scott Gerhardt

29 August 2004

01:43 Re: backup of a specific schema Kenneth Gonsalves
02:21 Re: Aggregate query for multiple records Josh Berkus
08:20 Re: backup of a specific schema Gaetano Mendola
12:17 expression_tree_walker: Unexpected node type 711 Ian Percival
12:17 Abwesenheitsnotiz: approved document Gerdes, Heino
13:26 Re: expression_tree_walker: Unexpected node type 711 Tom Lane

30 August 2004

14:17 function fails where individual statements succeed Rosser Schwarz
15:34 Re: function fails where individual statements succeed Rosser Schwarz
17:33 Re: function fails where individual statements succeed Tom Lane
17:40 Re: function fails where individual statements succeed Rosser Schwarz
18:03 Re: function fails where individual statements succeed Tom Lane
19:12 Re: function fails where individual statements succeed Rosser Schwarz

31 August 2004

06:57 casting BOOL to somthng sad
07:13 Re: casting BOOL to somthng Michael Glaesemann
08:52 colored PL with emacs Martin Marques
08:53 Arbitrary precision arithmatic with pgsql Rajesh Kumar Mallah
09:11 Re: colored PL with emacs Stephen Quinney
09:15 Re: casting BOOL to somthng sad
09:18 Re: Arbitrary precision arithmatic with pgsql Michael Glaesemann
09:22 Re: casting BOOL to somthng Geoffrey
09:34 Re: colored PL with emacs Martin Marques
09:35 Re: Arbitrary precision arithmatic with pgsql Rajesh Kumar Mallah
09:41 Re: Arbitrary precision arithmatic with pgsql Michael Glaesemann
10:13 Re: Arbitrary precision arithmatic with pgsql Rajesh Kumar Mallah
10:49 Re: casting BOOL to somthng Michael Glaesemann
11:18 Re: Arbitrary precision arithmatic with pgsql Jan Wieck
11:27 Re: Arbitrary precision arithmatic with pgsql Michael Glaesemann
12:04 Re: Arbitrary precision arithmatic with pgsql Tom Lane
12:13 Re: Arbitrary precision arithmatic with pgsql Jan Wieck
14:29 Re: colored PL with emacs Manuel Sugawara
19:31 Re: colored PL with emacs Josh Berkus
20:19 Re: colored PL with emacs Greg Sabino Mullane