Mailing lists [pgsql-sql]
- plpgsql triggers in rules chester c young
 - session variables in 8.0 chester c young
 - exceptions in rules chester c young
 - avg() with floating-point types George Pavlov
 - Re: avg() with floating-point types Tom Lane
 - Re: avg() with floating-point types Michael Fuhr
 
- PostgreSQL and uuid/guid Mario Splivalo
 - delete from a using b in postgres 8.1. Peter Childs
 
- Re: delete from a using b in postgres 8.1. Jaime Casanova
 - getting a query column to return 0 if nothing matches Dan Tenenbaum
 - Loading lots of data in a SQL command frank church
 - Re: getting a query column to return 0 if nothing matches Michael Fuhr
 
- Re: Loading lots of data in a SQL command Richard Huxton
 - Regular Expression Matching problem... Mario Splivalo
 - Re: Regular Expression Matching problem... A. Kretschmer
 - Re: Regular Expression Matching problem... Michael Fuhr
 - JOIN question with multiple records Scott, Casey
 - FOREIGN KEYs ... I think ... Marc G. Fournier
 - Re: FOREIGN KEYs ... I think ... Tom Lane
 - Re: FOREIGN KEYs ... I think ... Marc G. Fournier
 - Re: FOREIGN KEYs ... I think ... Jim Johannsen
 - Re: FOREIGN KEYs ... I think ... nospam@hardgeus.com
 
- Re: JOIN question with multiple records Richard Huxton
 - Re: FOREIGN KEYs ... I think ... Leif B. Kristensen
 - Re: FOREIGN KEYs ... I think ... Marc G. Fournier
 - Re: PostgreSQL and uuid/guid george young
 
- INSERT waiting under heavy load alex-lists-pgsql@yuriev.com
 - Re: INSERT waiting under heavy load Tom Lane
 - Re: INSERT waiting under heavy load alex-lists-pgsql@yuriev.com
 - Re: INSERT waiting under heavy load Tom Lane
 
- how to transform list to table and evaluate an expression on it? Tomas Vondra
 - Re: how to transform list to table and evaluate an Frank Bax
 
- Re: INSERT waiting under heavy load Andrew Sullivan
 - Re: Regular Expression Matching problem... Mario Splivalo
 
- system view corrupted, i get "unexpected right parenthesis" for many system tables. David Ford
 - Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. Tom Lane
 - Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. David Ford
 - Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. Tom Lane
 - Re: system view corrupted, i get "unexpected right parenthesis" for many system tables. David Ford
 
- Regexp group matching - extracting second group element? Mario Splivalo
 
- Unable to identify an ordering operator '<' for type 'smallint[]' Mauricio Fernandez A.
 - Re: Unable to identify an ordering operator '<' for type 'smallint[]' Jaime Casanova
 - Re: Unable to identify an ordering operator '<' for type 'smallint[]' Tom Lane
 - psql client: technique for applying default values to :variables? Jeff Boes
 - Re: Unable to identify an ordering operator '<' for type 'smallint[]' Mauricio Fernandez A.
 - foreign keys with on delete cascade and triggers Dirk Jagdmann
 - Re: psql client: technique for applying default values to :variables? Tony Wasson
 - Re: foreign keys with on delete cascade and triggers Tom Lane
 
- error code invalid_input_syntax Rainer Leo
 - Re: foreign keys with on delete cascade and triggers Dirk Jagdmann
 - Re: foreign keys with on delete cascade and triggers Tom Lane
 - Re: error code invalid_input_syntax Tom Lane
 - Re: plpgsql triggers in rules Markus Schaber
 - Re: exceptions in rules Markus Schaber
 - info is a reserved word? John DeSoi
 - Re: info is a reserved word? Michael Fuhr
 
- Re: info is a reserved word? Tom Lane
 - Re: info is a reserved word? Michael Fuhr
 - ORDER BY does not work as expected with multiple joins Adam Rosi-Kessel
 - Re: ORDER BY does not work as expected with multiple joins Tom Lane
 - Re: ORDER BY does not work as expected with multiple joins Adam Rosi-Kessel
 - Re: ORDER BY does not work as expected with multiple joins Michael Glaesemann
 - Re: ORDER BY does not work as expected with multiple joins Adam Rosi-Kessel
 - Re: ORDER BY does not work as expected with multiple joins Michael Glaesemann
 - Re: ORDER BY does not work as expected with multiple joins Tom Lane
 - Re: ORDER BY does not work as expected with multiple joins Michael Glaesemann
 - Re: ORDER BY does not work as expected with multiple joins Jaime Casanova
 
