db.postgresql.sql (thread)

pl/pgsql capabilities?, Ferenc Engard
selecting from integer[], Kelly
- Re: selecting from integer[], Christopher Kings-Lynne
- Re: selecting from integer[], Stephan Szabo
pg_group members, Kelly
- Re: pg_group members, Bruce Momjian
something similar to "on delete cascade" ?, Albrecht Berger
- Re: something similar to "on delete cascade" ?, Josh Berkus
Two-way query, Vernon Wu
pg_user and pg_group, q u a d r a
Subtraction of Dates, Valerie Goodman
- Re: Subtraction of Dates, Steve Brett
Function question, David Hassell
- Re: Function question, Steve Brett
- Re: Function question, Jie Liang
creating functional index over multiple columns, Chantal Ackermann
- Re: creating functional index over multiple columns, Christopher Kings-Lynne
- Re: creating functional index over multiple columns, Chantal Ackermann
transaction in plpgsql, Joseph Syjuco
- Re: transaction in plpgsql, Josh Berkus
- Re: transaction in plpgsql, Nils Höglund
- Re: transaction in plpgsql, Josh Berkus
time difference, q u a d r a
Unsubscription -- How?, David Secret
to_char() and order-by, Jeff Boes
- Re: to_char() and order-by, Karel Zak
  - Re: to_char() and order-by, Jeff Boes
Re: Slow SELECT -> Growing Database, Marcos Garcia
- Re: Slow SELECT -> Growing Database, Stephan Szabo
- Re: Slow SELECT -> Growing Database, Marc Spitzer
- Re: Slow SELECT -> Growing Database, Tatsuo Ishii
CHECK clause doesn't work with CASE clause, Jörg Holetschek
- Re: CHECK clause doesn't work with CASE clause, Tom Lane
- Re: CHECK clause doesn't work with CASE clause, Richard Poole
- Re: CHECK clause doesn't work with CASE clause, Richard Huxton
Calculating with sql, Dennis Kaarsemaker
- Re: Calculating with sql, Masaru Sugawara
  - Re: Calculating with sql, Dennis Kaarsemaker
  - Re: Calculating with sql, Masaru Sugawara
graphical interface - admin, q u a d r a
- Re: graphical interface - admin, Ron Peterson
- Re: graphical interface - admin, David BOURIAUD
  - Re: graphical interface - admin, Josh Berkus
  - Re: graphical interface - admin, Robert Treat
- Re: graphical interface - admin, terry
  - Re: graphical interface - admin, Josh Berkus
pg_restore cannot restore function, Jie Liang
- pg_restore cannot restore function, Jie Liang
  - Re: pg_restore cannot restore function, Jan Wieck
- Re: pg_restore cannot restore function, Jie Liang
- Re: pg_restore cannot restore function, Jie Liang
Possibility of Index-Only access in PostgreSQL?, Gunther Schadow
- Re: Possibility of Index-Only access in PostgreSQL?, Tom Lane
  - Re: Possibility of Index-Only access in PostgreSQL?, Gunther Schadow
- Re: Possibility of Index-Only access in PostgreSQL?, Christopher Kings-Lynne
Efficient Query For Mapping IP Addresses To Country Code., Rajesh Kumar Mallah.
sequence chages after firing update, Subhashini Karthikeyan
- Re: sequence chages after firing update, Stephan Szabo
- Re: sequence chages after firing update, Rajesh Kumar Mallah.
Performance Ideas, Eric
- Re: Performance Ideas, Tom Lane
2 Selects 1 is faster, why?, Eric
- Re: 2 Selects 1 is faster, why?, Alvar Freude
  - Re: 2 Selects 1 is faster, why?, Masaru Sugawara
    - Re: 2 Selects 1 is faster, why?, Keith Gray
    - Re: 2 Selects 1 is faster, why?, Tom Lane
Quickest way to insert unique records?, Ian Cass
what is the difference between default 0 vs default '0', Beth Gatewood
- Re: what is the difference between default 0 vs default '0', Christopher Kings-Lynne
- Re: what is the difference between default 0 vs default '0', Lee Harr
PostgreSQL Cookbook update, Roberto Mello
unique index on function and column, Bruno Wolff III
- Re: unique index on function and column, Tom Lane
  - Re: unique index on function and column, Bruno Wolff III
