db.postgresql.sql (thread)

For each record in SELECT, Luis Magaña
Which version is this?, Wei Weng
Postgres MD5 Function, David Durst
- Re: Postgres MD5 Function, Larry Rosenman
  - Re: Postgres MD5 Function, Joe Conway
design review, FreshPorts change, Dan Langille
Re: How to rename and drop a column in pg7.3?, mallah
FW: Converting clarion, Michael Weaver
calculated expressions and index use, Pavel Hlavnicka
- Re: calculated expressions and index use, Arjen van der Meijden
- Re: calculated expressions and index use, Tom Lane
  - Re: calculated expressions and index use, Pavel Hlavnicka
    - Re: calculated expressions and index use, Tom Lane
    - Re: calculated expressions and index use, Pavel Hlavnicka
Function executing twice, Thiago Conti
- Re: Function executing twice, Tambet Matiisen
Delete 1 Record of 2 Duplicate Records, val
- Re: Delete 1 Record of 2 Duplicate Records, Achilleus Mantzios
- Re: Delete 1 Record of 2 Duplicate Records, greg
Question about passing User defined types to functions, David Durst
- Re: Question about passing User defined types to functions, Tom Lane
- Re: Question about passing User defined types to functions, Christoph Haller
Inheritence and Integrity, Neal Lindsay
- Re: Inheritence and Integrity, Stephan Szabo
  - Re: Inheritence and Integrity, Neal Lindsay
    - Re: Inheritence and Integrity, Stephan Szabo
- Re: Inheritence and Integrity, chester c young
help: triggers, Tony Simbine
- Re: help: triggers, Wei Weng
  - Re: help: triggers, Tony Simbine
plpgsql: return results of a dynamic query, Moritz Lennert
- Re: plpgsql: return results of a dynamic query, Christoph Haller
  - Re: plpgsql: return results of a dynamic query, Moritz Lennert
USING INDEX, Abdul Wahab Dahalan
Creating tables from within functions, Seethalakshmi VB
- Re: Creating tables from within functions, Stephan Szabo
Filter function, Evgen Potemkin
- Re: Filter function, Tom Lane
- Re: Filter function, Tom Lane
double linked list, Juergen
- Re: double linked list, --CELKO--
- Re: double linked list, DA Morgan
- Re: double linked list, Christoph Haller
  - Re: double linked list, Alan Gutierrez
- Re: double linked list, Christoph Haller
Please include hier-patch in next PostgreSQL version, Boris Klug
- Re: [HACKERS] Please include hier-patch in next PostgreSQL version, Rod Taylor
Cross-table constraints, Rodger Donaldson
- Re: Cross-table constraints, Stephan Szabo
- Re: Cross-table constraints, Bruno Wolff III
- Re: Cross-table constraints, Rodger Donaldson
  - Re: Cross-table constraints, Stephan Szabo
checking data integrity in a recursive table, Luke Pascoe
- Re: checking data integrity in a recursive table, Bruce Momjian
LONG - Question on dealing w/ numerics, David Durst
- Re: LONG - Question on dealing w/ numerics, Josh Berkus
- Re: LONG - Question on dealing w/ numerics, Josh Berkus
- Re: LONG - Question on dealing w/ numerics, Tom Lane
  - Re: LONG - Question on dealing w/ numerics, David Durst
    - Re: LONG - Question on dealing w/ numerics, Tom Lane
Problem with query, Ricardo Javier Aranibar León
- Re: Problem with query, Tom Lane
- Re: Problem with query, Josh Berkus
Cross-database references, Pedro Igor Craveiro e Silva
- Re: Cross-database references, Jason Turner
- Re: Cross-database references, Roberto Mello
CSV import, Oliver Vecernik
- Re: CSV import, Achilleus Mantzios
- Re: CSV import, Guy Fraser
  - Re: CSV import, Jean-Luc Lachance
    - Re: CSV import, Chad Thompson
    - Re: CSV import, Oliver Vecernik
    - Re: CSV import, Jean-Luc Lachance
