db.postgresql.sql (thread)

Re: [PERFORM] Yet Another (Simple) Case of Index not used, Bruce Momjian
join/case, jtx
- Re: join/case, Dmitry Tkach
- Re: join/case, Stephan Szabo
- Re: join/case, Bruno Wolff III
Dynamic views/permissions, Raj Mathur
- Re: Dynamic views/permissions, Ian Barwick
Calculating with the time, Katka a Daniel Dunajsky
- Re: Calculating with the time, Guy Fraser
SELECT statement within libpq, David Klugmann
SQL Help, C F
- Re: SQL Help, Bruno Wolff III
- Re: SQL Help, Josh Berkus
- Re: CASE returning multiple values (was SQL Help), Richard Huxton
  - Re: CASE returning multiple values (was SQL Help), Tom Lane
  - Re: CASE returning multiple values (was SQL Help), C F
- Re: SQL Help, Franco Bruno Borghesi
please help me ???, andhie lala
please helpme ?, andhie lala
- Re: please helpme ?, Richard Huxton
Re: Rows UPDATEd? (solved!), David Olbersen
Index scan never executed?, Chad Thompson
- Re: Index scan never executed?, Stephan Szabo
- Re: Index scan never executed?, Tom Lane
  - Re: Index scan never executed?, Chad Thompson
Rows UPDATEd?, David Olbersen
CREATE TABLES AS looses constraints, Tiaan Wessels
- Re: CREATE TABLES AS looses constraints, Josh Berkus
"record" datatype - plpgsql, Brian Knox
- Re: "record" datatype - plpgsql, George Weaver
  - Re: "record" datatype - plpgsql, George Weaver
  - Re: "record" datatype - plpgsql, Brian Knox
    - Re: "record" datatype - plpgsql, Tom Lane
    - Re: "record" datatype - plpgsql, Sean Chittenden
    - Re: "record" datatype - plpgsql, Jr.
- Re: "record" datatype - plpgsql, Stephan Szabo
Returning Multiple Values from CASE statement?, C F
How To Recover Deleted Data, Abdul Wahab Dahalan
- Re: How To Recover Deleted Data, Brian Knox
How to undelete deleted data, Abdul Wahab Dahalan
- Re: How to undelete deleted data, Bruno Wolff III
The problems about temporary tables in V7.3.2, jack
- Re: The problems about temporary tables in V7.3.2, Tom Lane
recursive srf, Matthew Nuzum
schema-qualified permission problem, Charlie Toohey
- Re: schema-qualified permission problem, Tom Lane
Inheritance and Referencial Integrity, Stuart
Empty queries guaranteed to work?, Forest Wilkinson
Getting rid of accents.., mallah
- Re: Getting rid of accents.., Randall Lucas
  - Re: Getting rid of accents.., Jean-Luc Lachance
- Re: Getting rid of accents.., Randall Lucas
- Re: Getting rid of accents.., Ian Barwick
  - Re: Getting rid of accents.., mallah
little doubt, Eric Anderson Vianet SAO
- Re: little doubt, Josh Berkus
- Re: little doubt, Richard Huxton
Re: alter column witdh, Christoph Haller
[Fwd: SQL book], Jodi Kanter
- Re: [Fwd: SQL book], Thomas Good
  - Re: [Fwd: SQL book], Josh Berkus
- Re: [Fwd: SQL book], Josh Berkus
- Re: [Fwd: SQL book], Ries van Twisk
Perl Book, Jodi Kanter
- Re: Perl Book, Andrew Perrin
- Re: Perl Book, Wei Weng
- Re: Perl Book, Robert Treat
How to delete multiple rows from multiple joined tables, Michael Mattox
- Re: How to delete multiple rows from multiple joined tables, Tom Lane
timestamp field - select error, alexandre :: aldeia digital
- Re: timestamp field - select error, Tom Lane
  - Re: timestamp field - select error, alexandre :: aldeia digital
    - Re: timestamp field - select error, Tom Lane
Many-to-Many relation, Mukta Telang
- Re: Many-to-Many relation, Peter Childs
  - Re: Many-to-Many relation, Mukta A. Telang
    - Re: Many-to-Many relation, Bruno Wolff III