- Re: unique index on function and column, Josh Berkus
  - Re: unique index on function and column, Bruno Wolff III
altering column width, tdn
Slow SELECT with distinct, in a TIMESTAMP type column, Marcos Garcia
- Re: Slow SELECT with distinct, in a TIMESTAMP type column, Stephan Szabo
  - Re: Slow SELECT with distinct, in a TIMESTAMP type column, Marcos Garcia
    - Re: Slow SELECT with distinct, in a TIMESTAMP type column, Stephan Szabo
index problem, Oleg Lebedev
assign count() result to a declared variable in plpgsql, Joseph Syjuco
- Re: assign count() result to a declared variable in plpgsql, Tom Lane
- Re: assign count() result to a declared variable in plpgsql, Jeff Eckermann
variance aggregate function incorrect? Reference Materials reg create aggregate, Joseph Syjuco
- Re: variance aggregate function incorrect? Reference Materials reg create aggregate, Tom Lane
- Re: variance aggregate function incorrect? Reference Materials, Bruce Momjian
Select + min question, Devrim GUNDUZ
- Re: Select + min question, Christopher Kings-Lynne
  - Re: Select + min question, Devrim GUNDUZ
- Re: Select + min question, Mathieu Arnold
A problem on running a sql script in DBVisualizer, Vernon Wu
Obtaining primary key information from pg system tables, Kris
- Re: Obtaining primary key information from pg system tables, Dmitri Colebatch
  - Re: Obtaining primary key information from pg system tables, Kris
Can somebody help me to optimize this huge query?, Dirk Lutzebaeck
- Re: Can somebody help me to optimize this huge query?, Josh Berkus
FW: RESTORE A TABLE, Jie Liang
Presenting consistent data, Ian Lynagh
is it easy to change the create sequence algorithm?, Kevin Brannen
- Re: is it easy to change the create sequence algorithm?, Josh Berkus
- Re: is it easy to change the create sequence algorithm?, Andrew Hammond
rowtype and ecpg, Alla
- Re: rowtype and ecpg, Christoph Haller
  - Re: rowtype and ecpg, Alla
Re: [ADMIN] Incredible.., Cliff Wells
- Re: [ADMIN] Incredible.., Larry Rosenman
Optimizer question with equivalent joins, Dirk Lutzebaeck
- Re: Optimizer question with equivalent joins, Tom Lane
date_ge and time_ge, juerg . rietmann
- Re: date_ge and time_ge, Achilleus Mantzios
Re: skip weekends, Rudi Starcevic
- Re: skip weekends, Cliff Wells
- Re: skip weekends, Josh Berkus
SQL Challenge: Skip Weekends, Josh Berkus
- Re: SQL Challenge: Skip Weekends, Joe Conway
  - Re: SQL Challenge: Skip Weekends, Josh Berkus
- Re: SQL Challenge: Skip Weekends, Jean-Luc Lachance
  - Re: SQL Challenge: Skip Weekends, Josh Berkus
how to sort a birthday list ?, Michael Agbaglo
- Re: how to sort a birthday list ?, David Stanaway
  - Re: how to sort a birthday list ?, Michael Agbaglo
- Re: how to sort a birthday list ?, Josh Berkus
  - Re: how to sort a birthday list ?, Michael Agbaglo
    - Re: how to sort a birthday list ?, Bruno Wolff III
    - Re: how to sort a birthday list ?, Jan Wieck
slow DELETE queries, Denis
- Re: slow DELETE queries, Manfred Koizar
  - Re: slow DELETE queries, Denis
psql -E <dbname> Floating exception (coredump), Christoph Haller
- Re: psql -E <dbname> Floating exception (coredump), Tom Lane
Rows affected, Rudi Starcevic
- Re: Rows affected, Gaetano Mendola
Assign values to array, afa
- Message not available
  - Re: Assign values to array, Arve Fahlvik
Which one is faster?, Wei Weng
- Re: Which one is faster?, Bruce Momjian
  - Re: Which one is faster?, Jan Wieck
    - Re: Which one is faster?, Bruce Momjian
