Mailing lists [pgsql-sql]
- Re: [PHP] a script that queries database periodically Jason
- Re: [PHP] a script that queries database periodically Folke Ashberg
- Re: [HACKERS] Re: Rules with Conditions: Bug, or Misunderstanding Mark Hollomon
- Help with Procedures in pgsql Nelio Alves Pereira Filho
- Re: [HACKERS] Re: Rules with Conditions: Bug, or Misunderstanding Tom Lane
- Re: Help with Procedures in pgsql Robert B. Easter
- How to identify connected Users? Jens Hartwig
- arhiving rule A. Van Hook
- Re: arhiving rule Tom Lane
- Re: Rules with Conditions: Bug, or Misunderstanding Joel Burton
- Re: Rules with Conditions: Bug, or Misunderstanding Tom Lane
- I can be a BUG? Edipo E. F. Melo
- Re: I can be a BUG? Tom Lane
- Re: I can be a BUG? Roberto Mello
- Re: I can be a BUG? Ross J. Reedstrom
- Re: I can be a BUG? Roberto Mello
- Re: I can be a BUG? Edipo E. F. Melo
- Re: subselects hubert depesz lubaczewski
- Re: Rules with Conditions: Bug, or Misunderstanding Jan Wieck
- Re: problem with keyword 'old' Jan Wieck
- Re: Rules with Conditions: Bug, or Misunderstanding Tom Lane
- Access Permissions/Security Rob Burne
- FW: Sharing Databases Yoghini Thevarajah
- Re: [PHP-DB] Re: a script that queries database periodically clayton cottingham
- Re: [PHP-DB] Re: a script that queries database periodically Jason
- rules on select - different output Marcin Mazurek
- how to execute a C program via trigger ? S.F. Lee
- SETOF Limin Shen
- Re: [GENERAL] Re: [PHP-DB] Re: a script that queries database periodically Dan Wilson
- Re: how to execute a C program via trigger ? clayton cottingham
- reinitialize a sequence? Bruno Boettcher
- reinitialize a sequence? Dan Lyke
- Re: reinitialize a sequence? Mike Castle
- Re: how to execute a C program via trigger ? S.F. Lee
- Join performance Koen Antonissen
- Re: reinitialize a sequence? Ross J. Reedstrom
- Using SELECT as DDL/DML statement is wrong (was RE: reinitialize a sequence?) Edmar Wiggers
- Re: reinitialize a sequence? Ross J. Reedstrom
- RE: Using SELECT as DDL/DML statement is wrong (was RE: rei nitialize a sequence?) Michael Ansley
- what's wrong with my plperl function? Bruno Boettcher
- RE: Using SELECT as DDL/DML statement is wrong (was RE: reinitialize a sequence?) Edmar Wiggers
- CallableStatement Shane McEneaney
- Re: what's wrong with my plperl function? Tom Lane
- Re: what's wrong with my plperl function? Bruno Boettcher
- Re: what's wrong with my plperl function? Bruno Boettcher
- CallableStatement Shane McEneaney
- pltcl problem rocael@usa.net
- Re: subselects Joseph Shraibman
- pltcl problem
- trying to pattern match to a value contained in a column Beth Gatewood
- RE: trying to pattern match to a value contained in a column Francis Solomon
- Re: trying to pattern match to a value contained in a column Peter Eisentraut
- Re: trying to pattern match to a value contained in a column Beth Gatewood
- postmaster restart error rocael@usa.net
- restart postmaster error rocael@usa.net
- Re: how to execute a C program via trigger ? Jie Liang
- Re: trying to pattern match to a value contained in a column Joel Burton
- Re: trying to pattern match to a value contained in a column Tom Lane
- Unable to convert null timestamp to date. Bug? Edmar Wiggers
- Re: trying to pattern match to a value contained in a column Ross J. Reedstrom
- Re: Unable to convert null timestamp to date. Bug? Tom Lane
- FOREIGN KEY errors. Joseph Shraibman
- subqueries as values in updates patrick.jacquot@anpe.fr
- RE: subqueries as values in updates Francis Solomon
- Re: FOREIGN KEY errors. Stephan Szabo
- plpgsql Jie Liang
- How to... W. van den Akker
- Re: How to... Joel Burton
- Re: "drop constraint trigger" on PostgreSQL Kyle
- Query optimisation Michel Vrand
- Where Can I find JDBC driver. Mateusz Mazur
- Re: Query optimisation Richard Huxton
- Re: FOREIGN KEY errors. Joseph Shraibman
- Peeter Smitt
- Re: Joseph Shraibman
- Re: Where Can I find JDBC driver. Robert B. Easter
- Re: plpgsql Kovacs Zoltan Sandor
- Re: Where Can I find JDBC driver. Peter T Mount
- SQL parse error Borek Lupoměský
- RE: SQL parse error Francis Solomon
- RE: SQL parse error Borek Lupoměský
- RE: SQL parse error Kenn Thompson
- Re: how to execute a C program via trigger ? Clayton Cottingham
- Foreign key constraint Sivagami .
- Fw: lo_import & lo_export Junaid Kalim
- SQL Query using time Karyn Keatley
- plpgsql feblec
- lo_import & lo_export Junaid Kalim
- HELP: can i have a trigger before postgres tries to check data types? Bruno Boettcher
- Re: Where Can I find JDBC driver. clayton cottingham
- Re: plpgsql Oliver Elphick
- Peeter Smitt
- Re: SQL Query using time Blaise Carrupt
- Re: plpgsql Mike Castle
- Plpgsql feblec
- Re: Foreign key constraint Jie Liang
- Re: plpgsql Jie Liang
- select ... for update Jie Liang
- Re: SQL parse error Borek Lupoměský
- Re: SQL parse error Tom Lane
- Re: Persistent Connects (pg_pconnect) Luca Pregliasco
- Decimal vs.Numeric vs. Int & type for OID Nikhil G. Daddikar
- Re: select ... for update Karel Zak
- Postgres closing the connection too fast with php4+apache bboett@erm1.u-strasbg.fr (Bruno Boettcher)
- Great thanks (JDBC). Another probem. Mateusz Mazur
- Date Format Daniel Hentges
- RE: Date Format Francis Solomon
- Re: SQL parse error Borek Lupoměský
- Re: Postgres closing the connection too fast with php4+apache Roberto Mello
- Re: SQL parse error Tom Lane
- How to represent a tree-structure in a relational database Frank Joerdens
- Strange slow behavior in backend Kyle
- Re: How to represent a tree-structure in a relational database Josh Berkus
- Selecting Most Recent Row Steve Meynell
- Re: How to represent a tree-structure in a relational database Mathijs Brands
- Re: SQL parse error Borek Lupoměský
- Re: How to represent a tree-structure in a relational database miguel sofer
- Re: Decimal vs.Numeric vs. Int & type for OID Peter Eisentraut
- Re: Selecting Most Recent Row Joel Burton
- Re: How to represent a tree-structure in a relational database Frank Joerdens
- Re: Selecting Most Recent Row Steve Meynell
- Re: How to represent a tree-structure in a relational database Frank Joerdens
- Re: How to represent a tree-structure in a relational database clayton cottingham
- Null comparison Al Lewis
- Query by sresultset.getArray(index) Frank Mingan You
- plpgsql Jie Liang
- RE: How to represent a tree-structure in a relational database Stuart Statman
- RE: How to represent a tree-structure in a relational database Stuart Statman
- Re: How to represent a tree-structure in a relational database Josh Berkus
- Re: Null comparison Stephan Szabo
- postgres Marc Daoust
- RE: How to represent a tree-structure in a relational database Stuart Statman
- Re: postgres Josh Berkus
- Re: postgres Brett W. McCoy
- Re: How to represent a tree-structure in a relational database Josh Berkus
- Re: How to represent a tree-structure in a relational database Mathijs Brands
- Re: postgres Joseph Shraibman
- Re: How to represent a tree-structure in a relational database Mathijs Brands
- RE: How to represent a tree-structure in a relational database Opec Kemp \( Ozemail \)
- Re: How to represent a tree-structure in a relational database clayton cottingham
- Re: postgres John Hasler
- Re: Strange slow behavior in backend Tom Lane
- Re: Null comparison Robert B. Easter
- Re: How to represent a tree-structure in a relational database Robert B. Easter
- How to insert/select date fields in a particular format Ramesh H R
- Re: postgres Roberto Mello
- arrays in PostgreSQL Kovacs Zoltan Sandor
- to_char() causes backend to close connection Kovacs Zoltan Sandor
- Re: to_char() causes backend to close connection Karel Zak
- Re: How to represent a tree-structure in a relational database Tulassay Zsolt
- Re: Strange slow behavior in backend Jan Wieck
- Re: Strange slow behavior in backend Jan Wieck
- Re: How to represent a tree-structure in a relational database hubert depesz lubaczewski
- Re: to_char() causes backend to close connection Kovacs Zoltan Sandor
- RE: to_char() causes backend to close connection Trewern, Ben
- pg_control error!
- Howto compile fti.c Franklin Vera
- Compiling "C" Functions Tulio Oliveira
- pg_control error!
- Re: How to represent a tree-structure in a relationaldatabase Alvar Freude
- Re: How to represent a tree-structure in a relationaldatabase Alvar Freude
- Re: Secure Messaging Non-Delivery Report: Re: How to represent a tree-structure in a relationaldatabase Alvar Freude
- Re: Secure Messaging Non-Delivery Report: Re: How to represent a tree-structure in a relationaldatabase Tom Lane
- Re: Secure Messaging Non-Delivery Report: Re: How to represent a tree-structure in a relationaldatabase The Hermit Hacker
- Re: Secure Messaging Non-Delivery Report: Re: How to representa tree-structure in a relationaldatabase Alvar Freude
- Re: How to represent a tree-structure in a relational database Tulassay Zsolt
- to_timestamp, problem Marcin Mazurek
- Re: to_timestamp, problem Karel Zak
- Re: How to represent a tree-structure in a relationaldatabase miguel sofer
- Confused by timezones Alessio Bragadini
- Re: Confused by timezones Karel Zak
- Re: Confused by timezones Alessio Bragadini
- readline ?? vs
- Re: [Re: postgres] Marc Daoust
- Re: Confused by timezones Tom Lane
- Re: Confused by timezones Tom Lane
- Re: [Re: postgres] Stephan Szabo
- Re: postgres Bruce Momjian
- Re: readline ?? Brett W. McCoy
- Re: full text index Artur Rataj
- Re: [Re: postgres] Bruce Momjian
- Use of indexes in plpgsql functions Graham Vickrage
- full text index Artur Rataj
- Use of indexes in plpgsql functions Graham Vickrage
- Re: Use of indexes in plpgsql functions Tom Lane
- Re: How to represent a tree-structure in a relationaldatabase Alvar Freude
- Documentation for CASE Albert REINER
- Re: Documentation for CASE Peter Eisentraut
- Re: Documentation for CASE Robert B. Easter
- Re: Documentation for CASE Albert REINER
- Subqueries in Non-SELECT Queries Frank Joerdens
- Re: Subqueries in Non-SELECT Queries Christof Glaser
- Re: Subqueries in Non-SELECT Queries Tom Lane
- PostgreSQL crashes on me :( Mathijs Brands
- Don't understand creation statement's answer Thomas SMETS
- Re: Don't understand creation statement's answer Mathijs Brands
- sql/database admin courses Dan Vanags
- RE: readline ?? Trewern, Ben
- Best database structure for timely ordered values Reiner Dassing
- Re: Subqueries in Non-SELECT Queries Frank Joerdens
- Re: Best database structure for timely ordered values Tom Lane
- Re: Confused by timezones Alessio Bragadini
- Re: Best database structure for timely ordered values Bruce Momjian
- Re: Best database structure for timely ordered values Reiner Dassing
- Re: Best database structure for timely ordered values Bruce Momjian
- Re: Best database structure for timely ordered values Reiner Dassing
- Re: Best database structure for timely ordered values Tom Lane
- Problem with function... jkakar@expressus.com
- Re: Problem with function... Michael Fork
- Tree structure table normalization problem (do I need a trigger?) Frank Joerdens
- Bounds checking on an alias jkakar@expressus.com
- RE: question on SELECT Howard Hiew
- question on SELECT Howard Hiew
- Re: Problem with function... Jie Liang
- Re: question on SELECT kumar1@home.com (Prasanth A. Kumar)
- Re: Tree structure table normalization problem (do I need a trigger?) Tulassay Zsolt
- replace?? bboett@erm1.u-strasbg.fr (Bruno Boettcher)
- Re: replace?? Brett W. McCoy
- Re: Tree structure table normalization problem (do I need atrigger?) Frank Joerdens
- Re: Tree structure table normalization problem (do I need atrigger?) Frank Joerdens
- SQL query not working when GROUP BY / HAVING is used juerg.rietmann@pup.ch
- Re: Tree structure table normalization problem (do I need atrigger?) Neil Thompson
- Re: Bounds checking on an alias Alessio Bragadini
- Re: SQL query not working when GROUP BY / HAVING is used Stephan Szabo
- Re: Tree structure table normalization problem (do I need a trigger?) Josh Berkus
- Re: Tree structure table normalization problem (do I need atrigger?) Tulassay Zsolt
- Re: Tree structure table normalization problem (do I need a trigger?) Frank Joerdens
- Create table doesn't work in plpgsql Volker Paul
- Re: SQL query not working when GROUP BY / HAVING is used Jie Liang
- Re: SQL query not working when GROUP BY / HAVING is used Jie Liang
- substring .. Jeff MacDonald
- Re: question on SELECT Jie Liang
- group by: properly? Emils Klotins
- RE: substring .. Francis Solomon
- Re: substring .. Stephan Szabo
- Re: substring .. Josh Berkus
- Re: substring .. Joel Burton
- Re: substring .. Tulio Oliveira
- Re: substring .. Robert B. Easter
- Re: substring .. Karel Zak
- how to alter/drop check contraint? hubert depesz lubaczewski
- Re: substring .. Jie Liang
- Re: Create table doesn't work in plpgsql Jie Liang
- How to set autocommit on/off Kevin
- plpgsql ? guard
- `~' operator and indices Artur Rataj
- Re: how to alter/drop check contraint? Stephan Szabo
- Re: plpgsql ? Kovacs Zoltan Sandor
- sorting the text values as integers Sandis Jerics
- Re: How to set autocommit on/off Jie Liang
- Re: plpgsql ? Jie Liang
- Re: `~' operator and indices Jie Liang
- Re: Don't understand creation statement's answer Christopher Sawtell
- test Kaare Rasmussen
- Invoice number Kaare Rasmussen
- Re: Create table doesn't work in plpgsql Volker Paul
- Re: Invoice number Volker Paul
- Re: Invoice number Mike Castle
- Re: Invoice number Josh Berkus
- Re: Create table doesn't work in plpgsql Mike Castle
- Re: Invoice number John Hasler
- Re: Invoice number Oliver Elphick
- Re: Create table doesn't work in plpgsql Jie Liang
- pg_dump Error Najm Hashmi
- Re: Invoice number Mike Castle
- Re: Invoice number Kaare Rasmussen
- Re: Invoice number John Hasler
- regcomp failed with error empty (sub)expression? Michael Miyabara-McCaskey
- Re: regcomp failed with error empty (sub)expression? Tom Lane
- Re: Invoice number George Moga
- Re: Create table doesn't work in plpgsql Volker Paul
- Re: pg_dump Error Tom Lane
- Re: Invoice number Stephan Szabo
- Re: Create table doesn't work in plpgsql Stephan Szabo
- Re: Create table doesn't work in plpgsql Keith Wong
- Fw: Optimization recommendations request Joe Conway
- Running a file Thomas SMETS
- Re: Invoice number darcy@druid.net (D'Arcy J.M. Cain)
- Re: Running a file Brett W. McCoy
- Re: Running a file Kaare Rasmussen
- Query Help Brian C. Doyle
- RE: Query Help Francis Solomon
- Re: Query Help Yury Don
- Re: Query Help patrick.jacquot@anpe.fr
- Strange Execution-Plan for NOT EXISTS Jens Hartwig
- Re: Query Help Brian C. Doyle
- Re: How to represent a tree-structure in a relational database Ron Peterson
- 7.1 feature? Kaare Rasmussen
- Re: 7.1 feature? Tom Lane
- rserv Ingram, Bryan
- MD5 use in PL/Perl Marc Rassbach
- Re: MD5 use in PL/Perl Peter Eisentraut
- How to trim values? jkakar@expressus.com
- Simultaneous Connection Problem Webb Sprague
- Re: How to trim values? Oliver Elphick
- Looking for comments Thomas SMETS
- ODBC Returns 0 records Dimitris Papadiotis
- system catalog info Ron Peterson
- Optimization recommendations request Joe Conway
- [ADMIN] Running a file Raju Mathur
- left join ? xyzii
- How to debug pgpsql functions Marcel Schaible
- Re: Optimization recommendations request Stephan Szabo
- Re: Optimization recommendations request Joe Conway
- Re: Optimization recommendations request Tom Lane
- Date/Time problem -((( Boris
- Re: Running a file Thomas SMETS
- Re: Looking for comments Thomas SMETS
- [Fwd: Looking for comments] Thomas SMETS
- Re: [ADMIN] Running a file Thomas SMETS
- Toad version for PostgreSQL Thomas SMETS
- Re: Toad version for PostgreSQL Tom Lane
- Re: Compiling "C" Functions Ron Peterson
- Sql92.. Narayanan Palasseri
- Re: Tree structure table normalization problem (do I need a trigger?) Ron Peterson
- Re: How to represent a tree-structure in a relational database Ron Peterson
- Re: How to represent a tree-structure in a relational database Ron Peterson
- Re: system catalog info John Reid
- Re: How to trim values? Karel Zak
- Re: Date/Time problem -((( Kaare Rasmussen
- References to SERIAL Thomas SMETS
- PL/pgSQL: returning array? Albert REINER
- Changing owner of tables, functions, etc. Albert REINER
- configure: what was used? Albert REINER
- Re: References to SERIAL Brett W. McCoy
- Re: References to SERIAL Oliver Elphick
- Re: References to SERIAL Thomas SMETS
- Re: Looking for comments Thomas SMETS
- Rules Peeter Smitt
- Re: Rules Peter Eisentraut
- Unable to identify an ordering operator Ferruccio Zamuner
- Re: Unable to identify an ordering operator Tom Lane
- Arrays Albert REINER
- Re: Arrays Oleg Bartunov