- Re: CSV import, Jeff Eckermann
- Re: CSV import, Oliver Vecernik
  - Re: CSV import, Gary Stainburn
- Re: CSV import, Rodger Donaldson
import error, Oliver Vecernik
- Re: import error, Achilleus Mantzios
  - Re: import error, Achilleus Mantzios
- Re: CR/LF conversion (was: import error), Oliver Vecernik
  - Re: CR/LF conversion (was: import error), Achilleus Mantzios
  - Re: CR/LF conversion (was: import error), Tom Lane
- Re: import error, Tom Lane
subselect return in where clause, Michael Hostbaek
- Re: subselect return in where clause, Tom Lane
converting microsoft sql server 2000 sql-code for postgresql 7.2.1, william windels
- Re: converting microsoft sql server 2000 sql-code for postgresql, Bhuvan A
- Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1, Geraint Jones
- Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1, Rajesh Kumar Mallah.
  - Re: converting microsoft sql server 2000 sql-code for postgresql, Guy Fraser
    - Re: converting microsoft sql server 2000 sql-code for postgresql, Tom Lane
    - Re: converting microsoft sql server 2000 sql-code for postgresql, Wei Weng
    - Re: converting microsoft sql server 2000 sql-code for postgresql, Bruno Wolff III
- Re: converting microsoft sql server 2000 sql-code for postgresql 7.2.1, Jeff Eckermann
- Converting clarion, Nasair Junior da Silva
  - Re: Converting clarion, Oliver Vecernik
sequence question, Marie G. Tuite
- Re: sequence question, Rod Kreisler
Re: [ADMIN] how sub queries and joins differs funcationally, Ludwig Lim
ERROR: Cannot display a value of type RECORD, David Durst
- Re: ERROR: Cannot display a value of type RECORD, David Durst
Function for adding Money type, David Durst
- Re: Function for adding Money type, Josh Berkus
  - Re: Function for adding Money type, David Durst
  - Re: [SQL] Function for adding Money type, D'Arcy J.M. Cain
    - Re: Function for adding Money type, Thomas Good
    - Re: Function for adding Money type, Oliver Elphick
    - Re: [SQL] Function for adding Money type, Bruce Momjian
Getting multiple rows in plpgsql function, David Durst
- Re: Getting multiple rows in plpgsql function, Roberto Mello
  - Re: Getting multiple rows in plpgsql function, Guy Fraser
Race condition w/ FIFO Queue reappears!, Chris Gamache
quastions about primary key, jack
- Re: quastions about primary key, Tomasz Myrta
- Re: quastions about primary key, Stephan Szabo
  - Re: quastions about primary key, jack
    - Re: quastions about primary key, Bruno Wolff III
CAST from VARCHAR to INT, Luke Pascoe
- Re: CAST from VARCHAR to INT, Bhuvan A
  - Re: CAST from VARCHAR to INT, Luke Pascoe
- Re: CAST from VARCHAR to INT, Tom Lane
- Re: CAST from VARCHAR to INT, daq
  - Re: CAST from VARCHAR to INT, Tom Lane
    - Re: CAST from VARCHAR to INT, Roberto Mello
plpgsql: debugging, Oliver Vecernik
- Re: plpgsql: debugging, Ludwig Lim
Scheduling Events?, David Durst
- Re: Scheduling Events?, Roberto Mello
- Re: Scheduling Events?, Achilleus Mantzios
  - Re: Scheduling Events?, David Durst
    - Re: Scheduling Events?, Achilleus Mantzios
    - Re: Scheduling Events?, Tom Lane
    - Re: Scheduling Events?, Wei Weng
    - Re: Scheduling Events?, Guy Fraser
    - Re: Scheduling Events?, Bruno Wolff III
    - Re: Scheduling Events?, David Durst
    - Re: Scheduling Events?, Matthew Nuzum