syntax for access an alias in the where clause ?, Michael Agbaglo
- Re: syntax for access an alias in the where clause ?, Wei Weng
  - Re: syntax for access an alias in the where clause ?, Michael Agbaglo
    - Re: syntax for access an alias in the where clause ?, Ross J. Reedstrom
- Re: syntax for access an alias in the where clause ?, Tom Lane
- Re: syntax for access an alias in the where clause ?, Jeff Eckermann
- Re: syntax for access an alias in the where clause ?, Stephan Szabo
Tagging rows into collections?, Steve Wampler
- Re: Tagging rows into collections?, Tom Lane
  - Re: Tagging rows into collections?, Steve Wampler
  - Re: Tagging rows into collections?, Richard Huxton
SQL performance issue with PostgreSQL compared to MySQL, Jeff Self
- Re: SQL performance issue with PostgreSQL compared to MySQL, Tom Lane
  - Re: SQL performance issue with PostgreSQL compared to MySQL, Bruce Momjian
- Re: SQL performance issue with PostgreSQL compared to, Josh Berkus
  - Re: SQL performance issue with PostgreSQL compared to, Achilleus Mantzios
    - Re: SQL performance issue with PostgreSQL compared to, Josh Berkus
Mirar y reenviar por favor!!! son 2 segundos, Marta Beatriz Caldentey
Joining three data sources., Janning Vygen
- Re: Joining three data sources., Masaru Sugawara
  - Re: Joining three data sources., Janning Vygen
    - Re: Joining three data sources., Masaru Sugawara
  - Re: Joining three data sources., Janning Vygen
Aggregates not allowed in WHERE clause?, Joachim Trinkwitz
- Re: Aggregates not allowed in WHERE clause?, Christopher Kings-Lynne
- Re: Aggregates not allowed in WHERE clause?, Achilleus Mantzios
- Re: Aggregates not allowed in WHERE clause?, Christoph Haller
  - Re: Aggregates not allowed in WHERE clause?, Joachim Trinkwitz
Help with a "recursive" query, Jerome Alet
- Re: Help with a "recursive" query, Oleg Bartunov
date_part, Rudi Starcevic
- Re: date_part, Josh Berkus
text vs varchar, Wei Weng
- Re: text vs varchar, Josh Berkus
  - Re: text vs varchar, Wei Weng
  - Re: text vs varchar, Josh Goldberg
  - Re: text vs varchar, Achilleus Mantzios
- Re: text vs varchar, Michelle Murrain
function text_ge(text, text), how to use on version 7.2, juerg . rietmann
- Re: function text_ge(text, text), how to use on version 7.2, Achilleus Mantzios
Users, Andy Pearce
- Re: Users, Bruno Wolff III
Request for builtin function: Double_quote, Josh Berkus
- Re: Request for builtin function: Double_quote, Christoph Haller
- Re: Request for builtin function: Double_quote, Tom Lane
- Re: Request for builtin function: Double_quote, Josh Berkus
  - Re: Request for builtin function: Double_quote, Tom Lane
  - Message not available
    - Re: Request for builtin function: Double_quote, Josh Berkus
check, Matt
- Re: check, Christopher Kings-Lynne
- Re: check, Stephan Szabo
- Re: check, Manfred Koizar
template1 - recreate, Rudi Starcevic
- Re: template1 - recreate, Josh Berkus
function not running after upgrade from 7.03 to 7.2, juerg . rietmann
- Re: function not running after upgrade from 7.03 to 7.2, Jan Wieck
ON DELETE CASCADE question, Wei Weng
- Re: ON DELETE CASCADE question, Josh Berkus
  - Re: ON DELETE CASCADE question, Jan Wieck
Function not running after upgrade 7.03 to 7.2, juerg . rietmann
- Re: Function not running after upgrade 7.03 to 7.2, Christopher Kings-Lynne
simple recursive function in plpgsql fails, Andrew Hammond
- Re: simple recursive function in plpgsql fails, Tom Lane
Please help me out on this insert error, Vernon Wu
- Re: Please help me out on this insert error, Joe Conway
- Re: Please help me out on this insert error, Stephan Szabo
  - Re: Please help me out on this insert error, Vernon Wu
    - Re: Please help me out on this insert error, Stephan Szabo
    - Re: Please help me out on this insert error, Vernon Wu