- Another orderby problem Alan Chandler
 - Re: Another orderby problem A. Kretschmer
 - Re: Another orderby problem D'Arcy J.M. Cain
 - Re: Another orderby problem Alan Chandler
 - Re: psql client: technique for applying default values to :variables? Jeff Boes
 - Re: psql client: technique for applying default values to :variables? Michael Glaesemann
 
- select and as doubt Alexandre Gonçalves Jacarandá
 - Re: select and as doubt Tom Lane
 - Trigger for Large Object Modification Andreas Roth
 - Re: select and as doubt Alexandre Gonçalves Jacarandá
 - What does "merge-joinable join conditions" mean ???? Dean Gibson (DB Administrator)
 - Re: What does "merge-joinable join conditions" mean ???? Michael Fuhr
 - Re: What does "merge-joinable join conditions" mean ???? Tom Lane
 - Re: What does "merge-joinable join conditions" mean ???? Tom Lane
 - Re: What does "merge-joinable join conditions" mean ???? Dean Gibson (DB Administrator)
 - Re: What does "merge-joinable join conditions" mean ???? Tom Lane
 - Re: What does "merge-joinable join conditions" mean ???? Dean Gibson (DB Administrator)
 - Re: What does "merge-joinable join conditions" mean ???? Dean Gibson (DB Administrator)
 - Re: What does "merge-joinable join conditions" mean ???? Tom Lane
 
- Executing plpgsql scripts using psql, is that possible? Daniel CAUNE
 - Re: Executing plpgsql scripts using psql, is that possible? John DeSoi
 - Re: psql client: technique for applying default values to :variables? Jeff Boes
 - For update Ottó Havasvölgyi
 - Re: psql client: technique for applying default values to :variables? Andreas Seltenreich
 - Re: For update Alvaro Herrera
 - Re: For update Michael Fuhr
 - best way for constants in the database chester c young
 - Re: best way for constants in the database Owen Jacobson
 - Re: For update Ottó Havasvölgyi
 - Re: For update Alvaro Herrera
 - Re: For update Ottó Havasvölgyi
 - Re: For update Ottó Havasvölgyi
 - Re: Executing plpgsql scripts using psql, is that possible? Daniel CAUNE
 - Re: Executing plpgsql scripts using psql, is that possible? Adrian Klaver
 - Re: Executing plpgsql scripts using psql, is that possible? John DeSoi
 - Re: Executing plpgsql scripts using psql, is that possible? Daniel CAUNE
 
- Characters that needs escape characters when inserting to database Christian Paul B. Cosinas
 - Re: Characters that needs escape characters when inserting to database Michael Glaesemann
 - Re: Characters that needs escape characters when inserting to database Michael Fuhr
 - non-equi self-join optimization George Pavlov
 - Still struggling with history tables Ken Winter
 
- Matching several rows Ivan Steganov
 - Re: Matching several rows Michael Glaesemann
 - Re: Characters that needs escape characters when inserting to database Christian Paul B. Cosinas
 - bug with if ... then ... clause in views Emil Rachovsky
 - Re: Still struggling with history tables Achilleus Mantzios
 - Re: bug with if ... then ... clause in views Michael Glaesemann
 - Re: Still struggling with history tables Michael Glaesemann
 - Re: Matching several rows Volkan YAZICI
 - Re: Matching several rows Michael Glaesemann
 - Re: bug with if ... then ... clause in views Daryl Richter
 - Re: Matching several rows Volkan YAZICI
 - Re: Matching several rows Michael Glaesemann
 - Re: Matching several rows Ivan Steganov
 - Re: Matching several rows Patrick JACQUOT
 - Re: [GENERAL] bug with if ... then ... clause in views Jeff
 - Re: Matching several rows Vraj Mohan
 - stored procedures for complex SELECTs alex-lists-pgsql@yuriev.com
 - Re: stored procedures for complex SELECTs Michael Glaesemann
 
- Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Juris
 - Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Michael Glaesemann
 - Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Juris
 - indexing for left join T E Schmitz
 - Re: indexing for left join Rod Taylor
 - Re: indexing for left join Richard Huxton
 - Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Leif B. Kristensen
 - Re: indexing for left join T E Schmitz
 - Re: indexing for left join T E Schmitz
 - Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Michael Glaesemann
 
- Re: Error calling self-made plpgsql function "function XYZ(bigint) does not exist" Juris
 - Re: Error calling self-made plpgsql function "function XYZ(bigint) Markus Schaber
 
- Re: indexing for left join Zulq Alam
 
- How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? Jesper K. Pedersen
 - Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? Tom Lane
 - Re: How to implement Microsoft Access boolean (YESNO) Jesper K. Pedersen
 