- Re: Scheduling Events?, Ed L.
- Re: Scheduling Events?, David Durst
Rename database?, Wei Weng
- Re: Rename database?, Bruce Momjian
- Re: Rename database?, codeWarrior
(unknown), Bruce Becker
Re: CREATE VIEW ERROR, Igor
Slow query, Ricardo Javier Aranibar León
- Re: Slow query, Tomasz Myrta
calling function from rule, Tambet Matiisen
- Re: calling function from rule, Tom Lane
- Re: calling function from rule, Tambet Matiisen
  - Re: calling function from rule, Tom Lane
    - SQL to list databases?, Ben Siders
    - Re: SQL to list databases?, Larry Rosenman
    - Re: SQL to list databases?, Guy Fraser
    - Re: SQL to list databases?, Kristopher Yates
    - Re: SQL to list databases?, Roberto Mello
    - Re: SQL to list databases?, Keith Keller
    - Re: SQL to list databases?, Steve Crawford
    - Re: SQL to list databases?, Horst Herb
- Re: calling function from rule, Tambet Matiisen
DBCC CheckIdent in a stored proc?, smoghe
- Re: DBCC CheckIdent in a stored proc?, Bhuvan A
To use a VIEW or not to use a View....., Ries van Twisk
- Re: To use a VIEW or not to use a View....., Bruno Wolff III
- Re: To use a VIEW or not to use a View....., Jan Wieck
  - Re: To use a VIEW or not to use a View....., Tomasz Myrta
    - Re: To use a VIEW or not to use a View....., Stephan Szabo
    - Re: To use a VIEW or not to use a View....., Tomasz Myrta
    - Re: To use a VIEW or not to use a View....., Tomasz Myrta
    - Re: To use a VIEW or not to use a View....., Stephan Szabo
    - Re: To use a VIEW or not to use a View....., Tomasz Myrta
    - Re: To use a VIEW or not to use a View....., Stephan Szabo
    - Re: To use a VIEW or not to use a View....., Tom Lane
    - Re: To use a VIEW or not to use a View....., Stephan Szabo
    - Re: To use a VIEW or not to use a View....., Tom Lane
    - Re: To use a VIEW or not to use a View....., Stephan Szabo
    - Re: To use a VIEW or not to use a View....., Tom Lane
    - Re: To use a VIEW or not to use a View....., Stephan Szabo
    - Re: To use a VIEW or not to use a View....., Tom Lane
    - Re: To use a VIEW or not to use a View....., jasiek
    - Re: To use a VIEW or not to use a View....., Jan Wieck
- Re: To use a VIEW or not to use a View....., Tomasz Myrta
  - Re: To use a VIEW or not to use a View....., Ries van Twisk
    - Re: To use a VIEW or not to use a View....., Tomasz Myrta
- Re: To use a VIEW or not to use a View....., Stephan Szabo
PostgreSQL + SSL, Pedro Igor Craveiro e Silva
- Re: PostgreSQL + SSL, Bhuvan A
  - Re: PostgreSQL + SSL, Bruce Momjian
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index, David Durst
- Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index, Ludwig Lim
optimal sql, Michael Hostbaek
- Re: optimal sql, Achilleus Mantzios
  - Re: optimal sql, Michael Paesold
    - Re: optimal sql, Achilleus Mantzios
- Re: optimal sql, Tomasz Myrta
  - Re: optimal sql, Michael Hostbaek
    - Re: optimal sql, Tomasz Myrta
Oops - help error., Rudi Starcevic
help, Rudi Starcevic
returning setof in plpgsql, David Durst
- Re: returning setof in plpgsql, Gary Stainburn
- Re: returning setof in plpgsql, Tom Lane
  - Re: returning setof in plpgsql, Bruce Momjian
