Mailing lists [pgsql-sql]
- Re: SQL error: function round(double precision, integer) does Tom Lane
- Re: AutoCommit and DDL Don Drake
- Re: table constraints Andrew - Supernews
- Re: AutoCommit and DDL Andrew - Supernews
- Re: table constraints Casey T. Deccio
- crosstab Theo Galanakis
- Re: crosstab Josh Berkus
- Performance of Views Steffen Boehme
- psql encoding problem T E Schmitz
- Re: Postgres performance bertolima@yahoo.it (mauro)
- Re: Advanced SELECT Kai Hessing
- Postgresql FK to MS SQL triggers Igor Kryltsov
- Re: table constraints Greg Patnude
- Re: psql encoding problem Ragnar Hafstað
- Re: Postgres performance Michael Fuhr
- Re: Postgres performance Richard Huxton
- Re: Postgres performance Richard Huxton
- Multiples schemas lucas@presserv.org
- Re: Postgres performance Richard Huxton
- Re: psql encoding problem Joel Fradkin
- Re: Multiples schemas Peter Eisentraut
- Re: Postgres performance Scott Marlowe
- Re: table constraints Casey T. Deccio
- definative way to place secs from epoc into timestamp column Bret Hughes
- Re: psql encoding problem T E Schmitz
- Re: definative way to place secs from epoc into timestamp column Tom Lane
- Re: definative way to place secs from epoc into timestamp Bret Hughes
- Re: definative way to place secs from epoc into timestamp Tom Lane
- Re: Postgres performance PFC
- Re: Postgres performance Scott Marlowe
- Re: Postgres performance Andrew Sullivan
- Re: Postgres performance Ian Barwick
- Building a database from a flat file Casey T. Deccio
- Re: definative way to place secs from epoc into timestamp Bret Hughes
- Re: definative way to place secs from epoc into timestamp Tom Lane
- Re: definative way to place secs from epoc into timestamp Michael Glaesemann
- how to monitor the archiving process? Smit
- Re: definative way to place secs from epoc into timestamp Bret Hughes
- Re: definative way to place secs from epoc into timestamp Bret Hughes
- how to speed up these queries ? Dracula 007
- Re: Multiples schemas Markus Schaber
- Re: how to speed up these queries ? Sean Davis
- Re: Building a database from a flat file Sean Davis
- Re: how to speed up these queries ? Sean Davis
- Re: [WW Spam: medium] Building a database from a flat file RobertD.Stewart@ky.gov
- Re: Performance of Views Christoph Haller
- Re: Building a database from a flat file Markus Schaber
- Re: Postgres performance Christopher Browne
- Re: Building a database from a flat file Casey T. Deccio
- Re: Building a database from a flat file Casey T. Deccio
- Re: Building a database from a flat file Markus Schaber
- Re: Building a database from a flat file Bricklen Anderson
- Re: Building a database from a flat file Sean Davis
- Re: Building a database from a flat file Markus Schaber
- Re: definative way to place secs from epoc into timestamp Andrew - Supernews
- Re: definative way to place secs from epoc into timestamp Bret Hughes
- Re: definative way to place secs from epoc into timestamp Andrew - Supernews
- Re: definative way to place secs from epoc into timestamp Michael Glaesemann
- Re: definative way to place secs from epoc into timestamp Joel Fradkin
- Re: definative way to place secs from epoc into timestamp Tom Lane
- Re: definative way to place secs from epoc into timestamp Ken Johanson
- Re: definative way to place secs from epoc into timestamp Ken Johanson
- date - date returns integer? Andrew Hammond
- Re: date - date returns integer? Bruno Wolff III
- Problem with SQL_ASCII Kai Hessing
- Simple delete takes hours Thomas Mueller
- truncating table permissions Lynwood Stewart
- Re: Postgres performance Mauro Bertoli
- Re: Postgres performance Mauro Bertoli
- Re: Simple delete takes hours Stephan Szabo
- Re: Postgres performance PFC
- Re: Simple delete takes hours PFC
- Re: definative way to place secs from epoc into timestamp Andrew - Supernews
- Re: truncating table permissions Keith Worthington
- Re: definative way to place secs from epoc into timestamp Bret Hughes
- Re: date - date returns integer? Tom Lane
- Re: truncating table permissions Tom Lane
- Re: Simple delete takes hours Thomas Mueller
- Re: Postgresql FK to MS SQL triggers Josh Berkus
- Re: Postgres performance PFC
- Links between rows in a table Stefan Weiss
- count array in plpgsql bandeng
- count array in postgresql bandeng
- Re: Links between rows in a table Bruno Wolff III
- Re: Links between rows in a table Stefan Weiss
- Re: count array in postgresql Michael Fuhr
- Re: Links between rows in a table PFC
- Re: Postgres performance PFC
- Re: Building a database from a flat file Andrew - Supernews
- Re: Links between rows in a table Stefan Weiss
- Re: count array in postgresql bandeng
- Re: count array in postgresql Sean Davis
- Re: count array in postgresql Michael Fuhr
- Postgres schema comparison. Stef
- Re: Postgres schema comparison. Markus Schaber
- simple update from select ?? Gary Stainburn
- Re: [ADMIN] Postgres schema comparison. John DeSoi
- Re: [ADMIN] Postgres schema comparison. Stef
- Maintaining production DBs, making one schema look like the other KÖPFERL Robert
- Re: [ADMIN] Postgres schema comparison. Richard_D_Levine@raytheon.com
- Re: [ADMIN] Postgres schema comparison. Markus Schaber
- Re: [ADMIN] Postgres schema comparison. Stef
- Re: [ADMIN] Postgres schema comparison. Tom Lane
- Re: simple update from select ?? Gary Stainburn
- Re: [ADMIN] Postgres schema comparison. Stef
- Re: [ADMIN] Postgres schema comparison. Stef
- Re: [ADMIN] Postgres schema comparison. Stef
- Re: [ADMIN] Postgres schema comparison. John DeSoi
- Re: [SOLVED] Postgres schema comparison. Stef
- Re: [ADMIN] Postgres schema comparison. Jim Buttafuoco
- Re: Links between rows in a table Bruno Wolff III
- Lambda expressions in SQL KÖPFERL Robert
- Re: Links between rows in a table PFC
- drop view even with dependencies? Henry Ortega
- Re: drop view even with dependencies? Michael Fuhr
- SQL query help? John McGough
- Re: [ADMIN] Postgres schema comparison. Goulet, Dick
- Re: Postgres performance Mauro Bertoli
- Re: Postgres performance Mauro Bertoli
- Re: Postgres performance Mauro Bertoli
- Re: Simple delete takes hours Lynwood Stewart
- Re: SQL query help? Keith Worthington
- Re: SQL query help? Michael Fuhr
- Re: [ADMIN] Postgres schema comparison. Stef
- Query issue/8.0.1/Serendipity Larry Rosenman
- Re: Query issue/8.0.1/Serendipity Richard Huxton
- Re: Query issue/8.0.1/Serendipity Larry Rosenman
- Re: Query issue/8.0.1/Serendipity Michael Glaesemann
- Re: Query issue/8.0.1/Serendipity Larry Rosenman
- Re: Query issue/8.0.1/Serendipity Larry Rosenman
- Re: Query issue/8.0.1/Serendipity Michael Glaesemann
- Re: Query issue/8.0.1/Serendipity Larry Rosenman
- Re: Query issue/8.0.1/Serendipity Tom Lane
- Re: Query issue/8.0.1/Serendipity Larry Rosenman
- Re: Query issue/8.0.1/Serendipity Ian Barwick
- Re: Query issue/8.0.1/Serendipity Larry Rosenman
- datestyle setting Kenneth Gonsalves
- Re: datestyle setting Tom Lane
- Re: datestyle setting Kenneth Gonsalves
- Re: datestyle setting Richard Huxton
- interval +variable Fatih Cerit
- Re: interval +variable Michael Fuhr
- Re: datestyle setting Kenneth Gonsalves
- Re: datestyle setting Richard Huxton
- Re: [ADMIN] Postgres schema comparison. KÖPFERL Robert
- order by question Gary Stainburn
- Re: order by question Richard Huxton
- Re: order by question Achilleus Mantzios
- Table like a field lucas@presserv.org
- Re: interval +variable Bruno Wolff III
- Re: order by question Bruno Wolff III
- Re: order by question Gary Stainburn
- Re: Table like a field Richard Huxton
- Re: order by question Greg Stark
- Re: [SOLVED] Postgres schema comparison. Stef
- Re: interval +variable ALÝ ÇELÝK
- best way to auto-update a field when row is updated Henry Ortega
- Re: best way to auto-update a field when row is updated Larry Rosenman
- Re: best way to auto-update a field when row is updated Scott Marlowe
- pl/pgsql problem with return types Juris Zeltins
- more execution time ALÝ ÇELÝK
- Re: pl/pgsql problem with return types John DeSoi
- Re: pl/pgsql problem with return types Juris Zeltins
- Re: [GENERAL] more execution time Richard Huxton
- Conver bool to text Edmund Bacon
- Re: Conver bool to text Marco Manfredini
- Parameterized views proposition Tambet Matiisen
- Re: Parameterized views proposition PFC
- Re: Parameterized views proposition Tambet Matiisen
- Re: Parameterized views proposition Bruno Wolff III
- Re: Parameterized views proposition Tambet Matiisen
- Re: Parameterized views proposition Andrew - Supernews
- finding schema of table that called a trigger Jeff Hoffmann
- How to cast VARCHAR to BYTEA and vice-versa? Moran.Michael
- Newbie wonder... Bernard Grosperrin
- Re: Update PostgreSQL from MS SQL trigger Igor Kryltsov
- Update PostgreSQL from MS SQL trigger Igor Kryltsov
- plpgsql & date-time functions Fatih Cerit
- Re: group by before and after date Sim Zacks
- group by before and after date Sim Zacks
- Re: [ADMIN] Postgres schema comparison. Matteo Beccati
- Re: plpgsql & date-time functions Stephan Szabo
- Re: Newbie wonder... Sean Davis
- outputting dates Kenneth Gonsalves
- sql: "LIKE" problem Her Goo
- lower and unicode pginfo
- Re: sql: "LIKE" problem Tom Lane
- Re: lower and unicode Miroslav Šulc
- Re: sql: "LIKE" problem Richard Huxton
- Re: finding schema of table that called a trigger Richard Huxton
- Re: How to cast VARCHAR to BYTEA and vice-versa? Ragnar Hafstað
- Re: group by before and after date PFC
- Re: Newbie wonder... PFC
- Re: How to cast VARCHAR to BYTEA and vice-versa? Christoph Haller
- Re: lower and unicode pginfo
- Re: lower and unicode Miroslav Šulc
- How does the planner treat a table function. KÖPFERL Robert
- Re: lower and unicode pginfo
- Re: lower and unicode Miroslav Šulc
- Re: Newbie wonder... Rod Taylor
- Re: How to cast VARCHAR to BYTEA and vice-versa? Lance Peterson
- Inserting values in arrays Robert.Farrugia@go.com.mt
- Generic Function lucas@presserv.org
- postgresql 8.01, plpgsql Timothy Smith
- Re: postgresql 8.01, plpgsql Michael Fuhr
- Re: postgresql 8.01, plpgsql Timothy Smith
- re postgresql 8.01 plpgsql Timothy Smith
- Re: postgresql 8.01, plpgsql Michael Fuhr
- select multiple immediate values, but in multiple rows Luca Pireddu
- Re: Inserting values in arrays Richard Huxton
- Re: select multiple immediate values, but in multiple rows Richard Huxton
- Re: Inserting values in arrays Robert.Farrugia@go.com.mt
- Re: How to cast VARCHAR to BYTEA and vice-versa? Christoph Haller
- Re: Parameterized views proposition Tambet Matiisen
- comparing 2 tables U K Laxmi
- Re: comparing 2 tables Richard Huxton
- How to force subquery scan? Tambet Matiisen
- Re: comparing 2 tables U K Laxmi
- Re: comparing 2 tables Richard Huxton
- Re: Generic Function George Weaver
- Re: How to force subquery scan? Christoph Haller
- Re: outputting dates Christoph Haller
- Re: select multiple immediate values, but in multiple rows PFC
- Re: Parameterized views proposition Tom Lane
- Scheme not dropping Graham Vickrage
- Re: Scheme not dropping Ragnar Hafstað
- Re: Generic Function lucas@presserv.org
- Re: Generic Function PFC
- Re: How to force subquery scan? Tambet Matiisen
- Re: Parameterized views proposition Tambet Matiisen
- Re: How to force subquery scan? Tom Lane
- PGCrypto with Integers and DATE types -- how to? Moran.Michael
- Re: How does the planner treat a table function. KÖPFERL Robert
- Query performance problem Phil Daintree
- Re: How to force subquery scan? Tambet Matiisen
- query Chandan_Kumaraiah
- Re: Query performance problem PFC
- Re: query Terry Fielder
- Re: query Richard Huxton
- Re: Query performance problem Kenneth Gonsalves
- update with subselect (long) Leif B. Kristensen
- Re: update with subselect (long) Leif B. Kristensen
- Re: Query performance problem PFC
- Re: update with subselect (long) Stephan Szabo
- Re: Query performance problem Richard Huxton
- Re: update with subselect (long) Leif B. Kristensen
- Re: lower and unicode Peter Eisentraut
- Consecutive row count query Leon Stringer
- Re: Consecutive row count query Bruno Wolff III
- Re: Consecutive row count query Jaime Casanova
- Re: Consecutive row count query Greg Stark
- Process priority. Theo Galanakis
- Re: Consecutive row count query Andrew Hammond
- Re: Process priority. Tom Lane
- Re: Process priority. Theo Galanakis
- Re: Query performance problem Kenneth Gonsalves
- Re: Query performance problem Ragnar Hafstað
- Re: Query performance problem PFC
- Re: Query performance problem Stephan Szabo
- Re: Query performance problem George Weaver
- best way to swap two records (computer details) Gary Stainburn
- Re: best way to swap two records (computer details) Greg Patnude
- Trigger with parameters lucas@presserv.org
- Re: best way to swap two records (computer details) PFC
- Re: Consecutive row count query Leon Stringer
- Re: Mail Authentification tgl@sss.pgh.pa.us
- Group by 15 Minute Steps Martin Knipper
- ... Octavio Alvarez
- date subtraction Ashok Agrawal
- tablename as function parameter Hermann Draeger
- Re: Group by 15 Minute Steps Jonathan Daugherty
- timestamp precision - can I control precision at select time or set for all time? mroyce@gmail.com
- query Chandan_Kumaraiah
- Re: tablename as function parameter Jonathan Daugherty
- equivalent of oracle rank() in postgres Chandan_Kumaraiah
- Re: Trigger with parameters Richard Huxton
- Re: date subtraction Richard Huxton
- index scan Mihail Nasedkin
- Re: index scan Richard Huxton
- Re: Christoph Haller
- Re: index scan Mihail Nasedkin
- Re: Your question about date Béatrice Yueksel
- Re: index scan Richard Huxton
- CASE not working Martín Marqués
- Re: CASE not working Alvaro Herrera
- Re: query Thomas F.O'Connell
- Re: CASE not working Martín Marqués
- Re: query Bruno Wolff III
- "Flattening" query result into columns Thomas Borg Salling
- Re: "Flattening" query result into columns Sean Davis
- C function extending postgres Theo Galanakis
- Re: C function extending postgres Jonathan Daugherty
- Re: "Flattening" query result into columns PFC
- Re: "Flattening" query result into columns Leif B. Kristensen
- Re: "Flattening" query result into columns Scott Marlowe
- Re: equivalent of oracle rank() in postgres Greg Sabino Mullane
- Re: C function extending postgres Theo Galanakis
- Re: C function extending postgres Jonathan Daugherty
- Re: C function extending postgres Theo Galanakis
- Re: timestamp precision - can I control precision at select time Christoph Haller
- Re: Your question about date Christoph Haller
- Re: Your question about date Béatrice Yueksel
- Self-referencing table question Sean Davis
- Re: Self-referencing table question Sean Davis
- Re: Self-referencing table question Richard Huxton
- Permissions on tables and views subhash@nmsu.edu
- Re: Permissions on tables and views Michael Fuhr
- Re: Self-referencing table question Sean Davis
- view function on pg_toast bandeng
- Re: view function on pg_toast Michael Fuhr
- Re: view function on pg_toast Mihail Nasedkin
- Re: view function on pg_toast Mihail Nasedkin
- Re: "Flattening" query result into columns Tambet Matiisen
- Re: Self-referencing table question Sean Davis
- How do I do this? Wei Weng
- Re: best way to swap two records (computer details) Gary Stainburn
- Re: best way to swap two records (computer details) Gary Stainburn
- Re: best way to swap two records (computer details) Michael Long
- Re: [despammed] How do I do this? Andreas Kretschmer
- Re: view function on pg_toast bandeng
- Re: best way to swap two records (computer details) Gary Stainburn
- Re: How do I do this? Greg Sabino Mullane
- Re: Self-referencing table question Edmund Bacon
- Funtions + plpgsql + contrib/pgcrypto = ?? Moran.Michael
- Re: Funtions + plpgsql + contrib/pgcrypto = ?? Jim Buttafuoco
- Re: Self-referencing table question Sean Davis
- Re: Funtions + plpgsql + contrib/pgcrypto = ?? Moran.Michael
- Re: Funtions + plpgsql + contrib/pgcrypto = ?? Jim Buttafuoco
- Re: Self-referencing table question Edmund Bacon
- Re: Funtions + plpgsql + contrib/pgcrypto = ?? Moran.Michael
- Re: Self-referencing table question Sean Davis
- Re: Self-referencing table question Edmund Bacon
- Re: Funtions + plpgsql + contrib/pgcrypto = ?? Moran.Michael
- Re: Self-referencing table question Sean Davis
- Calling functions from Delete View (+ contrib/pgcrypto) = madness ?? Moran.Michael
- Re: Calling functions from Delete View (+ contrib/pgcrypto) = madness ?? Jim Buttafuoco
- Re: Calling functions from Delete View (+ contrib/pgcrypto) Moran.Michael
- Re: Calling functions from Delete View (+ contrib/pgcrypto) Michael Fuhr
- Securing VIEWS that use contrib/pgcrypto -- how? Moran.Michael
- Re: Securing VIEWS that use contrib/pgcrypto -- how? Tom Lane
- Permissions on tables subhash@nmsu.edu
- Auto Numbering sreekanth pk
- Re: timestamp precision - can I control precision at select time mroyce@gmail.com
- Foreign key
- How to make update statement to work Andrus Moor
- Is there a way to find a schema name Kalyani Chennupati
- Merging item codes using referential integrity Andrus Moor
- Accessing other Databases osmar@evaltec.com.br
- Re: Auto Numbering Michael Fuhr
- select a list of schema names Andrus Moor
- Re: Foreign key Michael Fuhr
- Re: How to make update statement to work Tom Lane
- Re: select a list of schema names Michael Fuhr
- Re: Accessing other Databases Michael Fuhr
- Re: Is there a way to find a schema name Michael Fuhr
- Postgre: 8.0.1 Create Table insde a function gives strange error at execution time Franz Stuetzle
- detaching triggers Enrico Weigelt
- (non)zero function Enrico Weigelt
- Re: Postgre: 8.0.1 Create Table insde a function gives strange error at execution time Tom Lane
- Re: Foreign key Bruno Wolff III
- Re: detaching triggers Mike Rylander
- Re: (non)zero function Bruno Wolff III
- Re: "Flattening" query result into columns Thomas Borg Salling
- connectby queries Chandan_Kumaraiah
- Re: (non)zero function Christian Kratzer
- Re: [HACKERS] Executing Anonymous Blocks Alvaro Herrera
- Re: connectby queries Michael Fuhr
- Postgres 7.3 migrate to 8.0 date problems. Thomas Seeber
- Re: Postgres 7.3 migrate to 8.0 date problems. Scott Marlowe
- cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT Scott Marlowe
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz
- Re: Merging item codes using referential integrity Richard Huxton
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT Sean Davis
- when using a bound cursor, error found... 윤동수
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT Bruno Wolff III
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT Alvaro Herrera
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT Bruno Wolff III
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT Bruno Wolff III
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT Tom Lane
- Re: cost of CREATE VIEW ... AS SELECT DISTINCT T E Schmitz
- Re: when using a bound cursor, error found... Michael Fuhr
- can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE frank@joerdens.de
- Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE PFC
- Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE frank@joerdens.de
- New record position lucas@presserv.org
- Re: New record position Oleg Bartunov
- Re: New record position PFC
- Re: New record position lucas@presserv.org
- Re: RE : Foreign key Michael Fuhr
- Re: RE : Foreign key Bruno Wolff III
- Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE Bruno Wolff III
- Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE Michael Fuhr
- Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE Bruno Wolff III
- delphi access question? Joel Fradkin
- save me from an unconstrained join Robert Treat
- Re: delphi access question? Gregory S. Williamson
- Re: Postgres 7.3 migrate to 8.0 date problems. Robert Treat
- Re: delphi access question? Joel Fradkin
- Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE Greg Stark
- Re: New record position Chris Browne
- A SQL Question About distinct, limit, group by, having, aggregate 林[鋅
- Re: A SQL Question About distinct, limit, group by, having, aggregate Jaime Casanova
- Re: Postgres 7.3 migrate to 8.0 date problems. Michael Fuhr
- Re: delphi access question Lin Kun Hsin
- Re: A SQL Question About distinct, limit, group by, having, aggregate Lin Kun Hsin
- Re: save me from an unconstrained join Richard Huxton
- Re: A SQL Question About distinct, limit, group by, having, Ragnar Hafstað
- Help - Oracle 9i to PostgreSQL SQL conversion Dinesh Pandey
- Re: A SQL Question About distinct, limit, group by, having, aggregate Lin Kun Hsin
- Re: New record position Greg Patnude
- Re: New record position Chris Browne
- unsubscribe pgsql-sql Robin M.