- DBMirror.pl performance change Achilleus Mantzios
 - Re: select and as doubt Bruno Wolff III
 - pgadmin Mark Fenbers
 - Re: pgadmin Owen Jacobson
 - Re: pgadmin Tom Lane
 - Re: How to implement Microsoft Access boolean (YESNO) Greg Stark
 - Re: How to implement Microsoft Access boolean (YESNO) Tom Lane
 
- Re: How to implement Microsoft Access boolean (YESNO) Greg Stark
 - Re: non-equi self-join optimization Bruno Wolff III
 - Re: How to implement Microsoft Access boolean (YESNO) PFC
 - Re: How to implement Microsoft Access boolean (YESNO) Tom Lane
 - Re: How to implement Microsoft Access boolean (YESNO) fieldtype in PostgreSQL ? codeWarrior
 - sorting by day of the week Joseph Shraibman
 - Re: sorting by day of the week Joseph Shraibman
 - Fw: stored procedures for complex SELECTs
 - Re: sorting by day of the week
 
- hi all......................!! AKHILESH GUPTA
 - Re: hi all......................!! Richard Huxton
 - Re: hi all......................!! Markus Schaber
 - Changing the transaction isolation level within the stored procedure? Mario Splivalo
 - Re: Changing the transaction isolation level within the stored Markus Schaber
 - psql in the command line
 - Re: psql in the command line Alvaro Herrera
 - Re: Changing the transaction isolation level within the stored procedure? Jaime Casanova
 - filtering after join andrew
 - Re: psql in the command line Owen Jacobson
 - Re: filtering after join Michael Fuhr
 - Re: filtering after join Peter Eisentraut
 - Re: filtering after join andrew
 
- Re: Changing the transaction isolation level within the Mario Splivalo
 - Re: Changing the transaction isolation level within the Mario Splivalo
 - Re: Changing the transaction isolation level within the Markus Schaber
 - Re: Changing the transaction isolation level within the stored Markus Schaber
 - Re: filtering after join Peter Eisentraut
 - Re: filtering after join andrew
 - Re: filtering after join Peter Eisentraut
 - Re: Changing the transaction isolation level within the stored Andrew Sullivan
 - question with times and intervals A. Kretschmer
 - Re: question with times and intervals Richard Huxton
 - Re: question with times and intervals Andreas Kretschmer
 - Re: Changing the transaction isolation level within the stored Markus Schaber
 - Re: filtering after join andrew
 - Re: Changing the transaction isolation level within the stored Stephan Szabo
 - Re: [PERFORM] Query optimization with X Y JOIN Jaime Casanova
 - Re: Changing the transaction isolation level within the stored Andrew Sullivan
 - Re: filtering after join Peter Eisentraut
 - [HELP] Defining a function as a procedure Daniel Caune
 - Re: [HELP] Defining a function as a procedure Tom Lane
 
- Re: filtering after join andrew
 - Re: filtering after join andrew
 - Re: Changing the transaction isolation level within Mario Splivalo
 - REPOST:Memory Allocation error using pg_dump on 7.4 frank church
 - How to find a temporary table Emil Rachovsky
 - Re: How to find a temporary table Mario Splivalo
 - Re: filtering after join Tom Lane
 - Re: filtering after join andrew
 - Re: filtering after join andrew
 - Question about check constraints Kashmira Patel \(kupatel\)
 - Re: Question about check constraints Michael Fuhr
 - Re: Question about check constraints Kashmira Patel \(kupatel\)
 
- Re: Question about check constraints Stephan Szabo
 - Re: Question about check constraints Kashmira Patel \(kupatel\)
 
- Function with default value? Daniel CAUNE
 - Re: Function with default value? Tom Lane
 - Re: Function with default value? Daniel CAUNE
 - variable scooping ody quraviharto
 - Re: How to implement Microsoft Access boolean (YESNO) Bath, David
 - Re: [GENERAL] hi all......................!! Tino Wildenhain
 - Question about check constraints Kashmira Patel \(kupatel\)
 - UPDATE with correlated aggregates Joe Abbate
 - Re: [GENERAL] How to find a temporary table Pandurangan R S
 
- Re: variable scooping Michael Fuhr
 - regarding debugging? AKHILESH GUPTA
 
- CREATE VIEW form stored in database? Mario Splivalo
 - Re: CREATE VIEW form stored in database? Richard Huxton
 - Re: CREATE VIEW form stored in database? Mario Splivalo
 - Re: CREATE VIEW form stored in database? George Weaver
 - how is searchable email archive on Jacob Costello
 - Re: how is searchable email archive on Alvaro Herrera