[OT] Unsubscribe does not work, Andreas Tille
- Re: [OT] Unsubscribe does not work, Bruno Wolff III
  - Re: [OT] Unsubscribe does not work, Andreas Tille
  - Re: [OT] Unsubscribe does not work, Tom Lane
Speed depending of Join Order., Raúl Gutiérrez Sánchez
- Re: Speed depending of Join Order., Tom Lane
- Re: Speed depending of Join Order., Tom Lane
Could someone help me fix my array_list function?, Guy Fraser
- Re: Could someone help me fix my array_list function?, Joe Conway
  - Re: Could someone help me fix my array_list function?, Michiel Lange
    - Re: Could someone help me fix my array_list function?, Joe Conway
performance question, Moritz Lennert
- Re: performance question, Manfred Koizar
  - Message not available
    - Message not available
    - Re: performance question, Moritz Lennert
  - Message not available
    - Message not available
    - Message not available
    - Re: performance question, Manfred Koizar
- Re: performance question, Moritz Lennert
- Re: performance question, Josh Berkus
  - Re: performance question, Moritz Lennert
- Re: performance question, Tom Lane
  - Re: performance question, Vernon Wu
- Re: performance question, Tomasz Myrta
- Re: performance question, Josh Berkus
- performance question, Moritz Lennert
Group By Error Text, Joseph Healy
- Re: Group By Error Text, Josh Berkus
Selecting a non-locked row., Kurt Roeckx
- Re: Selecting a non-locked row., Josh Berkus
  - Re: Selecting a non-locked row., Kurt Roeckx
    - Re: Selecting a non-locked row., Josh Berkus
  - Re: Selecting a non-locked row., D'Arcy J.M. Cain
Problem with COPY FROM, Harry Yau
Can I do this?, Wei Weng
- Re: Can I do this?, Josh Berkus
- Re: Can I do this?, Bruce Momjian
"Best practice" advice, Andrew Perrin
- Re: "Best practice" advice, Josh Berkus
RCF: 2nd draft: A brief guide to Nulls, dev
sum(time) problem, Oliver Vecernik
- Re: sum(time) problem, Julian Scarfe
  - Re: sum(time) problem, Tom Lane
cannot create function that uses variable table name, Matthew Nuzum
- Re: cannot create function that uses variable table name, chester c young
- Re: cannot create function that uses variable table name, Stephan Szabo
- Re: cannot create function that uses variable table name, D'Arcy J.M. Cain
- Re: cannot create function that uses variable table name, Beth
  - Message not available
    - Re: cannot create function that uses variable table name, Beth
pg_restore cannot restore an index, Jie Liang
- Re: pg_restore cannot restore an index, Bruce Momjian
- Re: pg_restore cannot restore an index, Jie Liang
Function unkown, Pedro Igor
- Re: Function unkown, Tomasz Myrta
Implementing automatic updating of primary keys..., Rajesh Kumar Mallah.
- Re: Implementing automatic updating of primary keys..., Tomasz Myrta
  - Re: Implementing automatic updating of primary keys..., Rajesh Kumar Mallah.
- Re: Implementing automatic updating of primary keys..., Bhuvan A
pg_dump problem, Rudi Starcevic
- Re: pg_dump problem, Tomasz Myrta
- Re: pg_dump problem, Bhuvan A
show data from two tables together, Matthew Nuzum
- Re: show data from two tables together, Stephan Szabo
  - Re: show data from two tables together, Matthew Nuzum
joining from multiple tables, Joseph Shraibman
- Re: joining from multiple tables, Stephan Szabo
Re: sub-select with aggregate, Tom Lane
lost on self joins, Matthew Nuzum
- Re: lost on self joins, Tomasz Myrta
  - Re: lost on self joins, Matthew Nuzum
    - Re: lost on self joins, Ross J. Reedstrom
    - Re: lost on self joins, Tomasz Myrta
