Mailing lists [pgsql-sql]
- Re: Is it normal that functions are so much faster than inline queries Olivier Hubaut
- Array_append does not work with Array variables in PL/pgSQL? Josh Berkus
- Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway
- Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus
- Re: Array_append does not work with Array variables in PL/pgSQL? Joe Conway
- Re: Array_append does not work with Array variables in PL/pgSQL? Josh Berkus
- Re: [pgsql-advocacy] SQL Spec Compliance Questions Joe Conway
- Re: [pgsql-advocacy] SQL Spec Compliance Questions Josh Berkus
- Re: [pgsql-advocacy] SQL Spec Compliance Questions Joe Conway
- Re: [pgsql-advocacy] SQL Spec Compliance Questions Josh Berkus
- Re: [pgsql-advocacy] SQL Spec Compliance Questions Tom Lane
- Re: [pgsql-advocacy] SQL Spec Compliance Questions Peter Eisentraut
- Re: SQL Spec Compliance Questions Peter Eisentraut
- Function To Log Changes Gavin
- Re: Invalid Unicode Character Sequence found Bulatovic Natasa
- Entered data appears TWICE in table!!? rmorgan7@austin.rr.com (Ron M.)
- Simple insert not returning Kyle
- Re: DB question - Merging data from one table to another. malia, sean
- Getting the ranks of results from a query abhi
- Re: Function To Log Changes Josh Berkus
- Re: order of results Gregor Rot
- Question on pgsql trigger Jon Poulton
- oracle varray functionality? Postgres User
- group by not returning sorted rows Bret Hughes
- Re: Function To Log Changes Tom Lane
- Re: DB question - Merging data from one table to another. scott.marlowe
- Re: group by not returning sorted rows Stephan Szabo
- Re: Question on pgsql trigger Jeff Eckermann
- Re: group by not returning sorted rows Tom Lane
- Re: Entered data appears TWICE in table!!? Jeff Eckermann
- Rename Schema or Script DDL only a schema kumar
- Re: Rename Schema or Script DDL only a schema Olivier Hubaut
- could not devise a query plan SZŰCS Gábor
- Re: Entered data appears TWICE in table!!? Jeff Eckermann
- partial unique constraint Robert Treat
- Re: could not devise a query plan Tom Lane
- Re: partial unique constraint Tom Lane
- Re: partial unique constraint Achilleus Mantzios
- Re: partial unique constraint
- Re: partial unique constraint Stephan Szabo
- Re: partial unique constraint Paul Thomas
- Re: partial unique constraint Rod Taylor
- SQL Standatd Ricardo Vaz Mannrich
- distinct values without seq scan Bret Hughes
- Re: group by not returning sorted rows Bret Hughes
- Re: SQL Standatd Bruce Momjian
- Re: could not devise a query plan Tom Lane
- Re: partial unique constraint Robert Treat
- Re: Function To Log Changes elein
- Re: partial unique constraint Richard Huxton
- Re: Getting the ranks of results from a query Bruno Wolff III
- Re: order of results Bruno Wolff III
- Re: Function To Log Changes Erik Thiele
- Re: SQL Standatd Ricardo Vaz Mannrich
- Re: SQL Standatd Bruce Momjian
- Re: distinct values without seq scan Josh Berkus
- notify and leaks? Theodore Petrosky
- Re: notify and leaks? Tom Lane
- varray? table of varchar? Postgres User
- Row count after SELECT INTO? Alexander M. Pravking
- Re: SQL Standatd Martin Marques
- Re: SQL Standatd Bruce Momjian
- Re: SQL Standatd Joe Conway
- Re: SQL Standatd Bruce Momjian
- Encoding and result string length kumar
- Re: Encoding and result string length Richard Huxton
- SQL challenge--top 10 for each key value? Jeff Boes
- Re: SQL challenge--top 10 for each key value? Greg Stark
- Re: SQL challenge--top 10 for each key value? Rod Taylor
- Re: SQL challenge--top 10 for each key value? Tom Lane
- Re: could not devise a query plan SZŰCS Gábor
- Utility of recursive queries? James Robinson
- Re: SQL challenge--top 10 for each key value? Josh Berkus
- Re: Utility of recursive queries? Josh Berkus
- Re: Utility of recursive queries? Tom Lane
- Re: SQL challenge--top 10 for each key value? Greg Stark
- Help with COPY command reina_ga@hotmail.com (Tony Reina)
- Re: Unknown Exception (piaozhenyu@163.com) ??
- setting a non-standard date format for the duration of a session Cris Carampa
- Counting rows from two tables in one query Stefan Weiss
- Crypt() encryption Christina Zhang
- Re: Help with COPY command reina_ga@hotmail.com (Tony Reina)
- pgsql multi-database queries yek ching
- hi sir urgent..required a Query Rajeev Chaudhary, Noida
- Re: Crypt() encryption Bruce Momjian
- Re: Counting rows from two tables in one query Greg Sabino Mullane
- Re: pgsql multi-database queries scott.marlowe
- Re: SQL challenge--top 10 for each key value? Rod Taylor
- Re: SQL challenge--top 10 for each key value? Greg Sabino Mullane
- Re: Counting rows from two tables in one query Bruno Wolff III
- Re: hi sir urgent..required a Query Josh Berkus
- Re: setting a non-standard date format for the duration of a session Josh Berkus
- Re: SQL challenge--top 10 for each key value? Josh Berkus
- begin update ... syntax error Kemin Zhou
- Re: begin update ... syntax error Gregory S. Williamson
- Re: begin update ... syntax error Adrian Klaver
- Re: SQL challenge--top 10 for each key value? Troels Arvin
- Re: begin update ... syntax error Yasir Malik
- Re: SQL challenge--top 10 for each key value? Troels Arvin
- Re: SQL challenge--top 10 for each key value? elein
- Re: SQL challenge--top 10 for each key value? elein
- Re: SQL challenge--top 10 for each key value? Greg Stark
- trigger/for key help Bret Hughes
- cursors and for loops? Dennis
- Re: trigger/for key help Stephan Szabo
- Re: cursors and for loops? Tom Lane
- Re: SQL challenge--top 10 for each key value? elein
- Re: trigger/for key help Bret Hughes
- Re: cursors and for loops? Dennis
- Re: trigger/for key help Tom Lane
- Re: trigger/for key help Bret Hughes
- Re: trigger/for key help Tom Lane
- Re: trigger/for key help Bret Hughes
- Re: trigger/for key help Greg Stark
- Re: cursors and for loops? Richard Huxton
- Re: trigger/for key help Tom Lane
- Formatting Functions and Group By Terry Brick
- Re: Formatting Functions and Group By Bruno Wolff III
- Re: Formatting Functions and Group By Tom Lane
- Re: trigger/for key help Greg Stark
- Re: Formatting Functions and Group By Terry Brick
- Re: trigger/for key help Tom Lane
- function returning array Dennis
- Re: function returning array Tom Lane
- Re: function returning array Joe Conway
- Re: Help with COPY command Christoph Haller
- Re: Help with COPY command Tony and Bryn Reina
- full join...using and version of pgsql Tina Messmann
- Re: full join...using and version of pgsql scott.marlowe
- SET idiom in insert statement Kenneth Gonsalves
- type conversions sad
- Grant permission to all objects of user A to user B kumar
- Re: [GENERAL] SQL script Richard Huxton
- problem porting MySQL SQL to Postgres Dan Field
- Re: problem porting MySQL SQL to Postgres Reinoud van Leeuwen
- Re: problem porting MySQL SQL to Postgres Paul Thomas
- Re: problem porting MySQL SQL to Postgres Martin Marques
- Re: function returning array Dennis
- Re: cursors and for loops? Jan Wieck
- Re: Row count after SELECT INTO? Christoph Haller
- Re: Grant permission to all objects of user A to user B Christoph Haller
- Re: function returning array Joe Conway
- Re: function returning array Dennis
- Update is very slow on a bigger table Dimitar Georgievski
- Re: Update is very slow on a bigger table Tom Lane
- Re: Update is very slow on a bigger table Dimitar Georgievski
- Querying two databases Pallav Kalva
- Re: Querying two databases Rajesh Kumar Mallah
- Re: Update is very slow on a bigger table Yudie
- run application from trigger? Yudie
- Re: run application from trigger? Richard Huxton
- Re: Update is very slow on a bigger table Bruno Wolff III
- Concatenate results of a single column query Marco Lazzeri
- Re: Concatenate results of a single column query Greg Stark
- Re: problem porting MySQL SQL to Postgres Markus Bertheau
- Re: problem porting MySQL SQL to Postgres Paul Thomas
- Re: problem porting MySQL SQL to Postgres Bruno Wolff III
- three-way join Gary Stainburn
- Re: Concatenate results of a single column query Christoph Haller
- Re: Concatenate results of a single column query Greg Stark
- Re: three-way join Stijn Vanroye
- Re: three-way join Gary Stainburn
- Re: Update is very slow on a bigger table scott.marlowe
- Prepared Statements and large where-id-in constant blocks? James Robinson
- Re: three-way join - solved Gary Stainburn
- Re: Concatenate results of a single column query CoL
- Concatenate results of a single column query Marco Lazzeri
- Querying From two databases Pallav Kalva
- What is the best way of writing update rule on view with joined tables? cpng@sophos.com (Cornelius Grotjahn)
- ANN: www.SQL-Scripts.Com
- Re: Function for numbering rows? CoL
- Re: SQL challenge--top 10 for each key value? Jeff Boes
- relation X does not exist Laura Scott
- Re: Database triggers Charles Wilt
- Database triggers cmpofu@iupui.edu (Charity M)
- Re: problem porting MySQL SQL to Postgres CoL
- SQL script vickr1z@operamail.com
- Re: three-way join Bruno Wolff III
- Re: Update is very slow on a bigger table CoL
- Re: Database triggers cmpofu@iupui.edu (Charity M)
- Re: Querying From two databases Bruce Momjian
- Re: SQL script scott.marlowe
- Re: Prepared Statements and large where-id-in constant blocks? Tom Lane
- Re: relation X does not exist Tom Lane
- Re: three-way join - solved Stijn Vanroye
- Can someone tell me why this statement is failing? P A
- Re: [JDBC] Prepared Statements and large where-id-in constant blocks? Oliver Jowett
- Re: [JDBC] Prepared Statements and large where-id-in constant blocks? Oliver Jowett
- Re: Can someone tell me why this statement is failing? Martin Marques
- Re: Can someone tell me why this statement is failing? Edmund Bacon
- Re: [JDBC] Prepared Statements and large where-id-in constant blocks? James Robinson
- Re: Can someone tell me why this statement is failing? Rod Taylor
- Syntax for cmd to EXEC...how many quotes? David B
- transaction H.J. Sanders
- Follow-up: FK constraint performance ow
- Re: transaction Bruno Wolff III
- staggered query? Vincent Ladlad
- Re: Follow-up: FK constraint performance ow
- Re: staggered query? Denis P Gohel
- Order by YYYY MM DD in reverse chrono order trouble
- Re: Order by YYYY MM DD in reverse chrono order trouble Stijn Vanroye
- Re: transaction Andrew Sullivan
- Re: Order by YYYY MM DD in reverse chrono order trouble
- Re: Syntax for cmd to EXEC...how many quotes? George Weaver
- datediff script Erik Aronesty
- Trigger calling a function HELP ME!
- Re: Order by YYYY MM DD in reverse chrono order trouble Edmund Bacon
- Trigger calling a function HELP ME! (2)
- Re: transaction Bruno Wolff III
- Join issue on a maximum value Heflin
- Re: Join issue on a maximum value Bruno Wolff III
- Server Side C programming Environment Set up Kemin Zhou
- Re: Join issue on a maximum value Edmund Bacon
- rule's behavior with join interesting Kemin Zhou
- Re: Join issue on a maximum value Heflin
- Re: Join issue on a maximum value Bruno Wolff III
- Re: Server Side C programming Environment Set up Peter Eisentraut
- Re: Server Side C programming Environment Set up Tom Lane
- Re: Join issue on a maximum value Tom Lane
- Select from two databases Becky Alcorn
- Re: staggered query? Vincent Ladlad
- Bug#960: WAS: Trigger calling a function HELP ME! (2)
- Re: rule's behavior with join interesting Richard Huxton
- Re: Select from two databases Richard Huxton
- Re: Order by YYYY MM DD in reverse chrono order trouble
- Re: Order by YYYY MM DD in reverse chrono order trouble Stijn Vanroye
- Re: Trigger calling a function HELP ME! (2) Richard Huxton
- Re: Order by YYYY MM DD in reverse chrono order trouble Tom Lane
- Re: Server Side C programming Environment Set up Rod Taylor
- Re: Order by YYYY MM DD in reverse chrono order trouble
- Re: Server Side C programming Environment Set up Tom Lane
- Re: Server Side C programming Environment Set up Tom Lane
- Re: Server Side C programming Environment Set up Rod Taylor
- Design Problem... Ryan Riehle
- Re: Server Side C programming Environment Set up Peter Eisentraut
- Re: Server Side C programming Environment Set up Peter Eisentraut
- Re: rule's behavior with join interesting Jan Wieck
- Re: Server Side C programming Environment Set up Kemin Zhou
- lifetime of temp schema versus compiled image of plpgsql proc Dennis
- Re: lifetime of temp schema versus compiled image of plpgsql proc Dennis
- Re: lifetime of temp schema versus compiled image of plpgsql proc Bruce Momjian
- Is there an easy way to normalize-space with given string functions Janning Vygen
- Re: lifetime of temp schema versus compiled image of plpgsql proc Bruce Momjian
- Re: lifetime of temp schema versus compiled image of plpgsql proc Tom Lane
- Re: lifetime of temp schema versus compiled image of plpgsql proc Tom Lane
- Re: Is there an easy way to normalize-space with given string functions Tom Lane
- Re: Order by YYYY MM DD in reverse chrono order trouble Stijn Vanroye
- Re: Order by YYYY MM DD in reverse chrono order trouble
- Re: Server Side C programming Environment Set up Peter Eisentraut
- converting unix seconds to timestamp Alexei Chetroi
- Record Lock details Denis P Gohel
- Re: Is there an easy way to normalize-space with given string functions Janning Vygen
- Re: Record Lock details Peter Eisentraut
- Re: converting unix seconds to timestamp Alexei Chetroi
- Re: Server Side C programming Environment Set up Tom Lane
- Re: Server Side C programming Environment Set up Bruce Momjian
- CONTEXT on PL/pgSQL Martin Marques
- Re: CONTEXT on PL/pgSQL Tom Lane
- Multi ordered select and indexing Antal Attila
- Re: CONTEXT on PL/pgSQL Martin Marques
- Re: Multi ordered select and indexing Stephan Szabo
- Re: Multi ordered select and indexing Bruno Wolff III
- Re: lifetime of temp schema versus compiled image of plpgsql proc Jaime Casanova
- Re: Trigger calling a function HELP ME! (2) Riccardo G. Facchini
- Re: Order by YYYY MM DD in reverse chrono order trouble Greg Sabino Mullane
- Re: Design Problem... Greg Sabino Mullane
- Question re: serial Michael Satterwhite
- Re: Question re: serial Devrim GUNDUZ
- Re: Question re: serial Bruno Wolff III
- Python connection Michael Satterwhite
- Re: Trigger calling a function HELP ME! (2) Riccardo G. Facchini
- Re: Python connection Karsten Hilbert
- Own opclass and LIKE problem again! Atesz
- SQL Query Timeouts Dan Field
- Re: Join issue on a maximum value Atesz
- Multi ordered select and indexing Antal Attila
- Postgres backend to backup system Kent L. Nasveschuk
- Postgres DB Sumita Biswas
- Own opclass and LIKE problem again! Antal Attila
- Re: transaction denis@coralindia.com
- Re: Syntax for cmd to EXEC...how many quotes? denis@coralindia.com
- Re: Order by YYYY MM DD in reverse chrono order trouble denis@coralindia.com
- Trigger calling a function HELP ME! (2) Riccardo Facchini
- Re: Can someone tell me why this statement is failing? denis@coralindia.com
- problem with slow select francescosaf
- Re: Join issue on a maximum value Jeremy Semeiks
- Proper SQL syntax requested blake@shopwhatcom.com (Blake)
- Which SQL command creates ExclusiveLock? Denis Khabas
- Cascade delete question Glenn MacGregor
- Re: problem with slow select Rod Taylor
- Logical comparison on Strings kumar
- Customised Encoding kumar
- Postgres as backend to Backup System Kent L. Nasveschuk
- Performance issue Michael L. Hostbaek
- Re: Logical comparison on Strings Rajesh Kumar Mallah
- Re: Performance issue Paul Thomas
- Re: Proper SQL syntax requested Richard Huxton
- Re: Customised Encoding Richard Huxton
- How to get binary value for an Integer kumar
- Re: How to get binary value for an Integer Achilleus Mantzios
- Re: Customised Encoding Richard Huxton
- query optimizer dont treat correctly OR Luiz Rafael Culik Guimaraes
- Re: query optimizer dont treat correctly OR Richard Huxton
- Re: Postgres as backend to Backup System Kent L. Nasveschuk
- Re: Postgres as backend to Backup System Kent L. Nasveschuk
- SELECTing part of a matrix reina_ga@hotmail.com (Tony Reina)
- date arithmetic over calender year boundaries Ray Jackson
- Re: Which SQL command creates ExclusiveLock? Tom Lane
- Re: Customised Encoding kumar
- Re: date arithmetic over calender year boundaries Bruno Wolff III
- select distinct and order by Stijn Vanroye
- Re: select distinct and order by Viorel Dragomir
- Re: select distinct and order by Stijn Vanroye
- Re: Multi ordered select and indexing Christoph Haller
- Equivalant of SQL Server's Nchar and NVARCHAR kumar
- Re: Equivalant of SQL Server's Nchar and NVARCHAR Karsten Hilbert
- Re: Equivalant of SQL Server's Nchar and NVARCHAR Rob
- Re: Use arrays or not? Josh Berkus
- Check a value in array Marco Lazzeri
- Re: Check a value in array Rod Taylor
- Re: Equivalant of SQL Server's Nchar and NVARCHAR Josh Berkus
- Re: Multi ordered select and indexing Tom Lane
- Permissions not working Pallav Kalva
- Re: Use arrays or not? Josh Berkus
- Re: Permissions not working scott.marlowe
- Re: Permissions not working Pallav Kalva
- Re: Permissions not working scott.marlowe
- isnumeric() function? Yudie
- Re: Permissions not working Tom Lane
- Problem in SQL Trigger Ramesh Patel
- Re: Use arrays or not? Achilleus Mantzios
- Re: Check a value in array Marco Lazzeri
- Re: Permissions not working Pallav Kalva
- Re: isnumeric() function? Jeff Eckermann
- Re: Problem in SQL Trigger Rajesh Kumar Mallah
- Re: isnumeric() function? Yudie
- Re: Permissions not working Tom Lane
- Re: isnumeric() function? Frank Bax
- Re: Permissions not working Pallav Kalva