Using UPPER and TRIM (INDEX usage), Mintoo Lall
- Re: Using UPPER and TRIM (INDEX usage), Christoph Haller
date interpolation, Rob Wood
- Re: date interpolation, Rod Taylor
Quick question regarding indexes and NULLs in 7.3.3 -> 7.4, Josh Berkus
- Re: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4, Tom Lane
select lower('ÆØÅ ABC'); does not work as expected, willy malth
- Re: select lower('ÆØÅ ABC'); does not work as expected, Tom Lane
  - Re: select lower('ÆØÅ ABC'); does, Markus Bertheau
pg_connect, Johann Thoyer
- Re: pg_connect, Markus Bertheau
Re: faster output from php and postgres, Chadwick Rolfs
- Re: faster output from php and postgres, Bruno Wolff III
- Re: faster output from php and postgres, Chadwick Rolfs
  - Re: [PHP] faster output from php and postgres, Richard Huxton
    - Re: [PHP] faster output from php and postgres, Chadwick Rolfs
    - Re: [PHP] faster output from php and postgres, Rod Taylor
  - Re: [SQL] faster output from php and postgres, Jean-Luc Lachance
    - Re: [SQL] faster output from php and postgres, Chadwick Rolfs
    - Re: [SQL] faster output from php and postgres (one resolution), Chadwick Rolfs
Bad rowtype on PL/SQL Oracle -- does anyone know?, Josh Berkus
language "plpgsql" does not exist, Bruce Young
- Re: language "plpgsql" does not exist, Devrim GUNDUZ
- Re: language "plpgsql" does not exist, Richard Huxton
- Re: language "plpgsql" does not exist, Achilleus Mantzios
- Re: language "plpgsql" does not exist, Rod Taylor
- Re: language "plpgsql" does not exist, Oliver Elphick
- Re: language "plpgsql" does not exist, Victor Yegorov
  - Re: language "plpgsql" does not exist, Bruce Young
    - Re: language "plpgsql" does not exist, PeterKorman
    - Re: language "plpgsql" does not exist, A.Bhuvaneswaran
- Re: language "plpgsql" does not exist, A.Bhuvaneswaran
- Re: language "plpgsql" does not exist, David Witham
- Re: language "plpgsql" does not exist, Christoph Haller
AS?, Andreas Selenwall
- Re: AS?, Bruno Wolff III
how to use an aggregate function, jmsmithe
- Re: how to use an aggregate function, David W Noon
- Re: how to use an aggregate function, Matthew Nuzum
Referencing a column from another table in a different database with a foreign key constraint., Dan S
- Re: Referencing a column from another table in a different, Stephan Szabo
libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST, Jeffrey Pogodzinski
- Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST, Bruno Wolff III
- Re: libpq program SELECT FOR UPDATE and TIMEOUT or CANCEL REQUEST, Christoph Haller
Another sub-select problem..., Kevin Ready
- Re: Another sub-select problem..., Rod Taylor
- Re: Another sub-select problem..., Joe Conway
- Re: Another sub-select problem..., Stephan Szabo
- Re: Another sub-select problem..., Christoph Haller
Re: Really simple SQL problem, David W Noon
What do you think of this?, John Dwyer
tablename as attribute in pgplsql, Benoît Bournon
- Re: tablename as attribute in pgplsql, Rod Taylor
- Re: tablename as attribute in pgplsql, Stephan Szabo
  - Re: tablename as attribute in pgplsql, Benoît Bournon
    - Re: tablename as attribute in pgplsql, Stephan Szabo
MIN function problem with Postgres7.3, Prashanth - Kamath
numeric fields and null, Don Park
- Re: numeric fields and null, Guy Fraser
- Re: numeric fields and null, Stephan Szabo
  - Re: numeric fields and null, Alexey Dashevsky
- Re: numeric fields and null, Franco Bruno Borghesi
  - Re: numeric fields and null, Don Park
- numeric fields and null, Don Park
  - Re: numeric fields and null, Rod Taylor
Index Selection Problem, phd9110
- Re: Index Selection Problem, Josh Berkus
- index selection problem, phd9110
see toast table, Eric Anderson Vianet SAO
- Re: see toast table, Jan Wieck
  - Re: see toast table, Eric Anderson Vianet SAO
    - Re: see toast table, Jan Wieck
    - discover a toast table name, Eric Anderson Vianet SAO
    - Re: discover a toast table name, Tom Lane
    - alter column witdh, Eric Anderson Vianet SAO
    - Re: alter column witdh, Frank Bax
    - Re: discover a toast table name, Eric Anderson Vianet SAO
