pgsql-sql  

Messages by Date

• 2013/05/25 Re: [SQL] DELETE...RETURNING problem with libpq Guillaume Lelarge
• 2013/05/25 Re: [SQL] Advice on re-writing a SELECT query. Marc Mamin
• 2013/05/25 [SQL] Advice on re-writing a SELECT query. JORGE MALDONADO
• 2013/05/25 Re: [SQL] DELETE...RETURNING problem with libpq Brice André
• 2013/05/25 Re: [SQL] DELETE...RETURNING problem with libpq Wolfe Whalen
• 2013/05/25 Re: [SQL] reduce many loosely related rows down to one Marc Mamin
• 2013/05/25 [SQL] DELETE...RETURNING problem with libpq Brice André
• 2013/05/25 [SQL] reduce many loosely related rows down to one Bill MacArthur
• 2013/05/24 Re: [SQL] Select statement with except clause David Johnston
• 2013/05/24 Re: [SQL] Select statement with except clause JORGE MALDONADO
• 2013/05/23 Re: [SQL] Select statement with except clause David Johnston
• 2013/05/23 [SQL] Select statement with except clause JORGE MALDONADO
• 2013/05/17 Re: [SQL] How to right justify text in psql? Ian Lawrence Barwick
• 2013/05/17 Re: [SQL] How to right justify text in psql? Jov
• 2013/05/17 [SQL] How to right justify text in psql? Brian Sherwood
• 2013/05/14 Re: [SQL] array_agg() with join question George Woodring
• 2013/05/14 Re: [SQL] Correct implementation of 1:n relationship with n>0? Wolfgang Keller
• 2013/05/14 Re: [SQL] array_agg() with join question Igor Neyman
• 2013/05/14 [SQL] array_agg() with join question George Woodring
• 2013/05/13 Re: [SQL] transaction isolationa level - SERIALIZABLE Marcin Krawczyk
• 2013/05/13 Re: [SQL] transaction isolationa level - SERIALIZABLE Adrian Klaver
• 2013/05/13 [SQL] transaction isolationa level - SERIALIZABLE Marcin Krawczyk
• 2013/05/08 Re: [SQL] Correct implementation of 1:n relationship with n>0? Achilleas Mantzios
• 2013/05/06 Re: [SQL] Correct implementation of 1:n relationship with n>0? Achilleas Mantzios
• 2013/05/06 Re: [SQL] Order of execution Jasen Betts
• 2013/05/05 [SQL] Order of execution JORGE MALDONADO
• 2013/04/30 Re: [SQL] Correct implementation of 1:n relationship with n>0? Igor Neyman
• 2013/04/30 Re: [SQL] Correct implementation of 1:n relationship with n>0? Wolfgang Keller
• 2013/04/30 Re: [SQL] Correct implementation of 1:n relationship with n>0? Wolfgang Keller
• 2013/04/30 Re: [SQL] Correct implementation of 1:n relationship with n>0? Vik Fearing
• 2013/04/30 Re: [SQL] Correct implementation of 1:n relationship with n>0? Misa Simic
• 2013/04/30 Re: [SQL] Correct implementation of 1:n relationship with n>0? Anton Gavazuk
• 2013/04/30 Re: [SQL] Correct implementation of 1:n relationship with n>0? Misa Simic
• 2013/04/30 Re: [SQL] Correct implementation of 1:n relationship with n>0? Achilleas Mantzios
• 2013/04/30 [SQL] Correct implementation of 1:n relationship with n>0? Wolfgang Keller
• 2013/04/27 Re: [SQL] execute Jasen Betts
• 2013/04/25 Re: [SQL] execute Sergey Konoplev
• 2013/04/25 [SQL] execute Mauricio Cruz
• 2013/04/23 [SQL] Not Able to Delink the old tables shabeer ece
• 2013/04/22 Re: [SQL] check for overlapping time intervals Wolfgang Meiners
• 2013/04/22 Re: [SQL] check for overlapping time intervals Thomas Kellerer
• 2013/04/22 [SQL] check for overlapping time intervals Wolfgang Meiners
• 2013/04/20 [SQL] Re: [SQL] Table indexes in a SELECT with JOIN´s Pavel Stehule
• 2013/04/20 [SQL] Table indexes in a SELECT with JOIN´s JORGE MALDONADO
• 2013/04/19 Re: [SQL] ALTER USER abc PASSWORD - what's going on ??? Marcin Krawczyk
• 2013/04/18 [SQL] SQL query with Overlapping date time ranges chinnaobi
• 2013/04/18 Re: [SQL] ALTER USER abc PASSWORD - what's going on ??? Guillaume Lelarge
• 2013/04/18 Re: [SQL] Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help Andreas Kretschmer
• 2013/04/18 [SQL] Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help Sofer, Yuval
• 2013/04/18 Re: [SQL] copy from csv, variable filename within a function bricklen
• 2013/04/18 Re: [SQL] Peer-review requested of soft-delete scheme Jasen Betts
• 2013/04/18 Re: [SQL] ALTER USER abc PASSWORD - what's going on ??? SEKA Bruno-Emmanuel
• 2013/04/18 Re: [SQL] ALTER USER abc PASSWORD - what's going on ??? Marcin Krawczyk
• 2013/04/18 Re: [SQL] ALTER USER abc PASSWORD - what's going on ??? SEKA Bruno-Emmanuel
• 2013/04/18 [SQL] ALTER USER abc PASSWORD - what's going on ??? Marcin Krawczyk
• 2013/04/18 Fwd: [SQL] copy from csv, variable filename within a function basti
• 2013/04/18 [SQL] copy from csv, variable filename within a function basti
• 2013/04/16 [SQL] building psycopg2 Thomas Burnett
• 2013/04/16 [SQL] Peer-review requested of soft-delete scheme Mark Stosberg
• 2013/04/13 Re: [SQL] pivot query with count Tony Capobianco
• 2013/04/12 Re: [SQL] pivot query with count David Johnston
• 2013/04/12 Re: [SQL] pivot query with count David Johnston
• 2013/04/12 [SQL] pivot query with count Tony Capobianco
• 2013/04/12 [SQL] pivot query with count Tony Capobianco
• 2013/04/12 Re: [SQL] Clarity on how LOCK interacts with INHERIT Simon Riggs
• 2013/04/12 [SQL] Clarity on how LOCK interacts with INHERIT Robins Tharakan
• 2013/04/12 Re: [SQL] Restrict FOREIGN KEY to a part of the referenced table Richard Broersma
• 2013/04/12 Re: [SQL] Restrict FOREIGN KEY to a part of the referenced table Jasen Betts
• 2013/04/12 Re: [SQL] Advice for index design Jasen Betts
• 2013/04/11 Re: [SQL] Advice for index design Greg Sabino Mullane
• 2013/04/11 [SQL] Slow update with ST_Contians() androclos
• 2013/04/11 [SQL] Restrict FOREIGN KEY to a part of the referenced table Matthias Nagel
• 2013/04/10 Re: [SQL] Advice for index design Gavin Flower
• 2013/04/10 [SQL] Advice for index design JORGE MALDONADO
• 2013/04/10 Re: [SQL] Encrypting PGBouncer to Postgres DB connections k...@rice.edu
• 2013/04/10 [SQL] Encrypting PGBouncer to Postgres DB connections Bhanu Murthy
• 2013/04/05 Re: [SQL] Data Loss from SQL SELECT (vs. COPY/pg_dump) Kong Man
• 2013/04/05 [SQL] Data Loss from SQL SELECT (vs. COPY/pg_dump) Kong Man
• 2013/04/04 Re: [SQL] Postgres trigger issue with update statement in it. Kaleeswaran Velu
• 2013/04/04 Re: [SQL] Postgres trigger issue with update statement in it. Adrian Klaver
• 2013/04/04 Re: [SQL] Postgres trigger issue with update statement in it. Wolfe Whalen
• 2013/04/03 [SQL] Postgres trigger issue with update statement in it. Kaleeswaran Velu
• 2013/03/26 Re: [SQL] how can I replace all instances of a pattern James Sharrett
• 2013/03/26 Re: [SQL] how can I replace all instances of a pattern Steve Crawford
• 2013/03/26 Re: [SQL] how can I replace all instances of a pattern k...@rice.edu
• 2013/03/26 Re: [SQL] how can I replace all instances of a pattern James Sharrett
• 2013/03/26 [SQL] how can I replace all instances of a pattern James Sharrett
• 2013/03/26 Re: [SQL] From with case Pavel Stehule
• 2013/03/26 Re: [SQL] From with case Pavel Stehule
• 2013/03/25 Re: [SQL] From with case Ben Morrow
• 2013/03/25 Re: [SQL] From with case Pavel Stehule
• 2013/03/25 Re: [SQL] From with case Ben Morrow
• 2013/03/25 Re: [SQL] From with case Mauricio Cruz
• 2013/03/25 Re: [SQL] From with case Pavel Stehule
• 2013/03/25 [SQL] From with case Mauricio Cruz
• 2013/03/21 Re: [SQL] Reading from file without superuser privilege Adrian Klaver
• 2013/03/21 [SQL] Reading from file without superuser privilege Jose Antonio Quintana/UPC
• 2013/03/18 Re: [SQL] How to split an array-column? Andreas
• 2013/03/18 Re: [SQL] How to split an array-column? Venky Kandaswamy
• 2013/03/18 [SQL] How to split an array-column? Andreas
• 2013/03/17 Re: [SQL] Efficiency Problem Surfing
• 2013/03/17 Re: [SQL] Efficiency Problem Misa Simic
• 2013/03/17 [SQL] Efficiency Problem Surfing
• 2013/03/16 Re: [SQL] ZIP function Ben Morrow
• 2013/03/16 Re: [SQL] ZIP function Jasen Betts
• 2013/03/16 [SQL] ZIP function Victor Sterpu
• 2013/03/15 Re: [SQL] bug in 9.2.2 ? subquery accepts wrong column name : upd Achilleas Mantzios
• 2013/03/14 Re: [SQL] UPDATE query with variable number of OR conditions in WHERE Tom Lane
• 2013/03/14 Re: [SQL] UPDATE query with variable number of OR conditions in WHERE Ben Morrow
• 2013/03/14 [SQL] UPDATE query with variable number of OR conditions in WHERE JORGE MALDONADO
• 2013/03/14 Re: [SQL] bug in 9.2.2 ? subquery accepts wrong column name : upd Tom Lane
• 2013/03/14 [SQL] bug in 9.2.2 ? subquery accepts wrong column name : upd Achilleas Mantzios
• 2013/03/12 Re: [SQL] xmlelement name Pavel Stehule
• 2013/03/12 [SQL] xmlelement name Ben Morgan
• 2013/03/09 [SQL] 3/9/2013 2:45:30 PM Barbara Woolums
• 2013/03/05 Re: [SQL] Migrate to Postgres - Alias a Keyword? Torsten Zuehlsdorff
• 2013/03/04 [SQL] Migrate to Postgres - Alias a Keyword? Huan Ruan
• 2013/03/02 Re: [SQL] Need help revoking access WHERE state = 'deleted' Ben Morrow
• 2013/03/02 Re: [SQL] I need to fill up a sparse table in an view Victor Yegorov
• 2013/03/02 [SQL] I need to fill up a sparse table in an view Andreas
• 2013/03/02 Re: [SQL] Need help revoking access WHERE state = 'deleted' Wayne Cuddy
• 2013/03/02 Re: [SQL] Concatenating bytea types... Jasen Betts
• 2013/03/01 Re: [SQL] Concatenating bytea types... Richard Huxton
• 2013/02/28 Re: [SQL] Need help revoking access WHERE state = 'deleted' Mark Stosberg
• 2013/02/28 Re: [SQL] Need help revoking access WHERE state = 'deleted' Tom Lane
• 2013/02/28 Re: [SQL] Need help revoking access WHERE state = 'deleted' Mark Stosberg
• 2013/02/28 Re: [SQL] Need help revoking access WHERE state = 'deleted' Ben Morrow
• 2013/02/28 [SQL] Need help revoking access WHERE state = 'deleted' Mark Stosberg
• 2013/02/28 [SQL] Concatenating bytea types... Marko Rihtar
• 2013/02/27 Re: [SQL] Using Ltree For Hierarchical Structures Igor Neyman
• 2013/02/26 Re: [SQL] Using Ltree For Hierarchical Structures Misa Simic
• 2013/02/26 Re: [SQL] Using Ltree For Hierarchical Structures Don Parris
• 2013/02/26 Re: [SQL] Using Ltree For Hierarchical Structures Igor Neyman
• 2013/02/26 Re: [SQL] Using Ltree For Hierarchical Structures Thomas Kellerer
• 2013/02/26 Re: [SQL] Using Ltree For Hierarchical Structures Don Parris
• 2013/02/26 Re: [SQL] Creating a new database with a TEMPLATE did not work mkumbale
• 2013/02/26 Re: [SQL] Using Ltree For Hierarchical Structures Misa Simic
• 2013/02/26 Re: [SQL] Using Ltree For Hierarchical Structures Igor Neyman
• 2013/02/25 Re: [SQL] Creating a new database with a TEMPLATE did not work Ben Morrow
• 2013/02/25 Re: [SQL] Creating a new database with a TEMPLATE did not work Adrian Klaver
• 2013/02/25 [SQL] Creating a new database with a TEMPLATE did not work mkumbale
• 2013/02/25 [SQL] Euclidean distance between two sets of tuples Surfing
• 2013/02/24 [SQL] Using Ltree For Hierarchical Structures Don Parris
• 2013/02/23 Re: [SQL] Summing & Grouping in a Hierarchical Structure Don Parris
• 2013/02/23 Re: [SQL] Summing & Grouping in a Hierarchical Structure Ben Morrow
• 2013/02/23 Re: [SQL] Summing & Grouping in a Hierarchical Structure Misa Simic
• 2013/02/23 Re: [SQL] Update HSTORE record and then delete if it is now empty - What is the correct sql? Ashwin Jayaprakash
• 2013/02/23 Re: [SQL] Update HSTORE record and then delete if it is now empty - What is the correct sql? Ashwin Jayaprakash
• 2013/02/23 Re: [SQL] Summing & Grouping in a Hierarchical Structure Don Parris
• 2013/02/23 Re: [SQL] Summing & Grouping in a Hierarchical Structure Don Parris
• 2013/02/23 Re: [SQL] Summing & Grouping in a Hierarchical Structure Bryan L Nuse
• 2013/02/23 Re: [SQL] Summing & Grouping in a Hierarchical Structure Don Parris
• 2013/02/23 Re: [SQL] Summing & Grouping in a Hierarchical Structure Misa Simic
• 2013/02/23 Re: [SQL] Update HSTORE record and then delete if it is now empty - What is the correct sql? Tom Lane
• 2013/02/22 Re: [SQL] Update HSTORE record and then delete if it is now empty - What is the correct sql? Ian Lawrence Barwick
• 2013/02/22 Re: [SQL] Summing & Grouping in a Hierarchical Structure Bryan L Nuse
• 2013/02/22 Re: [SQL] Summing & Grouping in a Hierarchical Structure Don Parris
• 2013/02/22 Re: [SQL] Summing & Grouping in a Hierarchical Structure Don Parris
• 2013/02/22 [SQL] Update HSTORE record and then delete if it is now empty - What is the correct sql? Ashwin Jayaprakash
• 2013/02/22 Re: [SQL] need help denero team
• 2013/02/22 Re: [SQL] need help Russell Keane
• 2013/02/22 Re: [SQL] need help denero team
• 2013/02/22 Re: [SQL] Summing & Grouping in a Hierarchical Structure Misa Simic
• 2013/02/22 Re: [SQL] need help Russell Keane
• 2013/02/21 Re: [SQL] need help Jaime Casanova
• 2013/02/21 Re: [SQL] Summing & Grouping in a Hierarchical Structure Alexander Gataric
• 2013/02/21 Re: [SQL] need help Oliver d'Azevedo Cristina
• 2013/02/21 Re: [SQL] need help Russell Keane
• 2013/02/21 Re: [SQL] need help Russell Keane
• 2013/02/21 Re: [SQL] need help Oliver d'Azevedo Cristina
• 2013/02/21 Re: [SQL] need help denero team
• 2013/02/21 Re: [SQL] need help Carlos Chapi
• 2013/02/21 [SQL] need help denero team
• 2013/02/21 Re: [SQL] Summing & Grouping in a Hierarchical Structure Don Parris
• 2013/02/21 Re: [SQL] Summing & Grouping in a Hierarchical Structure Don Parris
• 2013/02/20 Re: [SQL] Volatile functions in WITH Ben Morrow
• 2013/02/20 Re: [SQL] Volatile functions in WITH Sergey Konoplev
• 2013/02/20 Re: [SQL] Volatile functions in WITH Ben Morrow
• 2013/02/20 Re: [SQL] Volatile functions in WITH Sergey Konoplev
• 2013/02/20 Re: [SQL] Volatile functions in WITH Ben Morrow
• 2013/02/19 Re: [SQL] Volatile functions in WITH Sergey Konoplev
• 2013/02/18 Re: [SQL] query doesn't always follow 'correct' path.. Bert
• 2013/02/18 Re: [SQL] query doesn't always follow 'correct' path.. Julien Cigar
• 2013/02/18 Re: [SQL] Summing & Grouping in a Hierarchical Structure Relyea, Mike
• 2013/02/18 Re: [SQL] query doesn't always follow 'correct' path.. Julien Cigar
• 2013/02/18 Re: [SQL] query doesn't always follow 'correct' path.. Виктор Егоров
• 2013/02/18 Re: [SQL] query doesn't always follow 'correct' path.. Bert
• 2013/02/18 Re: [SQL] query doesn't always follow 'correct' path.. Bert
• 2013/02/18 [SQL] HP and libxnet ... Sebastien FLAESCH
• 2013/02/18 Re: [SQL] query doesn't always follow 'correct' path.. Frank Lanitz
• 2013/02/17 Re: [SQL] How to reject overlapping timespans? Ben Morrow
• 2013/02/17 Re: [SQL] How to reject overlapping timespans? Andreas
• 2013/02/17 Re: [SQL] How to reject overlapping timespans? Andreas Kretschmer
• 2013/02/17 [SQL] How to reject overlapping timespans? Andreas
• 2013/02/17 Re: [SQL] Perform Function When The Rows Of A View Change Ben Morrow
• 2013/02/17 Re: [SQL] upsert doesn't seem to work.. Ben Morrow
• 2013/02/16 [SQL] Volatile functions in WITH Ben Morrow
• 2013/02/15 [SQL] Perform Function When The Rows Of A View Change Adam
• 2013/02/14 Re: [SQL] Summing & Grouping in a Hierarchical Structure Alexander Gataric
• 2013/02/14 [SQL] Summing & Grouping in a Hierarchical Structure Don Parris

• Earlier messages
• Later messages