- Re: Please help me out on this insert error, Manfred Koizar
serial column vs. explicit sequence question, Charlie Toohey
- Re: serial column vs. explicit sequence question, Stephan Szabo
  - Re: serial column vs. explicit sequence question, Charlie Toohey
- Re: serial column vs. explicit sequence question, Josh Berkus
- Re: serial column vs. explicit sequence question, Tom Lane
- Re: serial column vs. explicit sequence question, Jason Earl
  - Re: serial column vs. explicit sequence question, Charlie Toohey
- Re: serial column vs. explicit sequence question, Stephan Szabo
Isn't there a better way?, Josh Berkus
how do i provide array parameters for my functions in php, joseph
- Re: how do i provide array parameters for my functions in php, Achilleus Mantzios
join question - three tables, two with foreign keys to the first, Dmitri Colebatch
- Re: join question - three tables, two with foreign keys to the first, Dmitri Colebatch
  - Re: join question - three tables, two with foreign keys to, Stephan Szabo
    - Re: join question - requesting for a simple C program where it can INSERT data into database as reference, joo
    - join question - requesting for a simple C program where it can INSERT data into database as reference, Christoph Haller
- Re: join question - three tables, two with foreign keys to the first, Manfred Koizar
  - Re: join question - three tables, two with foreign keys to the first, Dmitri Colebatch
Another postgres 'file not found' error, Ian Cass
- Re: Another postgres 'file not found' error, Achilleus Mantzios
- Re: Another postgres 'file not found' error, Josh Berkus
  - Re: Another postgres 'file not found' error, Ian Cass
    - Re: Another postgres 'file not found' error, Josh Berkus
    - Re: Another postgres 'file not found' error, Oliver Elphick
- Re: Another postgres 'file not found' error, Tom Lane
How to unsubscribe?, SDX
Rule problem, Svenn Helge Grindhaug
- Re: Rule problem, Tom Lane
Case insensitive select, isaac flemmin
- Re: Case insensitive select, Josh Berkus
  - Re: Case insensitive select, isaac flemmin
- Re: Case insensitive select, Stephan Szabo
  - Re: Case insensitive select, isaac flemmin
    - Re: Case insensitive select, Josh Berkus
How to remove contraint, Vernon Wu
- Re: How to remove contraint, Christopher Kings-Lynne
Timestamp problem, kumar
- Re: Timestamp problem, Stephan Szabo
Domains, Andy Pearce
- Re: Domains, Bruce Momjian
Select * (but exclude columns), Adam
General trigger function, GRIMOIS Eric
- Re: General trigger function, Jan Wieck
  - Re: General trigger function, Richard Huxton
make a unique index for foreign keys?, Beth Gatewood
- Re: make a unique index for foreign keys?, Josh Berkus
- Re: make a unique index for foreign keys?, Josh Berkus
  - Re: make a unique index for foreign keys?, Beth Gatewood
    - Re: make a unique index for foreign keys?, Christopher Kings-Lynne
    - Re: make a unique index for foreign keys?, Beth Gatewood
    - Re: make a unique index for foreign keys?, Jan Wieck
    - Re: make a unique index for foreign keys?, Christopher Kings-Lynne
temporary tables, Marie G. Tuite
- Re: temporary tables, Bruce Momjian
inheritance problems, Matt
- inheritance problems, Matt
  - Re: inheritance problems, Stephan Szabo
Unicode and escaping single quotes, Olaf Frączyk
- Re: Unicode and escaping single quotes, Tatsuo Ishii
  - Re: Unicode and escaping single quotes, Olaf Frączyk