- Re: see toast table, Christoph Haller
function prepared plan, Franco Bruno Borghesi
- Re: function prepared plan, Tom Lane
  - Re: function prepared plan, Franco Bruno Borghesi
    - Re: function prepared plan, Tom Lane
    - Re: function prepared plan, Franco Bruno Borghesi
Functions that return Record Sets, Benjamin Stewart
- Re: Functions that return Record Sets, ritchie turner
- Re: Functions that return Record Sets, Avi Schwartz
- Re: Functions that return Record Sets, Stephan Szabo
- Re: Functions that return Record Sets, Joe Conway
selecting entire row on which one field is the minimum, edouard . boucher
- Re: selecting entire row on which one field is the minimum, Rod Taylor
plpgsql recursion, Kluge
- Re: plpgsql recursion, Stephan Szabo
- plpgsql recursion, Stefano Vita Finzi
  - Re: plpgsql recursion, Rod Taylor
  - Re: plpgsql recursion, Luis Sousa
Date comparison question, Jan Bodey
- Re: Date comparison question, Stephan Szabo
- Re: Date comparison question, Tom Lane
- Re: Date comparison question, Jan Bodey
how to do this query?, ww zz
- Re: how to do this query?, Richard Huxton
- Re: how to do this query?, Stephan Szabo
  - Re: how to do this query?, ww zz
    - Re: how to do this query?, Stephan Szabo
missing chunk number 0 for toast value 32067496, Eric Anderson Vianet SAO
- Re: missing chunk number 0 for toast value 32067496, Tom Lane
Drop CONSTRAINT, Rado Petrik
- Re: Drop CONSTRAINT, Achilleus Mantzios
CASE, James Taylor
- Re: CASE, Stephan Szabo
- Re: CASE, Rod Taylor
- Re: CASE, Manfred Koizar
- Re: CASE, Tom Lane
Performance on temp table inserts, Jeff Boes
- Re: Performance on temp table inserts, Josh Berkus
- Re: Performance on temp table inserts, Tom Lane
  - Re: Performance on temp table inserts, Jeff Boes
    - Re: Performance on temp table inserts, Tom Lane
    - Re: Performance on temp table inserts, Jeff Boes
- Re: Performance on temp table inserts, David W Noon
  - Re: Performance on temp table inserts, Jeff Boes
    - Re: Performance on temp table inserts, David W Noon
COALESCE in ORDER BY..., Terry Yapt
- Re: COALESCE in ORDER BY..., Andreas Schmitz
  - Re: COALESCE in ORDER BY..., Stephan Szabo
- Re: COALESCE in ORDER BY..., Terry Yapt
JOIN vs. WHERE ... IN (subselect), Dean Gibson (DB Administrator)
- Re: JOIN vs. WHERE ... IN (subselect), Chris Linstruth
  - Re: JOIN vs. WHERE ... IN (subselect), Dean Gibson (DB Administrator)
- Re: JOIN vs. WHERE ... IN (subselect), Stephan Szabo
Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR ..", Mike Winter
- Re: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR ..", Randall Lucas
- Re: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR ..", Richard Huxton
  - Re: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR, Mike Winter
- Re: Efficiency Issue with "SELECT IN (..)" and "SELECT .. OR ..", Tom Lane
Chain/Thread Problem, Sammy
- Re: Chain/Thread Problem, J Sensel
- Re: Chain/Thread Problem, Richard Huxton
Re: Testing castability of text to numeric, Christoph Haller
- Re: Testing castability of text to numeric, Achilleus Mantzios
  - Re: Testing castability of text to numeric, Jan Wieck
    - Re: Testing castability of text to numeric, Achilleus Mantzios
  - Re: Testing castability of text to numeric, Randall Lucas
- Message not available
  - Re: Testing castability of text to numeric, Dean Gibson (DB Administrator)
- Re: Testing castability of text to numeric, Christoph Haller
installation problem, mdc
- Re: installation problem, Richard Huxton
- installation problem, mdc
select 3 characters, Cyber Join
- Re: select 3 characters, Josh Berkus
  - Re: select 3 characters, Jeff Eckermann