- Re: lost on self joins, Bruno Wolff III
RFC: A brief guide to nulls, dev
- Re: A brief guide to nulls, Otto Hirr
- Re: RFC: A brief guide to nulls, Andrew Perrin
- Re: RFC: A brief guide to nulls, Josh Berkus
- Re: RFC: A brief guide to nulls, Antti Haapala
- Re: RFC: A brief guide to nulls, Bruno Wolff III
- Re: RFC: A brief guide to nulls, Antti Haapala
- Re: RFC: A brief guide to nulls, Peter Eisentraut
  - Re: RFC: A brief guide to nulls, Tom Lane
- Re: RFC: A brief guide to nulls, Ludwig Lim
  - Re: RFC: A brief guide to nulls, dev
    - Re: RFC: A brief guide to nulls, Otto Hirr
  - Re: RFC: A brief guide to nulls, dev
- Re: RFC: A brief guide to nulls (noarchive), Ries van Twisk
Oracle outer join porting question, Marko Asplund
- Re: Oracle outer join porting question, Dan Langille
- Re: Oracle outer join porting question, Tambet Matiisen
  - Re: Oracle outer join porting question, Dan Langille
  - Re: Oracle outer join porting question, Marko Asplund
sort by relevance, sector119
- Re: [SQL] sort by relevance, Oleg Bartunov
  - Re: sort by relevance, Ross J. Reedstrom
  - Re: sort by relevance, sector119
  - Re: sort by relevance, Rajesh Kumar Mallah.
- sort by relevance, Serhiy Levchenko
  - Re: sort by relevance, Björn Metzdorf
index on to_char(created, 'YYYY') doesn't work, Andreas Joseph Krogh
- Re: index on to_char(created, 'YYYY') doesn't work, Andreas Joseph Krogh
  - Re: index on to_char(created, 'YYYY') doesn't work, Achilleus Mantzios
    - Re: index on to_char(created, 'YYYY') doesn't work, Andreas Joseph Krogh
    - Re: index on to_char(created, 'YYYY') doesn't work, Achilleus Mantzios
    - Re: index on to_char(created, 'YYYY') doesn't work, Andreas Joseph Krogh
    - Re: index on to_char(created, 'YYYY') doesn't work, Achilleus Mantzios
    - Re: index on to_char(created, 'YYYY') doesn't work, Andreas Joseph Krogh
    - Re: index on to_char(created, 'YYYY') doesn't work, Tom Lane
    - Re: index on to_char(created, 'YYYY') doesn't work, Steve Crawford
    - Re: index on to_char(created, 'YYYY') doesn't work, Josh Berkus
Performance of request of type WHERE ... IN ( ... ), Th Templ
- Re: Performance of request of type WHERE ... IN ( ... ), Achilleus Mantzios
  - Re: Performance of request of type WHERE ... IN ( ... ), Josh Berkus
database broken ?, mdc@xxxxxxxxxxx
- Re: database broken ?, Tom Lane
Data between different databases, Pedro Igor
query speed joining tables, Christopher Smith
- Re: query speed joining tables, Josh Berkus
  - Re: query speed joining tables, Christopher Smith
- Re: query speed joining tables, Tomasz Myrta
  - Re: query speed joining tables, Christopher Smith
    - Re: query speed joining tables, Tomasz Myrta
- Re: query speed joining tables, Josh Berkus
  - Re: query speed joining tables, Vernon Wu
    - Re: query speed joining tables, Josh Berkus
    - Re: query speed joining tables, Josh Berkus
    - Re: query speed joining tables, Vernon Wu
    - Re: query speed joining tables, Josh Berkus
assigning values to array elements, J Greenbaum
- Re: assigning values to array elements, Tom Lane
  - Re: assigning values to array elements, J Greenbaum
  - Re: assigning values to array elements, Bruce Momjian
to_date confusion, Richard Rowell
- Re: to_date confusion, Josh Berkus
  - Re: to_date confusion, Stephan Szabo