Re: Temporary table weirdness, Bruce Momjian
Re: [GENERAL] VIEWs and FOREIGN keys, Jan Wieck
- Re: [GENERAL] VIEWs and FOREIGN keys, terry
- Re: [GENERAL] VIEWs and FOREIGN keys, Tom Lane
- Re: [GENERAL] VIEWs and FOREIGN keys, Achilleus Mantzios
Re: [HACKERS] Efficient DELETE Strategies, Bruce Momjian
- Re: [HACKERS] Efficient DELETE Strategies, Tom Lane
- Re: [HACKERS] Efficient DELETE Strategies, Bruce Momjian
- Re: [HACKERS] Efficient DELETE Strategies, Dann Corbit
- Re: [HACKERS] Efficient DELETE Strategies, Hannu Krosing
multiple primary keys and reference, Matt
- Re: multiple primary keys and reference, Achilleus Mantzios
- Re: multiple primary keys and reference, Stephan Szabo
Efficient DELETE Strategies, Christoph Haller
- Re: Efficient DELETE Strategies, Tom Lane
  - Re: Efficient DELETE Strategies, Bruce Momjian
  - Re: Efficient DELETE Strategies, Manfred Koizar
    - Re: Efficient DELETE Strategies, Tom Lane
    - Re: Efficient DELETE Strategies, Josh Berkus
    - Re: [HACKERS] Efficient DELETE Strategies, Christopher Kings-Lynne
  - Message not available
    - Re: [HACKERS] Efficient DELETE Strategies, Barry Lind
  - Re: [HACKERS] Efficient DELETE Strategies, Hannu Krosing
- Re: Efficient DELETE Strategies, Christoph Haller
  - Re: Efficient DELETE Strategies, Tom Lane
    - Re: Efficient DELETE Strategies, Manfred Koizar
    - Re: Efficient DELETE Strategies, Tom Lane
    - Re: Efficient DELETE Strategies, Manfred Koizar
    - Re: Efficient DELETE Strategies, Bruce Momjian
Rule to fill in value on column on insert, Bradley Kieser
- Re: Rule to fill in value on column on insert, Christopher Kings-Lynne
- Re: Rule to fill in value on column on insert, Tom Lane
Support for distributed queries with semijoins could be possible, if ..., Gunther Schadow
- Re: Support for distributed queries with semijoins could be possible, if ..., Tom Lane
Q: will GROUP BY make use of an index to return tuples early?, Gunther Schadow
- Re: Q: will GROUP BY make use of an index to return tuples early?, Tom Lane
Re: [HACKERS] PostgreSQL on AIX, Bruce Momjian
- Re: [HACKERS] PostgreSQL on AIX, Zeugswetter Andreas SB SD
Re: PostgreSQL on AIX, Bruce Momjian
encryp pass, Ricardo Javier Aranibar León
Limiting database size, Maurício Sessue Otta
- Re: Limiting database size, Josh Berkus
  - Re: Limiting database size, Eric
    - Re: Limiting database size, Josh Berkus
    - Re: Limiting database size, terry
    - Re: Limiting database size, Thomas Swan
- Re: Limiting database size, Jeff Boes
- Re: Limiting database size, Ulrich Sprick
- Re: Limiting database size, Tulio Oliveira
select failure, Ian Cass
- Re: select failure, Gunther Schadow
  - Re: select failure, Ian Cass
    - Re: select failure, Gunther Schadow
    - Re: select failure, Ian Cass
- Re: select failure, Tom Lane
arrays as pgsql function parameters, Joseph Syjuco
- Re: arrays as pgsql function parameters, Achilleus Mantzios
  - Re: arrays as pgsql function parameters, Joseph Syjuco
    - Re: arrays as pgsql function parameters, Achilleus Mantzios
    - Re: arrays as pgsql function parameters, Josh Berkus
    - Re: arrays as pgsql function parameters, Joseph Syjuco
    - VIEWs and FOREIGN keys, Achilleus Mantzios
    - Re: VIEWs and FOREIGN keys, Stephan Szabo
    - Re: VIEWs and FOREIGN keys, Jan Wieck
    - Re: [GENERAL] VIEWs and FOREIGN keys, terry
UPDATE ... FROM vs standard SQL, Richard Huxton
- Re: UPDATE ... FROM vs standard SQL, Jan Wieck
- Re: UPDATE ... FROM vs standard SQL, Josh Berkus
  - Re: UPDATE ... FROM vs standard SQL, Richard Huxton
    - Re: UPDATE ... FROM vs standard SQL, Josh Berkus
- Re: UPDATE ... FROM vs standard SQL, Stephan Szabo
Re: PL/pgSQL TODO, Bruce Momjian
- Re: PL/pgSQL TODO, Josh Berkus
  - Re: PL/pgSQL TODO, Bruce Momjian
    - Re: PL/pgSQL TODO, Josh Berkus
    - Re: PL/pgSQL TODO, Bruce Momjian