- Re: select 3 characters, Richard Huxton
- Re: select 3 characters, A.Bhuvaneswaran
SQL Parser, Fabio Rollo
- Re: SQL Parser, Josh Berkus
- Re: SQL Parser, Bruce Momjian
- Re: SQL Parser, Alvar Freude
Left Join 3 tables, Hunter
- Re: Left Join 3 tables, David W Noon
Inquiry From Form [pgsql], eric
- Re: Inquiry From Form [pgsql], Stephan Szabo
- Inquiry From Form [pgsql], Issa
  - Re: Inquiry From Form [pgsql], Ian Barwick
  - Re: Inquiry From Form [pgsql], Stephan Szabo
- Inquiry From Form [pgsql], Rajendran
- Re: Inquiry From Form [pgsql], Christoph Haller
  - Re: Inquiry From Form [pgsql], Achilleus Mantzios
comparing 2 queries, Martin Marques
- Re: comparing 2 queries, Richard Huxton
check with select, edouard . boucher
- Re: check with select, Stephan Szabo
Newbie question: How to CREATE FUNCTION, Steven Chau
- Re: Newbie question: How to CREATE FUNCTION, Victor Yegorov
- Re: Newbie question: How to CREATE FUNCTION, Joe Conway
I need help with a rule to relocate duplicate records, Guy Fraser
- Re: I need help with a rule to relocate duplicate records, Luis Sousa
PL/pgSQL: Logging Trigger. Advice/comments/other?, Larry Rosenman
- Re: PL/pgSQL: Logging Trigger. Advice/comments/other?, Joe Conway
  - Re: PL/pgSQL: Logging Trigger. Advice/comments/other?, Larry Rosenman
Followup from yesterday's PL/pgSQL fun..., Larry Rosenman
- Re: Followup from yesterday's PL/pgSQL fun..., Tom Lane
  - Re: Followup from yesterday's PL/pgSQL fun..., Tom Lane
    - Re: Followup from yesterday's PL/pgSQL fun..., Larry Rosenman
    - Re: Followup from yesterday's PL/pgSQL fun..., Tom Lane
    - Re: Followup from yesterday's PL/pgSQL fun..., Larry Rosenman
    - Re: Followup from yesterday's PL/pgSQL fun..., Tom Lane
    - Re: Followup from yesterday's PL/pgSQL fun..., Larry Rosenman
    - Re: Followup from yesterday's PL/pgSQL fun..., Tom Lane
Can arrays reference primary keys in CREATE TABLE?, Filipe Bonjour
- Re: Can arrays reference primary keys in CREATE TABLE?, Richard Huxton
  - Re: Can arrays reference primary keys in CREATE TABLE?, Luis Sousa
    - Re: Can arrays reference primary keys in CREATE TABLE?, Jan Wieck
    - Re: Can arrays reference primary keys in CREATE TABLE?, Luis Sousa
    - Re: Can arrays reference primary keys in CREATE TABLE?, Jan Wieck
    - Re: Can arrays reference primary keys in CREATE TABLE?, Oleg Bartunov
    - Re: Can arrays reference primary keys in CREATE TABLE?, Stephan Szabo
    - Re: Can arrays reference primary keys in CREATE TABLE?, Jan Wieck
insert problem with special characters, jwang
- Re: [SQL] insert problem with special characters, Randall Lucas
Type coercion on column in a query, Kenny Mok
- Re: Type coercion on column in a query, Richard Huxton
  - Re: Type coercion on column in a query, Randall Lucas
    - Re: Type coercion on column in a query, Richard Huxton
    - Re: Type coercion on column in a query, Randall Lucas
    - Re: Type coercion on column in a query, Richard Huxton
- Re: Type coercion on column in a query, Ian Barwick
Questions for experts, SEB Menard
- Re: Questions for experts, Richard Huxton
- Re: Questions for experts, Tom Lane
please help construct an SQL query, Joe
- Re: please help construct an SQL query, David W Noon
lock status check, mixo
- Re: lock status check, Christoph Haller
Anyone know of a text-interface postmaster load monitor?, foo2
- Re: Anyone know of a text-interface postmaster load monitor?, Devrim GUNDUZ
Looking for script to dump postgresql schema to xml file, J Sensel
bad query performance, Didrik Pinte
- Re: bad query performance, Stephan Szabo
  - Re: bad query performance, Luis Sousa
    - Re: bad query performance, Didrik Pinte
    - Re: bad query performance, Luis Sousa
