Mailing lists [pgsql-sql]
- Need help form inherits Patrice OLIVER
- Re: How to create an aggregate? Greg Stark
- Help on triggers Pradeepkumar, Pyatalo (IE10)
- error in compiling the function -- need help !!! Pradeepkumar, Pyatalo (IE10)
- org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) Smita Marda
- Re: How to create an aggregate? Ray Aspeitia
- Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev
- Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev
- Re: Problems with UNION ALL and ORDER BY Tom Lane
- Re: Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev
- Re: Problems with UNION ALL and ORDER BY Gaetano Mendola
- Re: Problems with UNION ALL and ORDER BY Tom Lane
- Problems with UNION ALL and ORDER BY Kaloyan Iliev Iliev
- Re: org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143) Kris Jurka
- Query execution differences Ray Aspeitia
- Trigger and function not on speaking terms Jeff Boes
- Re: Trigger and function not on speaking terms Richard Poole
- Re: Trigger and function not on speaking terms Stephan Szabo
- Datetime Pedro B.
- Re: Datetime Michael Glaesemann
- Re: Datetime Devrim GUNDUZ
- Re: Datetime Achilleus Mantzios
- Re: Datetime Michael Glaesemann
- Re: Datetime Achilleus Mantzios
- Re: Datetime Michael Glaesemann
- Re: Datetime Tom Lane
- Re: Datetime Michael Glaesemann
- Re: Datetime Tom Lane
- Re: Datetime Michael Glaesemann
- contrib/tablefunc crosstab Caleb Simonyi-Gindele
- Re: contrib/tablefunc crosstab Joe Conway
- Sum and count weird results Michalis Kabrianis
- Re: Trigger and function not on speaking terms Kevin Davis
- SQL syntax extentions - to put postgres ahead in the race Ram Nathaniel
- Re: SQL syntax extentions - to put postgres ahead in the race Stephan Szabo
- Re: SQL syntax extentions - to put postgres ahead in the race Tom Lane
- retrieve the tables names based on the owner Antonis Antoniou
- Re: retrieve the tables names based on the owner Achilleus Mantzios
- Re: SQL syntax extentions - to put postgres ahead in the race Tom Lane
- Make a column case insensitive Gordon Ross
- New PHP + PostgreSQL group on Google Groups2 dguarneri@satx.rr.com (N. David)
- Grouping by week Caleb Simonyi-Gindele
- Re: Grouping by week Oliver Elphick
- Re: surrogate key or not? Josh Berkus
- Re: Grouping by week Tom Lane
- Re: surrogate key or not? Kenneth Gonsalves
- reply to setting Kenneth Gonsalves
- Re: reply to setting Tom Lane
- Re: surrogate key or not? Oliver Elphick
- Re: surrogate key or not? Kenneth Gonsalves
- Re: Make a column case insensitive Rod Taylor
- Re: Make a column case insensitive Thomas Wegner
- UNIQUE constraint Sascha Ziemann
- select Knut P Lehre
- Re: UNIQUE constraint Michael Glaesemann
- Re: surrogate key or not? Josh Berkus
- Re: Make a column case insensitive Jan Wieck
- Re: Make a column case insensitive Pierre-Frédéric Caillaud
- Re: Make a column case insensitive Tom Lane
- Re: select Christoph Haller
- Suggestions on storing re-occurring calendar events Matt Nuzum
- Exception handling from trigger Vlad Dimitriu
- Re: Exception handling from trigger Rod Taylor
- Re: Exception handling from trigger Tom Lane
- Re: surrogate keys and replication. Josh Berkus
- Re: Exception handling from trigger Vlad Dimitriu
- Re: Suggestions on storing re-occurring calendar events Josh Berkus
- Re: Exception handling from trigger Vlad Dimitriu
- UPDATE FROM problem, multiple updates of same row don't seem to work David Stanaway
- function expression in FROM may not refer to other relations of same query level Philippe Lang
- Re: Stored procedures and "pseudo" fields Christoph Haller
- sleep function John DeSoi
- Re: sleep function Bruce Momjian
- Re: function expression in FROM may not refer to other relations Joe Conway
- ERROR: Cross-database references are not implemented Theo Galanakis
- Re: ERROR: Cross-database references are not implemented Joe Conway
- Re: ERROR: Cross-database references are not implemented - Theo Galanakis
- Wierded error in recursive function; debugging ideas? Josh Berkus
- Re: Wierded error in recursive function; debugging ideas? Joe Conway
- Re: function expression in FROM may not refer to other relations of same query level Philippe Lang
- Re: function expression in FROM may not refer to other relations of same query level Philippe Lang
- Inserts with incomplete rows... NOT NULL constraints Lars Erik Thorsplass
- Re: Inserts with incomplete rows... NOT NULL constraints Peter Eisentraut
- Re: Inserts with incomplete rows... NOT NULL constraints Richard Huxton
- Displaying two tables side by side David Garamond
- Re: function expression in FROM may not refer to other relations of same query level Rosser Schwarz
- Re: Displaying two tables side by side Andreas Haumer
- Re: Displaying two tables side by side Michael Kleiser
- Re: Wierded error in recursive function; debugging ideas? Josh Berkus
- Re: Displaying two tables side by side Rod Taylor
- Re: Displaying two tables side by side David Garamond
- Re: reply to setting Bruno Wolff III
- Re: sleep function John DeSoi
- Fwd: Inserts with incomplete rows... NOT NULL constraints Lars Erik Thorsplass
- Wierd Error on update Thomas Seeber
- Re: Displaying two tables side by side Gaetano Mendola
- Re: reply to setting Joe Conway
- Re: reply to setting Rod Taylor
- Re: Wierded error in recursive function; debugging ideas? Joe Conway
- Re: Wierd Error on update Tom Lane
- Re: Wierded error in recursive function; debugging ideas? Josh Berkus
- Re: UPDATE FROM problem, multiple updates of same row don't seem to work Bruno Wolff III
- Re: reply to setting Bruno Wolff III
- Re: UPDATE FROM problem, multiple updates of same row don't seem to work Bruno Wolff III
- Re: function expression in FROM may not refer to other relations of same query level Philippe Lang
- Maybe install debian on your home pc? Stef
- Inserting into point[] type. Theo Galanakis
- Re: Maybe install debian on your home pc? Stef
- Re: Inserting into point[] type. Markus Bertheau
- Sending errors from psql to error file Devin Whalen
- Re: function expression in FROM may not refer to other relations of same query level Tom Lane
- Re: Sending errors from psql to error file Richard Huxton
- Re: Sending errors from psql to error file Devin Whalen
- Re: Sending errors from psql to error file Oliver Elphick
- how to cast localtimestamp to bigint??? Pradeepkumar, Pyatalo (IE10)
- Re: function expression in FROM may not refer to other relations Stephan Szabo
- Re: Sending errors from psql to error file Oliver Elphick
- Re: Sending errors from psql to error file Devin Whalen
- Re: function expression in FROM may not refer to other relations of same query level Philippe Lang
- Re: Wierd Error on update Thomas Seeber
- Re: Wierd Error on update Tom Lane
- Re: [PERFORM] Performance Problem With Postgresql! Josh Berkus
- Re: UNIQUE constraint Sascha Ziemann
- LIKE '%%' does not return NULL Traci Sumpter
- Re: Sum and count weird results Michalis Kabrianis
- COMMENT ON CONSTRAINT Sascha Ziemann
- Returning A Varchar From A Function Richard Hurst
- duplicate table in two databases Fabio Ferrero
- Re: Sending errors from psql to error file Oliver Elphick
- Performance Problem With Postgresql! Arash Zaryoun
- Getting points from polygon albrechtt@inseal.de (Sebastian Albrecht)
- Re: Wierd Error on update Pentilian
- Re: Suggestions on storing re-occurring calendar events jcelko212@earthlink.net (--CELKO--)
- Re: tablefunc's in 8.0 Beta Win32 - where? Thomas Wegner
- tablefunc's in 8.0 Beta Win32 - where? Thomas Wegner
- Re: LIKE '%%' does not return NULL Stephan Szabo
- Re: LIKE '%%' does not return NULL Frank Finner
- Re: Getting points from polygon Tom Lane
- CROSS-TAB query help? I have read it cant be done in one SQL, pro ve them wrong! Theo Galanakis
- Re: COMMENT ON CONSTRAINT Andreas Seltenreich
- Inheriting text[] field Kaloyan Iliev Iliev
- Re: duplicate table in two databases Richard Huxton
- Re: CROSS-TAB query help? I have read it cant be done in one Richard Huxton
- Re: Returning A Varchar From A Function George Weaver
- Re: Inheriting text[] field Tom Lane
- SQL_ASCII and UNICODE server_encoding Achilleus Mantzios
- Re: SQL_ASCII and UNICODE server_encoding Tom Lane
- Re: SQL_ASCII and UNICODE server_encoding Achilleus Mantzios
- any chance SQL ASSERTIONS will be implemented? Markus Bertheau
- Re: any chance SQL ASSERTIONS will be implemented? Peter Eisentraut
- Verifying data type Elieser Leão
- Re: Verifying data type Tom Lane
- Re: CROSS-TAB query help? I have read it cant be done in on Theo Galanakis
- multi column foreign key for implicitly unique columns Markus Bertheau
- Re: multi column foreign key for implicitly unique columns Oliver Elphick
- Re: CROSS-TAB query help? I have read it cant be done in on Richard Huxton
- Re: multi column foreign key for implicitly unique columns Markus Bertheau
- Re: multi column foreign key for implicitly unique columns Richard Huxton
- only last records in subgroups Dino Vliet
- SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau
- Re: only last records in subgroups Achilleus Mantzios
- Re: Inheriting text[] field Kaloyan Iliev Iliev
- Re: Verifying data type Elieser Leão
- Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III
- Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau
- Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance
- Re: multi column foreign key for implicitly unique columns Stephan Szabo
- Re: multi column foreign key for implicitly unique columns Tom Lane
- Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Markus Bertheau
- Re: multi column foreign key for implicitly unique columns Markus Bertheau
- Re: multi column foreign key for implicitly unique columns Stephan Szabo
- Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Stephan Szabo
- Re: multi column foreign key for implicitly unique columns Markus Bertheau
- Re: multi column foreign key for implicitly unique columns Stephan Szabo
- Re: multi column foreign key for implicitly unique columns Tom Lane
- Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Jean-Luc Lachance
- Re: SELECT MAX(c) FROM (SELECT ... FOR UPDATE) AS foo Bruno Wolff III
- Re: multi column foreign key for implicitly unique columns Josh Berkus
- SQL Challenge: Arbitrary Cross-tab Josh Berkus
- Re: SQL Challenge: Arbitrary Cross-tab elein
- Re: SQL Challenge: Arbitrary Cross-tab Stephan Szabo
- Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane
- Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus
- Re: SQL Challenge: Arbitrary Cross-tab Joe Conway
- Re: multi column foreign key for implicitly unique columns Markus Bertheau
- Theo Galanakis
- Re: SQL Challenge: Arbitrary Cross-tab Gaetano Mendola
- Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane
- Re: multi column foreign key for implicitly unique columns Jan Wieck
- Re: multi column foreign key for implicitly unique columns Markus Bertheau
- Re: multi column foreign key for implicitly unique columns Jan Wieck
- Re: multi column foreign key for implicitly unique columns Markus Bertheau
- Re: multi column foreign key for implicitly unique columns Stephan Szabo
- Re: SQL Challenge: Arbitrary Cross-tab Gaetano Mendola
- Re: SQL Challenge: Arbitrary Cross-tab Tom Lane
- Re: multi column foreign key for implicitly unique columns Tom Lane
- /contrib and win32 Bruce Momjian
- Re: multi column foreign key for implicitly unique columns Rod Taylor
- Re: multi column foreign key for implicitly unique columns Richard Huxton
- Re: SQL Challenge: Arbitrary Cross-tab Chris Travers
- Re: multi column foreign key for implicitly unique columns Tom Lane
- Re: multi column foreign key for implicitly unique columns Jan Wieck
- Re: multi column foreign key for implicitly unique columns Rod Taylor
- Re: multi column foreign key for implicitly unique columns Tom Lane
- Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus
- Re: multi column foreign key for implicitly unique columns Josh Berkus
- Re: multi column foreign key for implicitly unique columns Stephan Szabo
- Re: multi column foreign key for implicitly unique columns Richard Huxton
- Re: SQL Challenge: Arbitrary Cross-tab Joe Conway
- Re: multi column foreign key for implicitly unique columns Jan Wieck
- Re: SQL Challenge: Arbitrary Cross-tab Josh Berkus
- Re: multi column foreign key for implicitly unique columns Josh Berkus
- Re: multi column foreign key for implicitly unique columns Bruno Wolff III
- Re: multi column foreign key for implicitly unique columns Josh Berkus
- Re: Theo Galanakis
- Re: multi column foreign key for implicitly unique columns Jan Wieck
- Function Issue! Theo Galanakis
- Re: Function Issue! Tom Lane
- Re: multi column foreign key for implicitly unique columns Josh Berkus
- Re: multi column foreign key for implicitly unique columns Oliver Elphick
- Re: multi column foreign key for implicitly unique columns Jan Wieck
- Re: SQL Challenge: Arbitrary Cross-tab Greg Sabino Mullane
- Re: SQL Challenge: Arbitrary Cross-tab Tom Lane
- Re: multi column foreign key for implicitly unique columns Richard Huxton
- Re: multi column foreign key for implicitly unique columns Stephan Szabo
- Problems importing data Devin Whalen
- olympics ranking query David Garamond
- Re: olympics ranking query Tom Lane
- Re: olympics ranking query Bruno Wolff III
- Re: olympics ranking query David Garamond
- Re: olympics ranking query Tom Lane
- Re: olympics ranking query David Garamond
- disable constrained (contd.) Roman Kunert
- Re: reply to setting Greg Stark
- pg_dump/pg_restore question Worik
- Re: sleep function Greg Stark
- Re: only last records in subgroups Greg Stark
- Re: pg_dump/pg_restore question Iain
- Re: pg_dump/pg_restore question Richard Huxton
- array_in: '{}}'::text[] Markus Bertheau
- Re: array_in: '{}}'::text[] Markus Bertheau
- Re: disable constrained (contd.) Markus Bertheau
- Re: sleep function John DeSoi
- TSearch2 other languages Cavit Keskin
- Re: array_in: '{}}'::text[] Joe Conway
- Re: reply to setting Joe Conway
- Re: TSearch2 other languages Josh Berkus
- Re: surrogate key or not? sad
- Disable trigger with Postgresql 7.4.x? Philippe Lang
- stored procedures and type of returned result. Patrice OLIVER
- Re: stored procedures and type of returned result. Richard Huxton
- Re: stored procedures and type of returned result. Philippe Lang
- Re: stored procedures and type of returned result. Richard Huxton
- Re: Disable trigger with Postgresql 7.4.x? Bruce Momjian
- Possible rounding error of large float values? Adam Lancaster
- Re: Possible rounding error of large float values? Josh Berkus
- Re: Possible rounding error of large float values? Oliver Elphick
- Re: Possible rounding error of large float values? Jan Wieck
- Re: Possible rounding error of large float values? Iain
- Re: Possible rounding error of large float values? Stephan Szabo
- Re: Possible rounding error of large float values? Iain
- PQexec and SPI_exec Pedro B.
- Re: PQexec and SPI_exec Jan Wieck
- Complicated "group by" question Andrew Perrin
- Re: Complicated "group by" question Josh Berkus
- Re: Complicated "group by" question Jean-Luc Lachance
- Re: Complicated "group by" question Andrew Perrin
- problem with RULE Sreten Milosavljevic
- view triggers/procedures SVGK, Raju (Raju)
- Re: olympics ranking query Mischa Sandberg
- help with scheme changes to live system. Tony Yang
- ERROR: Invalid regular expression: parentheses ( ) not balanced Kathrine S
- CREATE TYPE VARCHAR2 Sascha Ziemann
- refer to computed columns Bruno Mueller
- Optimizer Selecting Incorrect Index David Price
- Re: CREATE TYPE VARCHAR2 Tom Lane
- Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Tom Lane
- Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Adrian Klaver
- Re: ERROR: Invalid regular expression: parentheses ( ) not balanced Tom Lane
- Aggregate query for multiple records Scott Gerhardt
- from PG_DUMP to CVS Riccardo G. Facchini
- Re: from PG_DUMP to CVS Philip Warner
- Re: from PG_DUMP to CVS Riccardo G. Facchini
- Re: from PG_DUMP to CVS Philip Warner
- Re: from PG_DUMP to CVS Kenneth Gonsalves
- Re: from PG_DUMP to CVS Riccardo G. Facchini
- Re: from PG_DUMP to CVS Riccardo G. Facchini
- Problem with stored procedure Patrice OLIVER
- Auto-update script from dumps? Joerg Hessdoerfer
- Re: Problem with stored procedure Richard Huxton
- Re: Problem with stored procedure Antonis Antoniou
- Re: from PG_DUMP to CVS Greg Stark
- Pb with insert statement Patrice OLIVER
- Re: from PG_DUMP to CVS Josh Berkus
- Re: Aggregate query for multiple records Josh Berkus
- backup of a specific schema Kenneth Gonsalves
- Re: backup of a specific schema Riccardo G. Facchini
- Re: Aggregate query for multiple records Troy
- Re: backup of a specific schema Kenneth Gonsalves
- Re: from PG_DUMP to CVS Philip Warner
- GRANT ON all tables Nosyman
- Re: from PG_DUMP to CVS Riccardo G. Facchini
- Re: Aggregate query for multiple records Josh Berkus
- Re: from PG_DUMP to CVS Josh Berkus
- Re: Aggregate query for multiple records Josh Berkus
- Re: GRANT ON all tables Bruno Wolff III
- Re: help with trigger Dino Vliet
- Copy command freezes but INSERT works fine with trigger on insert. Artimenko Igor
- Re: Copy command freezes but INSERT works fine with trigger oninsert. Gregory S. Williamson
- Re: Copy command freezes but INSERT works fine with trigger on insert. Artimenko Igor
- Re: [PERFORM] Why those queries do not utilize indexes? Artimenko Igor
- Re: backup of a specific schema Gaetano Mendola
- Re: Aggregate query for multiple records Greg Stark
- Re: backup of a specific schema Gaetano Mendola
- Re: from PG_DUMP to CVS Philip Warner
- Re: Aggregate query for multiple records Tom Lane
- Re: Aggregate query for multiple records Scott Gerhardt
- Re: backup of a specific schema Kenneth Gonsalves
- Re: Aggregate query for multiple records Josh Berkus
- Re: backup of a specific schema Gaetano Mendola
- expression_tree_walker: Unexpected node type 711 Ian Percival
- Abwesenheitsnotiz: approved document Gerdes, Heino
- Re: expression_tree_walker: Unexpected node type 711 Tom Lane
- function fails where individual statements succeed Rosser Schwarz
- Re: function fails where individual statements succeed Rosser Schwarz
- Re: function fails where individual statements succeed Tom Lane
- Re: function fails where individual statements succeed Rosser Schwarz
- Re: function fails where individual statements succeed Tom Lane
- Re: function fails where individual statements succeed Rosser Schwarz
- casting BOOL to somthng sad
- Re: casting BOOL to somthng Michael Glaesemann
- colored PL with emacs Martin Marques
- Arbitrary precision arithmatic with pgsql Rajesh Kumar Mallah
- Re: colored PL with emacs Stephen Quinney
- Re: casting BOOL to somthng sad
- Re: Arbitrary precision arithmatic with pgsql Michael Glaesemann
- Re: casting BOOL to somthng Geoffrey
- Re: colored PL with emacs Martin Marques
- Re: Arbitrary precision arithmatic with pgsql Rajesh Kumar Mallah
- Re: Arbitrary precision arithmatic with pgsql Michael Glaesemann
- Re: Arbitrary precision arithmatic with pgsql Rajesh Kumar Mallah
- Re: casting BOOL to somthng Michael Glaesemann
- Re: Arbitrary precision arithmatic with pgsql Jan Wieck
- Re: Arbitrary precision arithmatic with pgsql Michael Glaesemann
- Re: Arbitrary precision arithmatic with pgsql Tom Lane
- Re: Arbitrary precision arithmatic with pgsql Jan Wieck
- Re: colored PL with emacs Manuel Sugawara
- Re: colored PL with emacs Josh Berkus
- Re: colored PL with emacs Greg Sabino Mullane