Returning row or rows from function?, David Durst
- Re: Returning row or rows from function?, Stephan Szabo
- Re: Returning row or rows from function?, Tomasz Myrta
PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied., Zengfa Gao
- Re: PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied., Chris Travers
Crosstab-style query in pure SQL, dev
- Re: Crosstab-style query in pure SQL, Josh Berkus
  - Re: Crosstab-style query in pure SQL, dev
Unique indexes not unique?, Jimmy Mäkelä
- Re: Unique indexes not unique?, Tomasz Myrta
  - Re: Unique indexes not unique?, dev
- Re: Unique indexes not unique?, Stephan Szabo
  - Re: Unique indexes not unique?, Tom Lane
    - Re: Unique indexes not unique?, Stephan Szabo
    - Re: Unique indexes not unique?, Tom Lane
- Re: Unique indexes not unique?, Jimmy Mäkelä
- Re: Unique indexes not unique?, Jimmy Mäkelä
Re: Select * from users WHERE upper(lastName) = upper('Pringle'), Tom Lane
function does not exist, Dave A.
- Re: function does not exist, Ross J. Reedstrom
- Re: function does not exist, Josh Berkus
Table Design Questions, Chad L
- Re: Table Design Questions, dev
- Re: Table Design Questions, Josh Berkus
Getting sequence value after inserting many rows at a time, Maurício Sessue Otta
- Re: Getting sequence value after inserting many rows at a time, Bruno Wolff III
- Re: Getting sequence value after inserting many rows at a time, Bruno Wolff III
SQL function parse error ?, Radu-Adrian Popescu
- Re: SQL function parse error ?, Tomasz Myrta
  - Re: SQL function parse error ?, Radu-Adrian Popescu
    - Re: SQL function parse error ?, Tomasz Myrta
    - Re: SQL function parse error ?, Radu-Adrian Popescu
    - Re: SQL function parse error ?, Achilleus Mantzios
    - Re: SQL function parse error ?, Radu-Adrian Popescu
    - Re: SQL function parse error ?, Stephan Szabo
    - Re: SQL function parse error ?, Tom Lane
    - Re: SQL function parse error ?, Radu-Adrian Popescu
    - Re: SQL function parse error ?, Robert Treat
    - Re: SQL function parse error ?, Radu-Adrian Popescu
    - Re: SQL function parse error ?, Robert Treat
    - Re: SQL function parse error ?, Tom Lane
    - Re: SQL function parse error ?, Stephan Szabo
    - Re: SQL function parse error ?, Tom Lane
    - Re: SQL function parse error ?, Radu-Adrian Popescu
    - Re: SQL function parse error ?, Tom Lane
    - Re: SQL function parse error ?, Radu-Adrian Popescu
switching default integer datatype to int8 and "IN (...)" clause, postgres
- Re: switching default integer datatype to int8 and "IN (...)" clause, Andrew J. Kopciuch
  - Re: switching default integer datatype to int8 and "IN (...)", postgres
http://www.postgresql.org site problem, Achilleus Mantzios
Postgresql Bug List?, Wei Weng
- Re: Postgresql Bug List?, Bruce Momjian
  - Re: Postgresql Bug List?, Robert Treat
- Postgresql Bug List?, Wei Weng
  - Re: Postgresql Bug List?, Bruce Momjian
What benefits can I expect from schemas ?, Bob Lapique
- Re: What benefits can I expect from schemas ?, Bruce Momjian
  - Re: What benefits can I expect from schemas ?, chester c young
    - Re: What benefits can I expect from schemas ?, Bruce Momjian
count(*) optimization, Nikola Ivacic
- Re: count(*) optimization, Bruno Wolff III
  - Re: count(*) optimization, Nikola Ivacic
- Re: count(*) optimization, Nikola Ivacic
  - Re: count(*) optimization, Josh Berkus