Calculating Percentages, David Siegal
- Re: Calculating Percentages, Tom Lane
- Re: Calculating Percentages, Josh Berkus
- Re: Calculating Percentages, Christoph Haller
  - Re: Calculating Percentages, Josh Berkus
Postgresql and Top N Analysis?, Katka a Daniel Dunajsky
- Re: Postgresql and Top N Analysis?, Larry Rosenman
Ok, how do I debug THIS?, Larry Rosenman
- Re: Ok, how do I debug THIS?, Josh Berkus
  - Re: Ok, how do I debug THIS?, Larry Rosenman
    - Re: Ok, how do I debug THIS?, Josh Berkus
    - Re: Ok, how do I debug THIS?, Larry Rosenman
    - Re: Ok, how do I debug THIS?, Stephan Szabo
    - Re: Ok, how do I debug THIS?, Larry Rosenman
    - Re: Ok, how do I debug THIS?, Larry Rosenman
    - Re: Ok, how do I debug THIS?, Stephan Szabo
    - Re: Ok, how do I debug THIS?, Larry Rosenman
    - Re: Ok, how do I debug THIS?, Tom Lane
    - Re: Ok, how do I debug THIS?, Larry Rosenman
    - Testing castability of text to numeric, Randall Lucas
    - Message not available
    - Re: Ok, how do I debug THIS?, Larry Rosenman
See Temp Table from Trigger, Joachim Zauner
- Re: See Temp Table from Trigger, Christoph Haller
Locating all Children given Set of Parents, Adam Sherman
- Re: Locating all Children given Set of Parents, Josh Berkus
  - Re: Locating all Children given Set of Parents, Adam Sherman
    - Re: Locating all Children given Set of Parents, Josh Berkus
    - Re: Locating all Children given Set of Parents, Adam Sherman
    - Re: Locating all Children given Set of Parents, Josh Berkus
  - Re: Locating all Children given Set of Parents, Adam Sherman
N all-way relationship, Ryan
- Re: N all-way relationship, chester c young
- Re: N all-way relationship, Bruno Wolff III
- Re: N all-way relationship, Jamie Lawrence
Why this query does not work?, Katka a Daniel Dunajsky
- Re: Why this query does not work?, Tom Lane
- Re: Why this query does not work?, A.Bhuvaneswaran
Constraint Syntax Question, Adam Sherman
- Re: Constraint Syntax Question, Peter Childs
- Re: Constraint Syntax Question, Peter and Sarah Childs
sub select performance, Chris Linstruth
- Re: sub select performance, Bruno Wolff III
- Re: sub select performance, Mathieu Arnold
  - Re: sub select performance, Chris Linstruth
Knowing when it is safe to call currval(), Matthew Horoschun
- Re: Knowing when it is safe to call currval(), Bruno Wolff III
  - Message not available
    - Re: Knowing when it is safe to call currval(), Bruno Wolff III
    - Re: Knowing when it is safe to call currval(), Matthew Horoschun
Using psql to insert character codes, Ian Barwick
- Re: Using psql to insert character codes, Randall Lucas
  - Re: Using psql to insert character codes, Ian Barwick
    - Re: Using psql to insert character codes, Randall Lucas
    - merge-join for domain with underlying type text, Randall Lucas
    - Re: merge-join for domain with underlying type text, Rod Taylor
    - Re: merge-join for domain with underlying type text, Randall Lucas
    - Re: merge-join for domain with underlying type text, Rod Taylor
    - Re: merge-join for domain with underlying type text, Randall Lucas
    - Re: merge-join for domain with underlying type text, Tom Lane
- Re: Using psql to insert character codes, Ian Barwick
- Re: Using psql to insert character codes, Peter Eisentraut
  - Re: Using psql to insert character codes, Ian Barwick
    - Re: Using psql to insert character codes, Peter Eisentraut
epoch to timestamp, Lucas Lain
- Re: epoch to timestamp, Bruno Wolff III
  - Re: epoch to timestamp, Lucas Lain
    - Re: epoch to timestamp, Randall Lucas
    - Re: epoch to timestamp, Achilleus Mantzios
    - Re: epoch to timestamp, Larry Rosenman
    - Re: epoch to timestamp, Achilleus Mantzios
    - Re: epoch to timestamp, Larry Rosenman
    - Re: epoch to timestamp, Josh Berkus
    - Re: epoch to timestamp, Larry Rosenman
    - Re: epoch to timestamp, Chris Linstruth
    - Re: epoch to timestamp, Lucas Lain
