Mailing lists [pgsql-sql]
- Re: Sometimes referential integrity seems not to work Stephan Szabo
- Re: An order by question Michael Fuhr
- Re: An order by question Tomasz Myrta
- REPLACE lawyerkill@aol.com (LawyerKill)
- Postgres "dblink" Help JinNet Picker
- postgreSQL and Hibernate beyaNet Consultancy
- Executing dynamic queries (EXECUTE) Carla Mello
- Re: An order by question Michael Fuhr
- Re: Executing dynamic queries (EXECUTE) Tomasz Myrta
- update more than 1 table (mysql to postgres) treeml
- Help! Error with postgresql! raingsey@pasteur-kh.org
- Re: Help! Error with postgresql! Paul Hart
- MUKTA
- Re: [PERFORM] Set-Returning Functions WAS: On the performance of Bill Moran
- Re: [PERFORM] Set-Returning Functions WAS: On the performance of Bill Moran
- Re: update more than 1 table (mysql to postgres) postgres@jal.org
- Re: update more than 1 table (mysql to postgres) Christopher Browne
- Re: update more than 1 table (mysql to postgres) Tom Lane
- Re: Richard Huxton
- Re: Sometimes referential integrity seems not to work Jan Wieck
- Re: Sometimes referential integrity seems not to work Rod Taylor
- Re: Sometimes referential integrity seems not to work scott.marlowe
- Novice SQL Question Terry Lee Tucker
- Re: Novice SQL Question Terry Lee Tucker
- Re: Novice SQL Question Tom Lane
- Outer join Russell Shaw
- Re: Outer join Tomasz Myrta
- Re: Outer join Russell Shaw
- Re: locking problem Christoph Haller
- Re: Sometimes referential integrity seems not to work Jan Wieck
- date function problem mohan@physics.gmu.edu
- Re: date function problem Larry Rosenman
- Re: Sometimes referential integrity seems not to work scott.marlowe
- Re: Sometimes referential integrity seems not to work scott.marlowe
- Re: date function problem Tomasz Myrta
- request to plsql tutorial arun raj
- Prashanthi Muthyala
- Re: Executing dynamic queries (EXECUTE) Carla Mello
- SQL query pawel@deso.pl (Paul Czubilinski)
- Re: scott.marlowe
- Re: Richard Huxton
- Re: request to plsql tutorial Richard Huxton
- Re: Jan Wieck
- Re: SQL query daq
- Update from same table Jürgen Cappel
- Re: Update from same table Josh Berkus
- TIME ZONE SQL Raman
- Re: TIME ZONE SQL Richard Huxton
- Slow sub-selects, max and count(*) Richard Sydney-Smith
- Re: Slow sub-selects, max and count(*) Josh Berkus
- Re: Slow sub-selects, max and count(*) Iain
- Re: TIME ZONE SQL Raman
- Re: TIME ZONE SQL Richard Huxton
- Re: TIME ZONE SQL Raman Garg
- Re: TIME ZONE SQL Richard Huxton
- Re: TIME ZONE SQL Tom Lane
- Could not convert UTF-8 to ISO8859-1 Chris Anderson
- Re: Slow sub-selects, max and count(*) Richard Sydney-Smith
- Re: Slow sub-selects, max and count(*) Bruno Wolff III
- Re: Slow sub-selects, max and count(*) Josh Berkus
- unsubscribe Mona H. Kapadia
- [Fwd: Re: [PERFORM] Seq scan on zero-parameters function] Tomasz Myrta
- Re: [PERFORM] Seq scan on zero-parameters function Tomasz Myrta
- alias problem on join Gary Stainburn
- Re: alias problem on join Tomasz Myrta
- unsubscribe jan bok
- Re: Cool ORDER BY feature Jeff Boes
- Re: [PERFORM] Seq scan on zero-parameters function Octavio Alvarez
- techniques for manual ordering of data ? Peter Galbavy
- Re: Storing a range of numbers Chris Fisher
- Re: Storing a range of numbers CoL
- Re: Storing a range of numbers Tom Lane
- determining how many products are in how many categories David Garamond
- unsubscribe Mona
- Disable/Enable Trigger? Philippe Lang
- Implementation of a bag pattern using rules Mark Gibson
- Index not used - now me Christoph Haller
- Re: Implementation of a bag pattern using rules Robert Creager
- Re: Implementation of a bag pattern using rules Mark Gibson
- Re: Index not used - now me Paul Thomas
- Re: Implementation of a bag pattern using rules Richard Sydney-Smith
- Re: Index not used - now me Christoph Haller
- timestamptz - problems Mark Roberts
- Re: Index not used - now me Greg Stark
- Re: Implementation of a bag pattern using rules Tom Lane
- Re: timestamptz - problems Christopher Browne
- Re: Index not used - now me Tom Lane
- Re: Implementation of a bag pattern using rules Mark Gibson
- Re: Index not used - now me Paul Thomas
- Re: Implementation of a bag pattern using rules Mark Gibson
- Multiple outer join on same table Marco Lazzeri
- Re: techniques for manual ordering of data ? scott.marlowe
- Re: Implementation of a bag pattern using rules Robert Creager
- Bug or Feature? Herbert R. Ambos
- Error in declaring %rowtype for recurrence Kumar
- Re: Bug or Feature? Tom Lane
- Re: Error in declaring %rowtype for recurrence Tom Lane
- Re: Error in declaring %rowtype for recurrence Kumar
- Unique Constraint with foreign Key mohan@physics.gmu.edu
- Re: Unique Constraint with foreign Key Bruno Wolff III
- Elegant way to monitor for changes in a trigger and migrate record to history table David B
- unsubscribe Mona
- Re: Elegant way to monitor for changes in a trigger and migrate Mark Gibson
- Re: Multiple outer join on same table Markus Bertheau
- 7.4 - FK constraint performance ow
- Re: 7.4 - FK constraint performance Stephan Szabo
- Re: 7.4 - FK constraint performance Tom Lane
- Re: max timestamp boyd (remove_) tb_moore_@bealenet_.com
- cascade delete sad
- Re: cascade delete sad
- How to avoid nulls while writing string for dynamic query Kumar
- Re: How to avoid nulls while writing string for dynamic query Tomasz Myrta
- Re: 7.4 - FK constraint performance ow
- Re: array_lower /array_prepend doubt Bruce Momjian
- Re: 7.4 - FK constraint performance Stephan Szabo
- Re: 7.4 - FK constraint performance Stephan Szabo
- Re: 7.4 - FK constraint performance Tom Lane
- Re: 7.4 - FK constraint performance ow
- test beyaRecords - The home Urban music
- Re: 7.4 - FK constraint performance ow
- Re: 7.4 - FK constraint performance ow
- Re: 7.4 - FK constraint performance Tom Lane
- Re: 7.4 - FK constraint performance Tom Lane
- Re: array_lower /array_prepend doubt Bruce Momjian
- Re: array_lower /array_prepend doubt Joe Conway
- Re: 7.4 - FK constraint performance ow
- Re: 7.4 - FK constraint performance Tom Lane
- Re: 7.4 - FK constraint performance ow
- Index question David Witham
- Re: 7.4 - FK constraint performance Tom Lane
- Re: 7.4 - FK constraint performance Tom Lane
- Re: How to avoid nulls while writing string for dynamic query Kumar
- Re: Index question Tom Lane
- Re: How to avoid nulls while writing string for dynamic query Kumar
- Re: Index question David Witham
- Re: How to avoid nulls while writing string for dynamic query Tomasz Myrta
- How to unsubscribe Mona
- Re: How to avoid nulls while writing string for dynamic query Kumar
- Re: 7.4 - FK constraint performance Richard Huxton
- Re: How to avoid nulls while writing string for dynamic query Tomasz Myrta
- Re: How to avoid nulls while writing string for dynamic query Kumar
- Re: How to avoid nulls while writing string for dynamic query Tomasz Myrta
- arrays and polygons David
- column alias and group by/having/order Tomasz Myrta
- Re: column alias and group by/having/order Rod Taylor
- Re: arrays and polygons Tom Lane
- Re: 7.4 - FK constraint performance Stephan Szabo
- Re: column alias and group by/having/order Tom Lane
- Re: 7.4 - FK constraint performance Tom Lane
- Re: 7.4 - FK constraint performance Stephan Szabo
- Re: 7.4 - FK constraint performance Tom Lane
- Re: 7.4 - FK constraint performance Stephan Szabo
- Re: arrays and polygons David
- Re: arrays and polygons Joe Conway
- Passing composite values to functions Jatinder Sangha
- Re: 7.4 - FK constraint performance Rod Taylor
- Re: 7.4 - FK constraint performance Rod Taylor
- Re: 7.4 - FK constraint performance Rod Taylor
- nextval problem Ivo Anon
- Function Sumita Biswas (sbiswas)
- Re: determining how many products are in how many categories Greg Patnude
- bytea or blobs? beyaNet Consultancy
- Re: 7.4 - FK constraint performance Rod Taylor
- Re: 7.4 - FK constraint performance Rod Taylor
- nextval problem Ivo Anon
- ORDER BY TIMESTAMP_column ASC, NULL first Fredrik Wendt
- Function Sumita Biswas (sbiswas)
- Re: determining how many products are in how many categories Greg Patnude
- bytea or blobs? beyaNet Consultancy
- Re: Unique Constraint with foreign Key Greg Patnude
- returning multiple resultset? iseyfi@vt.edu (ismail)
- Unable to convert date to tm Ramiro Arenas R
- max timestamp stermic@gw.co.jackson.mo.us (Michael Sterling)
- umlimited arguments on function Christian Hergert
- Trace for postgreSQL beyaNet Consultancy
- writing a dynamic sql Senthil Kumar S
- Re: returning multiple resultset? Tom Lane
- Re: ORDER BY TIMESTAMP_column ASC, NULL first Tomasz Myrta
- Re: max timestamp Stephan Szabo
- Re: ORDER BY TIMESTAMP_column ASC, NULL first Stephan Szabo
- Re: Unable to convert date to tm Tom Lane
- Re: max timestamp Robert Creager
- Re: max timestamp Tomasz Myrta
- Re: writing a dynamic sql Tomasz Myrta
- Re: max timestamp Bruno Wolff III
- Re: Function Stephan Szabo
- Re: ORDER BY TIMESTAMP_column ASC, NULL first Rod Taylor
- Re: bytea or blobs? Dana Hudes
- Re: Passing composite values to functions Tom Lane
- Re: umlimited arguments on function Robert Treat
- Re: ORDER BY TIMESTAMP_column ASC, NULL first Denis
- Re: max timestamp Denis
- Getting the week of a date Kumar
- Re: Getting the week of a date Robert Creager
- Re: Getting the week of a date Richard Huxton
- Re: Getting the week of a date sad
- Date format problems Mark Roberts
- Re: Getting the week of a date sad
- Re: Date format problems Tom Lane
- Tip: a function for creating a remote view using dblink Mark Gibson
- Re: Date format problems Mark Roberts
- Re: Date format problems Tom Lane
- Re: Function Stephan Szabo
- Re: Getting the week of a date Kumar
- Re: Getting the week of a date Kumar
- Re: Tip: a function for creating a remote view using dblink Karsten Hilbert
- Re: Trace for postgreSQL Andrew Sullivan
- Re: Unique Constraint with foreign Key Jan Wieck
- Ok, what am I doing wrong here? Karl Denninger
- Re: bytea or blobs? Jan Wieck
- Re: Ok, what am I doing wrong here? Marc G. Fournier
- Re: Ok, what am I doing wrong here? Stephan Szabo
- Re: Ok, what am I doing wrong here? Tomasz Myrta
- Re: Ok, what am I doing wrong here? Karl Denninger
- Re: bytea or blobs? Jeremy Smith
- need help with os x objects into a db Theodore Petrosky
- Re: Tip: a function for creating a remote view using dblink Josh Berkus
- CHAR(n) always trims trailing spaces in 7.4 news.postgresql.org
- FW: Function Sumita Biswas (sbiswas)
- Re: nextval problem Greg Patnude
- Re: Function Sumita Biswas (sbiswas)
- SQL query seach + rearranging results lowdog
- Re: Unique Constraint with foreign Key Greg Patnude
- Return relation table data in a single value CSV
- Re: bytea or blobs? Jan Wieck
- Re: SQL query seach + rearranging results Richard Huxton
- Re: FW: Function Richard Huxton
- Re: Return relation table data in a single value CSV Richard Huxton
- Re: Function scott.marlowe
- Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane
- Re: CHAR(n) always trims trailing spaces in 7.4 elein
- Re: Return relation table data in a single value CSV Tom Lane
- Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane
- Re: CHAR(n) always trims trailing spaces in 7.4 elein
- Re: CHAR(n) always trims trailing spaces in 7.4 scott.marlowe
- Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane
- Re: CHAR(n) always trims trailing spaces in 7.4
- Re: CHAR(n) always trims trailing spaces in 7.4 elein
- Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane
- Indexes and statistics David Witham
- Re: Indexes and statistics Tom Lane
- Re: bytea or blobs? sad
- Re: Indexes and statistics David Witham
- Re: bytea or blobs? Dana Hudes
- Re: bytea or blobs? Achilleus Mantzios
- Disabling constraints Kumar
- Re: Return relation table data in a single value CSV Richard Huxton
- Re: CHAR(n) always trims trailing spaces in 7.4 Richard Huxton
- Re: bytea or blobs? Richard Huxton
- Re: bytea or blobs? Dana Hudes
- Re: Indexes and statistics Tom Lane
- Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane
- Re: bytea or blobs? Richard Huxton
- Re: CHAR(n) always trims trailing spaces in 7.4 Jeremy Smith
- Inserting NULL into Integer column Jeremy Smith
- Re: Inserting NULL into Integer column scott.marlowe
- Re: CHAR(n) always trims trailing spaces in 7.4 elein
- Re: Inserting NULL into Integer column Jeremy Smith
- Re: Inserting NULL into Integer column scott.marlowe
- Re: Inserting NULL into Integer column Jeremy Smith
- Re: Inserting NULL into Integer column scott.marlowe
- Re: Inserting NULL into Integer column Rod Taylor
- Re: Inserting NULL into Integer column scott.marlowe
- Re: Inserting NULL into Integer column Rod Taylor
- Re: Inserting NULL into Integer column scott.marlowe
- Need some help with crafting a query to do major update Sean Shanny
- Re: Need some help with crafting a query to do major update Stephan Szabo
- Re: Indexes and statistics Iain
- Distributed Transactions George A.J
- Re: Distributed Transactions Josh Berkus
- Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane
- Compiling pl/pgsql functions Rodrigo Sakai
- Re: Compiling pl/pgsql functions Viorel Dragomir
- crosstabs Philippe Lang
- Re: Compiling pl/pgsql functions Stephan Szabo
- Re: Distributed Transactions scott.marlowe
- Re: crosstabs Philippe Lang
- Re: crosstabs Richard Huxton
- DISTINCT ON troubles Jeremy Smith
- Re: Compiling pl/pgsql functions Rodrigo Sakai
- Re: CHAR(n) always trims trailing spaces in 7.4 elein
- Re: crosstabs Joe Conway
- Re: Compiling pl/pgsql functions Joe Conway
- Re: Compiling pl/pgsql functions Josh Berkus
- Re: DISTINCT ON troubles Josh Berkus
- Re: DISTINCT ON troubles Jeremy Smith
- Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane
- Re: Compiling pl/pgsql functions Richard Huxton
- Re: DISTINCT ON troubles Brian Knox
- Re: Compiling pl/pgsql functions Jan Wieck
- Re: DISTINCT ON troubles scott.marlowe
- Re: DISTINCT ON troubles scott.marlowe
- Re: Distributed Transactions Tom Lane
- Help refining/eliminating recursive selects Edmund Bacon
- Re: Help refining/eliminating recursive selects Stephan Szabo
- Re: Help refining/eliminating recursive selects Yudie
- Row counts/data changes. Any catalog table that has this info? David B
- pg_restore - don´t restore. Why? 2000info
- Problem with FOR SELECT in plpgsql function Plant Thomas
- Re: Problem with FOR SELECT in plpgsql function Richard Huxton
- Re: pg_restore - don?t restore. Why? Andrew Sullivan
- Re: bytea or blobs? Igor Shevchenko
- create function atof? mark
- Re: create function atof? Achilleus Mantzios
- Re: create function atof? Tom Lane
- date format in 7.4 Silke Trissl
- Re: date format in 7.4 Tom Lane
- Re: date format in 7.4 scott.marlowe
- Creating constraint sometime fail in a transaction Olivier Hubaut
- Re: date format in 7.4 Richard Huxton
- Re: Creating constraint sometime fail in a transaction Tom Lane
- Re: Row counts/data changes. Any catalog table that has this info? Josh Berkus
- Re: Date Foo. Brian Knox
- Re: Date Foo. scott.marlowe
- searching polygons David
- create function atof? Mark Tabash
- transaction block causing trouble Fabian
- Re: Function Sumita Biswas
- Binary retrieval - *Best practice* recommendations... beyaNet Consultancy
- Re: Function Sumita Biswas
- Re: Function Sumita Biswas
- User defined types -- Social Security number... Greg Patnude
- SQL / Join Help fasteddie_g@yahoo.com (FastEddie)
- Re: Date / interval question Gnugeek
- Re: Compiling pl/pgsql functions Rod Taylor
- postgresql multiple insert slow Michael L. Hostbaek
- Re: Function V i s h a l Kashyap @ [Sai Hertz And Control Systems]
- Re: Function V i s h a l Kashyap @ [Sai Hertz And Control Systems]
- Re: postgresql multiple insert slow Tom Lane
- Re: Function Tom Lane
- Re: postgresql multiple insert slow Christopher Browne
- Re: searching polygons elein
- Re: User defined types -- Social Security number... Josh Berkus
- Re: Compiling pl/pgsql functions Josh Berkus
- Re: Postgres DB Tom Lane
- Re: User defined types -- Social Security number... Christopher Browne
- Enterprice support in PostgreSQL George A.J
- Materialized View Summary Jonathan M. Gardner
- Re: Materialized View Summary Richard Huxton
- tsearch2 trigger alternative Chris Gamache
- Re: [HACKERS] Materialized View Summary Robert Treat
- Re: [HACKERS] Materialized View Summary Jonathan M. Gardner
- Re: [HACKERS] Materialized View Summary Mark Gibson
- Last day of month Kumar
- Re: [PERFORM] [HACKERS] Materialized View Summary Robert Treat
- Scalar in a range (but textual not numeric) Richard Huxton
- Re: Scalar in a range (but textual not numeric) Richard Huxton
- Re: Scalar in a range (but textual not numeric) Joe Conway
- Re: Scalar in a range (but textual not numeric) Tom Lane
- Re: Scalar in a range (but textual not numeric) Richard Huxton
- Re: Scalar in a range (but textual not numeric) Richard Huxton
- Re: Scalar in a range (but textual not numeric) Tom Lane
- Re: Scalar in a range (but textual not numeric) Tom Lane
- Re: Last day of month Greg Sabino Mullane
- updating remote database Kenneth Gonsalves
- Re: Last day of month Joe Conway
- Re: Last day of month Joe Conway
- Re: Scalar in a range (but textual not numeric) Richard Huxton
- Re: updating remote database Richard Huxton
- Re: updating remote database Olivier Hubaut
- Re: updating remote database Achilleus Mantzios
- Return more than a record Kumar
- Re: Field list from table Christopher Browne
- Re: Last day of month Frank Bax
- Re: Scalar in a range (but textual not numeric) Edmund Bacon
- Re: Scalar in a range (but textual not numeric) Bruno Wolff III
- Re: Return more than a record Stephan Szabo
- a few Questions about quoted varaibles in psql Leo Leo
- Re: Last day of month Michael Chaney
- Re: Return more than a record Kumar
- Re: Return more than a record Stephan Szabo
- Re: BUG #1083: Insert query reordering interacts badly with Bruno Wolff III
- Convert INT to INTERVAL? Brian Knox
- Re: Convert INT to INTERVAL? Stephan Szabo
- Re: searching polygons David
- Re: Convert INT to INTERVAL? Bruno Wolff III
- Re: Convert INT to INTERVAL? Michael Chaney
- Re: Convert INT to INTERVAL? Tom Lane
- Re: User defined types -- Social Security number... Bruce Momjian
- Input Arguments Sumita Biswas
- Re: Postgres DB Sumita Biswas
- Re: Error Number in Function Sumita Biswas
- DATEADD Sumita Biswas
- EXECUTing QUERY: Sumita Biswas
- Re: Postgres DB Sumita Biswas
- Re: Enterprice support in PostgreSQL Bruce Momjian
- returning a recordset from PLpg/SQL Terence Kearns
- Re: returning a recordset from PLpg/SQL Tom Lane
- Re: User defined types -- Social Security number... Greg Patnude
- Execute Query in Postgres Function Sumita Biswas (sbiswas)
- plpgsql function returning SETOF RECORD Question
- Triggers Philip J. Boonzaaier
- VIEW on lookup table JJ Gabor
- Field list from table Jan Pips
- unicode(utf-8) problem ! john
- Re: [HACKERS] Materialized View Summary Hans-Jürgen Schönig
- Unicode Support Sumita Biswas (sbiswas)
- CURSORS - Please help urgent. Sumita Biswas (sbiswas)
- Re: [HACKERS] Materialized View Summary Jonathan Gardner
- PLSQL Question regarding multiple inserts Humble Geek
- Trouble with composite types Yasir Malik
- Re: Field list from table rixder@o2.pl
- Re: plpgsql function returning SETOF RECORD Question Joe Conway
- Re: Trouble with composite types Joe Conway