to_date() confusion, Richard Rowell
- Re: to_date() confusion, Bruno Wolff III
full join in view, Tambet Matiisen
- Re: full join in view, Tomasz Myrta
- Re: full join in view, Tambet Matiisen
  - Re: full join in view, Tomasz Myrta
- Re: full join in view, Tambet Matiisen
  - Re: full join in view, jasiek
- Re: full join in view, Tambet Matiisen
double precision to numeric overflow error, Thomas O'Connell
- Re: double precision to numeric overflow error, Stephan Szabo
  - Re: double precision to numeric overflow error, Thomas O'Connell
    - Re: [GENERAL] double precision to numeric overflow error, Tom Lane
    - Re: double precision to numeric overflow error, Thomas O'Connell
    - Re: double precision to numeric overflow error, Jan Wieck
insert rule doesn't see id field, Ron Peterson
- Re: insert rule doesn't see id field, Ron Peterson
- Re: insert rule doesn't see id field, Tom Lane
  - Re: insert rule doesn't see id field, Ron Peterson
    - Re: insert rule doesn't see id field, Ron Peterson
    - Re: insert rule doesn't see id field, dev
    - Re: insert rule doesn't see id field, Ron Peterson
    - Re: insert rule doesn't see id field, Ron Peterson
    - Re: insert rule doesn't see id field, Tom Lane
    - Re: insert rule doesn't see id field, Ron Peterson
    - Re: noupcol code cleanup, Ron Peterson
    - Re: insert rule doesn't see id field, Radu-Adrian Popescu
    - Re: insert rule doesn't see id field, Radu-Adrian Popescu
  - Re: insert rule doesn't see id field, Ron Peterson
    - Re: insert rule doesn't see id field, Tom Lane
A problem about alter table, jack
- Re: A problem about alter table, Tomasz Myrta
  - Re: A problem about alter table, jack
    - Re: A problem about alter table, Tomasz Myrta
    - Re: A problem about alter table, Achilleus Mantzios
- Re: A problem about alter table, Jeff Eckermann
Re: [SQL] 7.3.1 index use / performance, Achilleus Mantzios
Inherancing, Nasair Junior da Silva
- Re: Inherancing, Adam Witney
  - Re: Inherancing, Nasair Junior da Silva
    - Re: Inherancing, Adam Witney
- Re: Inherancing, Daniel Schuchardt
7.3.1 index use / performance, Achilleus Mantzios
- Re: [PERFORM] 7.3.1 index use / performance, Stephan Szabo
  - Re: [PERFORM] 7.3.1 index use / performance, Achilleus Mantzios
    - Re: [PERFORM] 7.3.1 index use / performance, Tom Lane
    - Re: [PERFORM] 7.3.1 index use / performance, Achilleus Mantzios
    - Re: [PERFORM] 7.3.1 index use / performance, Tom Lane
    - Re: [PERFORM] 7.3.1 index use / performance, Achilleus Mantzios
    - Re: [PERFORM] 7.3.1 index use / performance, Tom Lane
    - Re: [PERFORM] 7.3.1 index use / performance, Achilleus Mantzios
    - Re: [SQL] [PERFORM] 7.3.1 index use / performance, Tom Lane
    - Re: [PERFORM] 7.3.1 index use / performance, Rod Taylor
    - Re: [PERFORM] 7.3.1 index use / performance, Tom Lane
    - Re: [SQL] [PERFORM] 7.3.1 index use / performance, Achilleus Mantzios
- 7.3.1 function problem: ERROR: cache lookup failed for type 0, Achilleus Mantzios
  - Re: 7.3.1 function problem: ERROR: cache lookup failed for type 0, Tom Lane
    - Re: [GENERAL] 7.3.1 function problem: ERROR: cache lookup failed, Achilleus Mantzios
    - Re: [GENERAL] 7.3.1 function problem: ERROR: cache lookup failed, Joe Conway