index fragmentation, Wei Weng
- Re: index fragmentation, Larry Rosenman
%ROWTYPE and insert, Larry Rosenman
epoch to date?, Alex Rice
- Re: epoch to date?, Bruno Wolff III
does this require a stored procedure?, Alex Rice
- Re: does this require a stored procedure?, chester c young
  - Re: does this require a stored procedure?, Alex Rice
- Re: does this require a stored procedure?, Manfred Koizar
Overwhelming DEBUG messages, SZŰCS Gábor
- Re: Overwhelming DEBUG messages, Richard Huxton
  - Re: Overwhelming DEBUG messages, Tom Lane
    - Re: Overwhelming DEBUG messages, SZŰCS Gábor
PROBLEM WITH UPDATE COMMAND, Mario Alberto Soto Cordones
- Re: PROBLEM WITH UPDATE COMMAND, mallah
insert rowtype, Bryan Klimt
- Re: insert rowtype, Bryan Klimt
- Re: insert rowtype, Christoph Haller
- insert rowtype, Bryan Klimt
Array dimension as integer, Victor Yegorov
- Re: Array dimension as integer, Achilleus Mantzios
A minute in timestamp, David Loh
- Re: A minute in timestamp, Richard Huxton
- Re: A minute in timestamp, Victor Yegorov
seeing type defination.., Rajesh Kumar Mallah
- Re: seeing type defination.., Tom Lane
  - Re: seeing type defination.., mallah
    - Re: seeing type defination.., Tom Lane
    - Re: seeing type defination.., mallah
Timestamp index not used, david
- Re: Timestamp index not used, Tom Lane
(unknown), mdc
- Re:, Stephan Szabo
- (unknown), Peter Lavender
Re: [GENERAL] PostgreSQL Qs, mallah
- Re: [GENERAL] PostgreSQL Qs, Robert Treat
- Re: [GENERAL] PostgreSQL Qs, Jon Earle
"too clever" when creating SQL functions, SZŰCS Gábor
- Re: "too clever" when creating SQL functions, Richard Huxton
  - Re: "too clever" when creating SQL functions, SZŰCS Gábor
    - Re: "too clever" when creating SQL functions, Stephan Szabo
    - Re: "too clever" when creating SQL functions, SZŰCS Gábor
    - Re: "too clever" when creating SQL functions, Stephan Szabo
    - Re: "too clever" when creating SQL functions, SZŰCS Gábor
index defragmentation, Wei Weng
- Re: index defragmentation, Josh Berkus
- Re: index defragmentation, D'Arcy J.M. Cain
- Re: index defragmentation, Richard Huxton
help database corruption, mdc
- Re: help database corruption, Wei Weng
- help database corruption, mdc
- help database corruption, mdc
  - Re: help database corruption, Stephan Szabo
array in a reference, Ries van Twisk
- Re: array in a reference, Stephan Szabo
- Re: array in a reference, SZUCS Gábor
ERROR: pg_atoi: error in "NULL": can't parse "NULL", Rado Petrik
- Re: ERROR:Â pg_atoi: error in "NULL": can't parse "NULL", Josh Berkus
- Re: ERROR:Â pg_atoi: error in "NULL": can't, Jean-Luc Lachance
An unresolved performance problem., Achilleus Mantzios
- Re: [SQL] An unresolved performance problem., Mendola Gaetano
  - Re: Unanswered Questions WAS: An unresolved performance problem., Josh Berkus
    - Re: Unanswered Questions WAS: An unresolved performance problem., Randall Lucas
    - Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem., Tom Lane
    - Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem., Sean Chittenden
    - Re: [PERFORM] Unanswered Questions WAS: An unresolved performance problem., johnnnnnn
    - Re: [PERFORM] Unanswered Questions WAS: An unresolved performance, scott.marlowe
  - Re: [SQL] An unresolved performance problem., Bernd von den Brincken
    - Re: [SQL] An unresolved performance problem., Achilleus Mantzios
