Mailing lists [pgsql-sql]
- A Not Join L van der Walt
- Re: Fwd: Re: Referencing Daryl Richter
- Re: [GENERAL] A Not Join Jim C. Nasby
- Index lookup on > and < criteria David Durham
- Re: Index lookup on > and < criteria A. Kretschmer
- Re: Index lookup on > and < criteria Michael Fuhr
- PGSQL encryption functions Mark R. Dingee
- Re: PGSQL encryption functions Josh Berkus
- Re: Index lookup on > and < criteria David Durham
- Re: PGSQL encryption functions Bruno Wolff III
- Re: PGSQL encryption functions Mark R. Dingee
- Can't Get SETOF Function to Work Lane Van Ingen
- Re: PGSQL encryption functions Mark R. Dingee
- Re: PGSQL encryption functions Tom Lane
- Re: Nested Table in PostgreSQL or some alternative Variants Jim C. Nasby
- Re: Can't Get SETOF Function to Work Michael Fuhr
- Re: Index lookup on > and < criteria Michael Fuhr
- Re: Can't Get SETOF Function to Work Lane Van Ingen
- Re: PGSQL encryption functions Mario Splivalo
- Re: PGSQL encryption functions Mark R. Dingee
- function, that uses different table(names) Moritz Bayer
- Re: function, that uses different table(names) Moritz Bayer
- Re: function, that uses different table(names) A. Kretschmer
- Re: function, that uses different table(names) A. Kretschmer
- Re: PGSQL encryption functions Neil Saunders
- Re: function, that uses different table(names) Moritz Bayer
- Re: PGSQL encryption functions Tom Lane
- Function with dynamic command (EXECUTE) not working Robert Blixt
- Re: function, that uses different table(names) Tom Lane
- Re: PGSQL encryption functions Bruno Wolff III
- Designing a stock portfolio database Shane
- Re: Index lookup on > and < criteria David Durham
- Re: PGSQL encryption functions Mark R. Dingee
- Re: PGSQL encryption functions Bruno Wolff III
- Re: Poor performance in inet << cidr join (Resolved) Axel Rau
- Re: Poor performance in inet << cidr join (Resolved) Tom Lane
- User input in psql Ashok Agrawal
- Re: User input in psql Richard Huxton
- Re: Poor performance in inet << cidr join (Resolved) Axel Rau
- Slow query - SELECTing one row from 'big' table. Mario Splivalo
- Re: Welcome to the pgsql-sql list! Achilleus Mantzios
- Re: Slow query - SELECTing one row from 'big' table. Tom Lane
- Encoding on 8.0.4 Don Drake
- date question Judith Altamirano Figueroa
- Re: date question lucas@presserv.org
- Re: date question Michael Glaesemann
- Design question: Scalability and tens of thousands of tables? zackchandler
- JOIN condition confusion Thomas Good
- serial in output alessandra de gregorio
- Changing location of ORDER BY has large effect on performance, but not results... Jason Turner
- Re: Design question: Scalability and tens of thousands of tables? Michael Glaesemann
- unsubscribe oliverp21@free.fr
- Re: JOIN condition confusion Richard Huxton
- Re: Changing location of ORDER BY has large effect on performance, but not results... Tom Lane
- Re: serial in output Andreas Kretschmer
- Re: serial in output Harald Fuchs
- Re: Design question: Scalability and tens of thousands of tables? James Robinson
- Re: Design question: Scalability and tens of thousands of tables? Christopher Browne
- can not connect to pg on linux FC4 Tai Huynh Phuoc
- Extract table columns in tabular form frank church
- Re: Extract table columns in tabular form A. Kretschmer
- Re: Extract table columns in tabular form Christopher Browne
- Insert large text to text column Tai Huynh Phuoc
- Extract week from date, start with sunday Robert Blixt
- Re: Extract week from date, start with sunday A. Kretschmer
- Re: Extract week from date, start with sunday Robert Blixt
- Extract date from week lucas@presserv.org
- Re: Returning rows as columns codeWarrior
- Re: Extract date from week Jaime Casanova
- Re: can not connect to pg on linux FC4 Oliver Elphick
- Re: Design question: Scalability and tens of thousands of george young
- Migrating database from postgresql 7.4.6 to postgresql 8.0.3 Louise Catherine
- Re: Migrating database from postgresql 7.4.6 to postgresql 8.0.3 A. Kretschmer
- Re: Migrating database from postgresql 7.4.6 to postgresql Achilleus Mantzios
- migratation of database from oracle9i to postgreSQL8.0.3 zenith Das
- Como ejecutar una funcion insert en plpgsql.... Fernando Garcia
- Re: Como ejecutar una funcion insert en plpgsql.... Mauricio Fernandez A.
- RETURNS SETOF table; language 'sql' Mario Splivalo
- Re: RETURNS SETOF table; language 'sql' Tom Lane
- Re: Design question: Scalability and tens of thousands of Zack Chandler
- Re: RETURNS SETOF table; language 'sql' Mario Splivalo
- Re: RETURNS SETOF table; language 'sql' Tom Lane
- Re: RETURNS SETOF table; language 'sql' Mario Splivalo
- Re: Como ejecutar una funcion insert en plpgsql.... Gregory S. Williamson
- Re: Como ejecutar una funcion insert en plpgsql.... Gregory S. Williamson
- Re: time Judith Altamirano Figueroa
- how to update table to make dup values distinct george young
- Re: RETURNS SETOF table; language 'sql' codeWarrior
- Re: migratation of database from oracle9i to postgreSQL8.0.3 Samer Abukhait
- time Judith Altamirano Figueroa
- Re: time Rod Taylor
- Re: time Michael Fuhr
- Re: time Rod Taylor
- Re: time Michael Fuhr
- Re: time Tom Lane
- Re: time Michael Fuhr
- Re: time Tadej Kanizar
- Re: time Michael Fuhr
- High level discussion for design of using ACL to retrieve Data Joel Fradkin
- Re: how to update table to make dup values distinct Bruno Wolff III
- Re: Como ejecutar una funcion insert en plpgsql.... Gregory S. Williamson
- Re: High level discussion for design of using ACL to retrieve Data Joel Fradkin
- Re: how to update table to make dup values distinct Harald Fuchs
- cli in sql? Frank Bax
- Re: cli in sql? A. Kretschmer
- Re: cli in sql? Greg Sabino Mullane
- Re: cli in sql? Frank Bax
- pg_dump Judith Altamirano Figueroa
- Re: cli in sql? Tom Lane
- Problem with "NOT IN (subquery) Steve SAUTETNER
- Re: Problem with "NOT IN (subquery) Stephan Szabo
- Re: Problem with "NOT IN (subquery) - use NOT EXISTS chester c young
- Re: Problem with "NOT IN (subquery) Christian Paul B. Cosinas
- selective dump pg_dump: only specific non-tables? with schema name? Bath, David
- Connection Oracle database from Postgres function Dinesh Pandey
- How to Log SELECT Statements Having Errors Lane Van Ingen
- Re: How to Log SELECT Statements Having Errors Richard Huxton
- Re: How to Log SELECT Statements Having Errors Magnus Hagander
- Re: pg_dump Oliver Elphick
- Re: How to Log SELECT Statements Having Errors Lane Van Ingen
- Performance of a view John McCawley
- Arrya variable as argument to IN expression Emil Kaffeshop
- Re: Arrya variable as argument to IN expression Achilleus Mantzios
- Re: Arrya variable as argument to IN expression A. Kretschmer
- idea for a geographically distributed database: how best to implement? Andy Ballingall
- Re: Arrya variable as argument to IN expression Tom Lane
- Re: idea for a geographically distributed database: how best to implement? codeWarrior
- Re: idea for a geographically distributed database: how best Achilleus Mantzios
- Re: idea for a geographically distributed database: how best to implement? Andy Ballingall
- Re: idea for a geographically distributed database: how best Andy Ballingall
- Geographic DB PaulD
- Geographic DB PaulD
- Geographic Distance Calc website PaulD
- Re: Geographic Distance Calc website Michael Fuhr
- timestamp SQL question Brian Doyle
- Re: timestamp SQL question codeWarrior
- Brian Doyle
- how to do a find and replace Dawn Buie
- how to do a find and replace Dawn Buie
- Re: how to do a find and replace Bricklen Anderson
- Re: how to do a find and replace Dawn Buie
- Re: how to do a find and replace Bricklen Anderson
- Re: how to do a find and replace Hélder M. Vieira
- Re: how to do a find and replace A. Kretschmer
- query Aftab Alam
- Re: idea for a geographically distributed database: how best to implement? Andy Ballingall
- Re: how to do a find and replace Andrew Sullivan
- Re: idea for a geographically distributed database: how best to implement? Andrew Sullivan
- Export to XML Warren Murray
- [postgres] pgcluster Stephan Fischer
- idea for a geographically distributed database: how best to implement? Andy Ballingall
- Re: Export to XML Dean Gibson (DB Administrator)
- DISTINCT ON Jeremy Palmer
- Re: DISTINCT ON Michael Glaesemann
- Re: DISTINCT ON Jeremy Palmer
- Re: DISTINCT ON Michael Glaesemann
- Re: DISTINCT ON Jeremy Palmer
- Re: Export to XML Nikolay Samokhvalov
- Re: DISTINCT ON Bruno Wolff III
- Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall
- Create Public Schema
- Re: Create Public Schema Andreas Kretschmer
- Trigger / rule question Joost Kraaijeveld
- Re: Create Public Schema Mario Splivalo
- Re: Is it possible to redirect an update/insert/delete to a different table? Peter Eisentraut
- Re: Trigger / rule question Peter Eisentraut
- Re: Is it possible to redirect an update/insert/delete to a different table? Jaime Casanova
- Re: Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall
- Re: Trigger / rule question Joost Kraaijeveld
- Re: Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall
- Re: Is it possible to redirect an update/insert/delete to a different table? Andreas Kretschmer
- Re: Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall
- Re: Is it possible to redirect an update/insert/delete to a different table? Andreas Kretschmer
- Re: Is it possible to redirect an update/insert/delete to a different table? Andreas Kretschmer
- Re: Is it possible to redirect an update/insert/delete to a different table? Andy Ballingall
- Please help to wite the constraint. Grigory O. Ptashko
- Re: Is it possible to redirect an update/insert/delete to a different table? Adrian Klaver
- max() unexpected type conversion Hélder M. Vieira
- Re: max() unexpected type conversion Tom Lane
- tid_le comparison for tuple id (ctid) values? george young
- Re: tid_le comparison for tuple id (ctid) values? Tom Lane
- Re: idea for a geographically distributed database: how best to implement? Bath, David
- unplanned sub-select error? Kyle Bateman
- Re: unplanned sub-select error? Tom Lane
- Re: tid_le comparison for tuple id (ctid) values? george young
- Re: max() unexpected type conversion Hélder M. Vieira
- Re: Please help to wite the constraint. Samer Abukhait
- Re: tid_le comparison for tuple id (ctid) values? Richard Huxton
- Re: tid_le comparison for tuple id (ctid) values? Richard Huxton
- Re: Please help to wite the constraint. Grigory O. Ptashko
- Re: idea for a geographically distributed database: how best to implement? Andy Ballingall
- Triggers Leif B. Kristensen
- Foreign key to 2 tables problem Joost Kraaijeveld
- Re: Triggers Achilleus Mantzios
- Re: Foreign key to 2 tables problem Neil Saunders
- Re: Foreign key to 2 tables problem Achilleus Mantzios
- Re: Foreign key to 2 tables problem John McCawley
- Re: Foreign key to 2 tables problem Rod Taylor
- Re: Foreign key to 2 tables problem John McCawley
- Re: Triggers Leif B. Kristensen
- Re: Triggers Achilleus Mantzios
- Re: Triggers Neil Saunders
- deferrable on unique chester c young
- Re: Triggers Neil Saunders
- Re: deferrable on unique John McCawley
- Re: Triggers Leif B. Kristensen
- can UNIQUEness of TEXT datatype really be guaranteed?
- Re: can UNIQUEness of TEXT datatype really be guaranteed? Jaime Casanova
- Re: can UNIQUEness of TEXT datatype really be guaranteed? Tom Lane
- Re: unplanned sub-select error? Kyle Bateman
- Re: unplanned sub-select error? Tom Lane
- argument type problem with plpgsql function Luca Pireddu
- Re: argument type problem with plpgsql function Stephan Szabo
- Re: argument type problem with plpgsql function Luca Pireddu
- Re: argument type problem with plpgsql function Tom Lane
- Re: argument type problem with plpgsql function Luca Pireddu
- Re: Triggers Achilleus Mantzios
- Default on update lucas@presserv.org
- Re: Default on update Richard Huxton
- Re: Default on update lucas@presserv.org
- OUT OF THIS LIST...... Fernando Garcia
- Re: Default on update Richard Huxton
- what is going on in the PostgreSQL Eugene E.
- sysid A. R. Van Hook
- Re: sysid Jaime Casanova
- Re: sysid Alvaro Herrera
- Re: unplanned sub-select error? Tom Lane
- Re: what is going on in the PostgreSQL Michael Fuhr
- Ken Winter
- Index wonder Leif B. Kristensen
- Re: Oliver Elphick
- Re: Achilleus Mantzios
- does indexes need statistics? Mauricio Fernandez A.
- Updatable views: any decent front-ends? Bath, David
- Changing auth type in pg_hba.conf ineffective. Why? Bryce Nesbitt
- Re: Changing auth type in pg_hba.conf ineffective. Why? Alvaro Herrera
- Re: Changing auth type in pg_hba.conf ineffective. Why? Tom Lane
- Re: Changing auth type in pg_hba.conf ineffective. Why? Bryce Nesbitt
- Re: Changing auth type in pg_hba.conf ineffective. Why? Bryce Nesbitt
- Re: does indexes need statistics? Andrew Sullivan
- Re: Updatable views: any decent front-ends? Thomas Kellerer
- Re: LISTEN/NOTIFY Stéphane RIFF
- LISTEN/NOTIFY Stéphane RIFF
- Variable column names in PL/pgSQL RECORD referencces Ken Winter
- Re: Variable column names in PL/pgSQL RECORD referencces Tom Lane
- Order of precedence between AND and OR. David Pradier
- Re: Order of precedence between AND and OR. Tom Lane
- Re: sysid Vivek Khera
- How to change database owner in PostgreSQL 7.4? frank church
- Re: How to change database owner in PostgreSQL 7.4? Andreas Kretschmer
- Re: Is it possible to redirect an update/insert/delete to a different table? JuanCri
- Re: query JuanCri
- Storing HTML in table Rob
- Re: A Not Join stig erikson
- Drop functions Wim Audenaert
- join if all matches Sim Zacks
- MAX, MIN and arrays Colton A Smith
- Re: MAX, MIN and arrays Andreas Kretschmer
- Re: Storing HTML in table Greg Stark
- Anual Query Mauricio Fernandez A.
- Re: Anual Query Frank Bax
- DEFAULT Constraint based on table type? Announce
- Re: DEFAULT Constraint based on table type? Jaime Casanova
- Re: DEFAULT Constraint based on table type? Rod Taylor
- Re: join if all matches Bruno Wolff III
- Re: DEFAULT Constraint based on table type? Oliver Elphick
- Re: DEFAULT Constraint based on table type? Oliver Elphick
- Re: How to change database owner in PostgreSQL 7.4? frank church
- Strange bug Leif B. Kristensen
- Re: Strange bug Tom Lane
- Re: Strange bug A. Kretschmer
- Re: Strange bug Leif B. Kristensen
- Re: Strange bug Leif B. Kristensen
- Re: Strange bug Leif B. Kristensen
- 'AS' in 'DELETE/UPDATE' engineer@hlebprom.ru
- Re: 'AS' in 'DELETE/UPDATE' Bruce Momjian
- Re: 'AS' in 'DELETE/UPDATE' Jaime Casanova
- Re: Strange bug Leif B. Kristensen
- Re: Triggers Jan Wieck
- Help needed NosyMan
- Re: Help needed Richard Huxton
- Archives site down? Neil Saunders
- Re: Archives site down? Martín Marqués
- Re: problems with array george young
- child fk problem Luis Silva
- quote_literal() fails with unmatched quotes James M Doherty
- Re: quote_literal() fails with unmatched quotes Tom Lane
- Quote_literal() James M Doherty
- Re: quote_literal() fails with unmatched quotes James M Doherty
- Re: child fk problem Scott Marlowe
- Re: Quote_literal() Tom Lane