SQL list table names, alviN
- Re: SQL list table names, Adam Witney
- Re: SQL list table names, Alan Gutierrez
  - Re: SQL list table names, Achilleus Mantzios
    - Search and Replace, Randy D. McCracken
    - Re: Search and Replace, Bruno Wolff III
    - Re: Search and Replace, Rajesh Kumar Mallah.
    - Re: Search and Replace, Ross J. Reedstrom
    - Re: [SQL] Search and Replace, Randy D. McCracken
    - Re: Search and Replace, Rajesh Kumar Mallah.
    - Re: Search and Replace, Ross J. Reedstrom
    - Re: [SQL] Search and Replace, Randy D. McCracken
    - Re: [SQL] Search and Replace, Bruno Wolff III
Re: Sorry, to many clients already, Tambet Matiisen
sub-select, view and sum(), Gary Stainburn
- Re: sub-select, view and sum(), Stephan Szabo
  - Re: sub-select, view and sum(), Gary Stainburn
order by and aggregate, Tomasz Myrta
- Re: order by and aggregate, Richard Huxton
  - Re: order by and aggregate, Tomasz Myrta
    - Sorry, to many clients already, cristi
    - Re: Sorry, to many clients already, Robert Treat
    - Re: order by and aggregate, dev
    - Re: order by and aggregate, Tomasz Myrta
    - Re: order by and aggregate, Tom Lane
    - Re: order by and aggregate, Tomasz Myrta
- Re: order by and aggregate, Tom Lane
  - Re: order by and aggregate, Tomasz Myrta
Grant execute on functions; related objects permissions ?, Cédric Dufour (public)
- Re: Grant execute on functions; related objects permissions ?, Tambet Matiisen
  - Re: Grant execute on functions; related objects permissions ?, Bruno Wolff III
weighting (the results of) a query ?, Peter Galbavy
- Re: weighting (the results of) a query ?, Peter Galbavy
  - Re: weighting (the results of) a query ?, Tom Lane
    - Re: weighting (the results of) a query ?, Peter Galbavy
    - Re: weighting (the results of) a query ?, Tom Lane
    - Re: weighting (the results of) a query ?, Peter Galbavy
Deleting in order from a table, pginfo
- Re: Deleting in order from a table, Ludwig Lim
SQL to determine Tablenames, Primarykeys & Foreignkeys], Kevin Gordon
Compiling pl/pgsql functions?, Daniel Bruce Lynes
Query, Pedro Igor
- Re: Query, Stephan Szabo
NULLL comparison in multiple column unique index, Brian Walker
- Re: NULLL comparison in multiple column unique index, Manfred Koizar
Adding a Primary Key to an exisiting table, Maly Kaing
- Re: Adding a Primary Key to an exisiting table, Bhuvan A
PostgreSQL X Resin EE, Pedro Igor
- Re: PostgreSQL X Resin EE, Radu-Adrian Popescu
bug?, Minghann Ho
- Re: bug?, Tom Lane
Slow self-join on a 100 million record table, Mark Davies
- Re: Slow self-join on a 100 million record table, Andrew J. Kelly
- Re: Slow self-join on a 100 million record table, Tom Lane
- Re: Slow self-join on a 100 million record table, Paul Thornett
Doubts porting from Oracle to postgresql, Senthil
empty arrays, floyds
- Re: empty arrays, Tom Lane
- Re: empty arrays, Steve Crawford
Multiple counts, Colin Fox
Re: Stuck on SQL Query where a calculated value is used for a join., ScottRArndt
Reference integrity question, Evgen Potemkin
- Re: Reference integrity question, Stephan Szabo
- Re: Reference integrity question, Stephan Szabo
CREATE INDEX question, Hans-Jürgen Schönig
Execution Plans and Casts, Hans-Jürgen Schönig
Internal functions documented, Daniel Bruce Lynes