SQl query, Abdul Wahab Dahalan
- Re: SQl query, Matthew Horoschun
- Re: SQl query, Victor Yegorov
- Re: SQl query, DIB Walid
- Re: SQl query, A.Bhuvaneswaran
"deadlock detected" documentation, Matt Mello
- Re: "deadlock detected" documentation, Tom Lane
  - Re: "deadlock detected" documentation, Matt Mello
    - Re: "deadlock detected" documentation, Tom Lane
    - Re: "deadlock detected" documentation, Matt Mello
    - Re: "deadlock detected" documentation, Tom Lane
    - Re: "deadlock detected" documentation, Matt Mello
    - Re: "deadlock detected" documentation, Tom Lane
    - Re: "deadlock detected" documentation, Matt Mello
    - Re: "deadlock detected" documentation, Matt Mello
    - Re: "deadlock detected" documentation, Tom Lane
    - Re: "deadlock detected" documentation, Jan Wieck
    - Re: "deadlock detected" / cascading locks, Matt Mello
    - Re: "deadlock detected" / cascading locks, Stephan Szabo
    - Re: "deadlock detected" / cascading locks, Jan Wieck
- Re: "deadlock detected" documentation, A.Bhuvaneswaran
Date Anomaly??, Thomas Good
- Re: Date Anomaly??, Ian Barwick
  - Re: Date Anomaly??, Thomas Good
    - Re: Date Anomaly??, Tom Lane
    - Re: Date Anomaly??, Thomas Good
    - Re: Date Anomaly??, Bruno Wolff III
    - Re: Date Anomaly??, Josh Berkus
    - Re: Date Anomaly??, Thomas Good
    - Re: Date Anomaly??, Stephan Szabo
    - Re: Date Anomaly??, Tom Lane