- Re: PL/pgSQL TODO, Josh Berkus
  - Re: PL/pgSQL TODO, Jan Wieck
    - Re: PL/pgSQL TODO, Bruce Momjian
Old documentation, Wei Weng
- Re: Old documentation, Manfred Koizar
TWO PROBLEMS, Ricardo Javier Aranibar León
how to reset serials, Joseph Syjuco
- Re: how to reset serials, Bruno Wolff III
  - Re: how to reset serials, Joseph Syjuco
Indexing timestamps, Andre Schubert
- Re: Indexing timestamps, Josh Berkus
  - Re: Indexing timestamps, Stephan Szabo
    - Re: Indexing timestamps, Josh Berkus
    - Re: Indexing timestamps, Stephan Szabo
    - Re: Indexing timestamps, Bruce Momjian
    - Re: Indexing timestamps, Stephan Szabo
simple select statement inquiry, Joseph Syjuco
- Re: simple select statement inquiry, Ludwig Lim
  - Re: simple select statement inquiry, Joel Burton
Getting PID of current logged user, Roberto Mello
extract and variables in PL/pgSQL, Roberto Mello
- Re: extract and variables in PL/pgSQL, Jan Wieck
  - Re: extract and variables in PL/pgSQL, Roberto Mello
Indexing Metaphone?, Josh Berkus
- Re: Indexing Metaphone?, Richard Poole
  - Re: Indexing Metaphone?, Josh Berkus
- Re: Indexing Metaphone?, Stephan Szabo
Re: Further info : Very high load average but no cpu utilization, Bruce Momjian
- Re: PostgreSQL on AIX, D'Arcy J.M. Cain
  - Re: PostgreSQL on AIX, Travis Hoyt
  - Re: PostgreSQL on AIX, Bruce Momjian
Postgres Function Proble, Sandeep Chibber
alter column - NOT NULL, Tom Haddon
Some problems with (my?) PlSQL, Rui Pacheco
- Re: Some problems with (my?) PlSQL, Stephan Szabo
  - Re: Some problems with (my?) PlSQL, Rui Pacheco
Updating a table from another table, Matthew Price
- Re: Updating a table from another table, Jean-Luc Lachance
Is this a feature ?, David BOURIAUD
- Re: Is this a feature ?, Achilleus Mantzios
- Re: Is this a feature ?, Jan Wieck
- Re: Is this a feature ?, Nick Fankhauser
  - Re: Is this a feature ?, David BOURIAUD
- Re: Is this a feature ?, Joel Burton
- Re: Is this a feature ?, James Orr
Postgres Function Problem, Sandeep Chibber
- Re: Postgres Function Problem, Achilleus Mantzios
  - new itoar function, Achilleus Mantzios
    - Re: new itoar function, Oleg Bartunov
passing a list to a function and returning a recordset, Marie G. Tuite
- Re: passing a list to a function and returning a recordset, Marie G. Tuite
- passing a list to a function and returning a recordset, Marie G. Tuite
How to update, Andre Schubert
- Re: How to update, Manfred Koizar
  - Re: How to update, Andre Schubert
Re: Syntax error in plpgsql crashes backend, Bruce Momjian
- Re: Syntax error in plpgsql crashes backend, Joseph D. Barillari
to_date(), Paul
- Re: to_date(), Kaare Rasmussen
alternate idioms for large "IN (...)" lists, russm
- Re: alternate idioms for large "IN (...)" lists, Christopher Kings-Lynne
  - Re: alternate idioms for large "IN (...)" lists, russm
    - Re: alternate idioms for large "IN (...)" lists, Tom Lane
Postgres Function Call Problem, Sandeep Chibber
Problem with the result set of postgres, Sandeep Chibber
Fw: Postgres function call problems, Sandeep Chibber
Any way to handle exceptions in PL/pgSQL ?, Jorg Janke
- Re: Any way to handle exceptions in PL/pgSQL ?, PG Explorer
problem with sql, Ricardo Javier Aranibar León
- Re: problem with sql, D'Arcy J.M. Cain