Utils/case for create relation db under Linux, Rado Petrik
Re: pgsql Replication Proxy (was Re: Replication for a, Diehl, Jeffrey
- Re: pgsql Replication Proxy (was Re: Replication for a, Mendola Gaetano
  - Re: pgsql Replication Proxy (was Re: Replication for a, Michael A Nachbaur
    - Re: pgsql Replication Proxy (was Re: Replication for a, Mendola Gaetano
- Re: pgsql Replication Proxy (was Re: Replication for a, Michael A Nachbaur
  - Re: pgsql Replication Proxy (was Re: Replication for a, Wei Weng
    - Re: pgsql Replication Proxy (was Re: Replication for a, Michael A Nachbaur
- Re: pgsql Replication Proxy (was Re: Replication for a, Diehl, Jeffrey
  - Re: pgsql Replication Proxy (was Re: Replication for a, Steve Crawford
UNIQUE boolean: only one row may be "true", Randall Lucas
- Re: UNIQUE boolean: only one row may be "true", Michael Teter
  - Re: UNIQUE boolean: only one row may be "true", Randall Lucas
    - Re: UNIQUE boolean: only one row may be "true", Tom Lane
    - Re: UNIQUE boolean: only one row may be "true", Ries van Twisk
- Re: UNIQUE boolean: only one row may be "true", Bruno Wolff III
- Re: UNIQUE boolean: only one row may be "true", chester c young
pg_stat_activity IP address, alexandre :: aldeia digital
VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2, SZŰCS Gábor
- Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2, Achilleus Mantzios
  - Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2, SZUCS Gabor
    - Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2, Achilleus Mantzios
    - Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2, Stephan Szabo
    - Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2, Tom Lane
pg_ ?, Popeanga Marian
- Re: pg_ ?, Achilleus Mantzios
- Re: pg_ ?, Rajesh Kumar Mallah
  - Re: pg_ ?, Popeanga Marian
- Re: pg_ ?, A.Bhuvaneswaran
  - Re: pg_ ?, A.Bhuvaneswaran
  - Re: pg_ ?, Achilleus Mantzios
Problem with Attribute., Rado Petrik
- Re: Problem with Attribute., Popeanga Marian
- Re: Problem with Attribute., Victor Yegorov
- Re: Problem with Attribute., Achilleus Mantzios
mnogosearch examples, Alex Rice
- Re: mnogosearch examples, Rajesh Kumar Mallah
2 simple SQL questions: optimizing aggegate query, Alex Rice
- Re: 2 simple SQL questions: optimizing aggegate query, Bruno Wolff III
  - Re: 2 simple SQL questions: optimizing aggegate query, Alex Rice
    - Re: 2 simple SQL questions: optimizing aggegate query, Bruno Wolff III
    - Cast type int2vector/array_field to character, Mr.F
    - Re: Cast type int2vector/array_field to character, Achilleus Mantzios
    - Re: 2 simple SQL questions: optimizing aggegate query, Alex Rice
Replication for a large database, Michael A Nachbaur
- Re: Replication for a large database, Ryan
  - Re: Replication for a large database, Michael Teter
  - Re: Replication for a large database, Michael A Nachbaur
    - pgsql Replication Proxy (was Re: Replication for a large database), Michael A Nachbaur
- Re: Replication for a large database, Michael A Nachbaur
  - Re: Replication for a large database, Jeff Eckermann
  - Re: Replication for a large database, The Hermit Hacker
UNICODE and SQL, Marco Roda
- Re: UNICODE and SQL, Achilleus Mantzios
- Re: UNICODE and SQL, Ian Barwick
- Re: UNICODE and SQL, Achilleus Mantzios
  - Re: UNICODE and SQL, Ian Barwick
    - Re: UNICODE and SQL, Marco Roda
Indices are not used by the optimizer, Reiner Dassing
- Re: Indices are not used by the optimizer, Rod Taylor
- Re: Indices are not used by the optimizer, Achilleus Mantzios
problem with max and not using index on PK, pginfo
- Re: problem with max and not using index on PK, Philip Warner
  - Re: problem with max and not using index on PK, pginfo
Time formating, Katka a Daniel Dunajsky
- Re: Time formating, Stephan Szabo
Best way to delete time stamped data?, Kyle
- Re: Best way to delete time stamped data?, Steve Crawford
- Re: Best way to delete time stamped data?, Josh Berkus
  - Re: Best way to delete time stamped data?, Rajesh Kumar Mallah
    - Re: Best way to delete time stamped data?, Bruno Wolff III
How to increase precision?, Katka a Daniel Dunajsky
- Re: How to increase precision?, Steve Crawford
- Re: How to increase precision?, Josh Berkus
- Re: How to increase precision?, Stephan Szabo
What is bad in this query ?, Rado Petrik
- Re: What is bad in this query ?, Achilleus Mantzios
  - Re: What is bad in this query ?, Chris Gamache
- Re: What is bad in this query ?, Rod Taylor
timeofday() and now() issue.., Rajesh Kumar Mallah
- Re: timeofday() and now() issue.., Tom Lane
  - Re: timeofday() and now() issue.., Rajesh Kumar Mallah
    - Re: timeofday() and now() issue.., Tom Lane
    - Re: timeofday() and now() issue.., Rajesh Kumar Mallah
    - Re: timeofday() and now() issue.., A.Bhuvaneswaran
    - Re: timeofday() and now() issue.., Rajesh Kumar Mallah
    - Re: timeofday() and now() issue.., Rajesh Kumar Mallah
Problem with old relation, Rado Petrik
- Re: Problem with old relation, Andreas Schmitz
- Re: Problem with old relation, A.Bhuvaneswaran
It's About field type array, Yudha [ Inas_Husband ] Setiawan
implied FROM, Matt Mello
- Re: implied FROM, Tomasz Myrta
  - Re: implied FROM, Matt Mello
    - Re: implied FROM, Bruno Wolff III
    - Re: implied FROM, Stephan Szabo
  - Re: implied FROM, Josh Berkus
How to write an query to get this result?, Daniel Dunajsky
- Re: How to write an query to get this result?, Richard Huxton
Re: differences between oracle,pgsql,sybase, Rajesh Kumar Mallah
- Re: differences between oracle,pgsql,sybase, A.Bhuvaneswaran
  - Re: differences between oracle,pgsql,sybase, Oliver Elphick
date use in for loop, Ramesh PAtel
- Re: date use in for loop, Josh Berkus
Date Problem, Ramesh PAtel
- Re: Date Problem, Rajesh Kumar Mallah
- Re: Date Problem, Stuart
How to write a sql query to get this result?, Daniel
- Re: How to write a sql query to get this result?, Tomasz Myrta
- Re: How to write a sql query to get this result?, Bruno Wolff III
Re: Stored Procedure Question, Roberto Mello
- Re: Stored Procedure Question, Rajesh Kumar Mallah
Re: PERFORM / FOUND, what's up?, Tom Lane