Mailing lists [pgsql-sql]
- Re: Sum() rows Mark Dilger
- Re: Sum() rows Mark Dilger
- plpgsql dynamic record access Ganesh
- Re: Sum() rows lucas@presserv.org
- Re: Sum() rows lucas@presserv.org
- View unique rowid David Klugmann
- Re: View unique rowid Rafa Couto
- Re: View unique rowid David Klugmann
- Re: View unique rowid Achilleus Mantzios
- Re: Sum() rows Bruno Wolff III
- unsubscribe Ing. Jhon Carrillo - Caracas, Venezuela
- Release feature Marx Barbosa
- Re: Release feature Jaime Casanova
- Convert int to hex Fernando Grijalba
- index row size 2728 exceeds btree maximum, 2713 Dinesh Pandey
- Re: Convert int to hex Richard Huxton
- Re: index row size 2728 exceeds btree maximum, 2713 Dinesh Pandey
- Re: [GENERAL] index row size 2728 exceeds btree maximum, 2713 Richard Huxton
- Re: Convert int to hex Fernando Grijalba
- Re: [GENERAL] index row size 2728 exceeds btree maximum, 2713 Dinesh Pandey
- Re: [GENERAL] index row size 2728 exceeds btree maximum, 2713 Richard Huxton
- Re: [GENERAL] index row size 2728 exceeds btree maximum, 27 KÖPFERL Robert
- Re: index row size 2728 exceeds btree maximum, 2713 Dinesh Pandey
- Re: [GENERAL] index row size 2728 exceeds btree maximum, 27 Bruno Wolff III
- Re: index row size 2728 exceeds btree maximum, 2713 Bruno Wolff III
- Re: [GENERAL] index row size 2728 exceeds btree maximum, 27 Richard Huxton
- getting details about integrity constraint violation Markus Bertheau
- Splitting a table for performance reasons KÖPFERL Robert
- Re: [GENERAL] index row size 2728 exceeds btree maximum, 27 Jaime Casanova
- Re: getting details about integrity constraint violation Tom Lane
- Re: index row size 2728 exceeds btree maximum, 27 Bruno Wolff III
- Re: index row size 2728 exceeds btree maximum, 27 Richard Huxton
- Re: index row size 2728 exceeds btree maximum, 27 Bruno Wolff III
- Re: index row size 2728 exceeds btree maximum, 27 Richard Huxton
- Re: getting details about integrity constraint violation KÖPFERL Robert
- Re: getting details about integrity constraint violation Markus Bertheau ☭
- 'true'::TEXT::BOOLEAN Markus Bertheau ☭
- Re: 'true'::TEXT::BOOLEAN Achilleus Mantzios
- Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭
- Re: 'true'::TEXT::BOOLEAN Achilleus Mantzios
- Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭
- Re: 'true'::TEXT::BOOLEAN Michael Glaesemann
- Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭
- Re: 'true'::TEXT::BOOLEAN Michael Glaesemann
- Re: 'true'::TEXT::BOOLEAN Achilleus Mantzios
- Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭
- CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END Markus Bertheau ☭
- Re: 'true'::TEXT::BOOLEAN doesn't work Markus Bertheau ☭
- Re: 'true'::TEXT::BOOLEAN Tom Lane
- Re: CASE WHEN foo IS NULL THEN DEFAULT ELSE foo END Tom Lane
- using a selected row as a function parameter Ami Ganguli
- Re: 'true'::TEXT::BOOLEAN Bruno Wolff III
- Re: using a selected row as a function parameter Tom Lane
- Re: using a selected row as a function parameter Michael Fuhr
- Re: 'true'::TEXT::BOOLEAN Tom Lane
- Re: 'true'::TEXT::BOOLEAN Markus Bertheau ☭
- Re: 'true'::TEXT::BOOLEAN Bruno Wolff III
- Re: getting details about integrity constraint violation PFC
- Tsearch2 headline usage Rajesh Kumar Mallah
- Re: Multiple SRF parameters from query Federico Pedemonte
- Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Bruce Momjian
- Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Joe Conway
- Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Bruce Momjian
- Re: Multiple SRF parameters from query Michael Fuhr
- Re: Convert int to hex Ramakrishnan Muralidharan
- Re: index row size 2728 exceeds btree maximum, 2713 Ramakrishnan Muralidharan
- Re: [GENERAL] index row size 2728 exceeds btree maximum, 2713 Martijn van Oosterhout
- Re: index row size 2728 exceeds btree maximum, 2713 Ramakrishnan Muralidharan
- plpgsql and triggers Bart Degryse
- Returning a Cross Tab record set from a function Marc Wrubleski
- How do write a query... Alain Reymond
- Unique keys on views
- Re: Multiple SRF parameters from query Ramakrishnan Muralidharan
- Re: plpgsql and triggers Michael Fuhr
- Re: How do write a query... KÖPFERL Robert
- how to store more than 3 MB of character data in Postgres Varchar field Vadivel Subramaniam
- Re: Returning a Cross Tab record set from a function KÖPFERL Robert
- Re: how to store more than 3 MB of character data in Postgres Richard Huxton
- Re: how to store more than 3 MB of character data in Postgres Richard Huxton
- Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Markus Bertheau ☭
- What is faster? ON.KG
- Re: how to store more than 3 MB of character data in Postgres Varchar field Tom Lane
- Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Tom Lane
- Re: What is faster? Richard Huxton
- Re: What is faster? ON.KG
- Re: ARRAY() returning NULL instead of ARRAY[] resp. {} Joe Conway
- Re: What is faster? Richard Huxton
- Re: How do write a query... Bruno Wolff III
- SQL equivalent to nested loop Markus Bertheau ☭
- Re: SQL equivalent to nested loop KÖPFERL Robert
- Re: SQL equivalent to nested loop Markus Bertheau
- Re: What is faster? ON.KG
- preventing deletion of a row Kenneth Gonsalves
- datestyle syntax Kenneth Gonsalves
- Re: preventing deletion of a row Nick Johnson
- large object support in PostGres 7.4 Vadivel Subramaniam
- Re: large object support in PostGres 7.4 Volkan YAZICI
- Re: preventing deletion of a row Kenneth Gonsalves
- Re: What is faster? Achilleus Mantzios
- to listadmin Kenneth Gonsalves
- Re: to listadmin Richard Huxton
- Re: to listadmin Kenneth Gonsalves
- Re: to listadmin Achilleus Mantzios
- Re: SQL equivalent to nested loop KÖPFERL Robert
- Can we stop that? KÖPFERL Robert
- rule or trigger? M.D.G. Lange
- Re: rule or trigger? Stephan Szabo
- Re: to listadmin Tom Lane
- Re: rule or trigger? Richard Huxton
- Re: to listadmin Bruno Wolff III
- Experience with splitting a Table transparently KÖPFERL Robert
- Cursor need it? Lucas Hernndez
- Re: How do write a query... Bruno Wolff III
- Re: Cursor need it? KÖPFERL Robert
- access to new/old in dynamic sql for audit table Jay Parker
- Re: access to new/old in dynamic sql for audit table Tom Lane
- Re: plpgsql dynamic record access Rajesh Kumar Mallah
- Rule David Hofmann
- Re: Rule Bruno Wolff III
- Re: Rule David Hofmann
- SELECT very slow Thomas Kellerer
- Re: Rule Keith Worthington
- [Fwd: RE: Re: Rule] Keith Worthington
- Re: SELECT very slow Tom Lane
- Re: SELECT very slow Alain
- Indices and user defined operators Dmitri Bichko
- Re: Indices and user defined operators Tom Lane
- Re: Indices and user defined operators Tom Lane
- Re: SELECT very slow Thomas Kellerer
- rejecting characters in a field Kenneth Gonsalves
- Re: rejecting characters in a field Gnanavel Shanmugam
- Re: [despammed] rejecting characters in a field Andreas Kretschmer
- Re: [despammed] rejecting characters in a field Michael Glaesemann
- Re: Indices and user defined operators Richard Huxton
- Re: SELECT very slow Volkan YAZICI
- Re: SELECT very slow Thomas Kellerer
- Re: [despammed] rejecting characters in a field Bruno Wolff III
- Re: [despammed] rejecting characters in a field Andreas Kretschmer
- Re: SELECT very slow Thomas Kellerer
- Permission denied for language pltclu Dinesh Pandey
- Re: Permission denied for language pltclu Michael Glaesemann
- Re: Permission denied for language pltclu Dinesh Pandey
- Re: Permission denied for language pltclu Richard Huxton
- Re: Permission denied for language pltclu Dinesh Pandey
- Re: Permission denied for language pltclu Michael Glaesemann
- Re: Permission denied for language pltclu Richard Huxton
- Re: Permission denied for language pltclu Dinesh Pandey
- Re: [GENERAL] Permission denied for language pltclu Dinesh Pandey
- How-to suggestions to views KÖPFERL Robert
- Re: [GENERAL] Permission denied for language pltclu Richard Huxton
- Re: [GENERAL] Permission denied for language pltclu Michael Glaesemann
- Re: [GENERAL] Permission denied for language pltclu Michael Glaesemann
- Re: [GENERAL] Permission denied for language pltclu Dinesh Pandey
- Re: [GENERAL] Permission denied for language pltclu Richard Huxton
- Re: How do write a query... Mischa Sandberg
- predicate locking Daniel Roth
- Re: predicate locking Tom Lane
- Re: predicate locking Daniel Roth
- Re: predicate locking Tom Lane
- Re: Aggregate Functions Template postgres@jal.org
- Re: getting details about integrity constraint violation Greg Sabino Mullane
- Spam Re: read it immediately alessio@albourne.com
- Re: getting details about integrity constraint violation Markus Bertheau
- foreign key on pg_shadow M.D.G. Lange
- Re: SELECT very slow PFC
- Re: foreign key on pg_shadow Tom Lane
- Re: getting details about integrity constraint violation Greg Sabino Mullane
- update syntax Praveen Raja
- Converting varchar to bool KÖPFERL Robert
- Re: update syntax Bruno Prévost
- Re: update syntax Praveen Raja
- Re: update syntax Bruno Prévost
- Re: Converting varchar to bool Bruno Wolff III
- Re: update syntax Bruno Wolff III
- Re: SELECT very slow Thomas Kellerer
- Re: SELECT very slow PFC
- Re: SELECT very slow Thomas Kellerer
-
cursor "
" does not exist Vsevolod (Simon) Ilyushchenko
- PostgreSQL and Delphi 6 Postgres Admin
- SELECT with sum on groups ORDERING by the subtotals grupos
- Re: SELECT with sum on groups ORDERING by the subtotals Gnanavel Shanmugam
- Re: PostgreSQL and Delphi 6 Din Adrian
- funny update, say update 1, updated 1 added 2nd. Neil Dugan
- Re: PostgreSQL and Delphi 6 Postgres Admin
- Function does not return, but gives error.. M.D.G. Lange
- Re: PostgreSQL and Delphi 6 Din Adrian
- Re: Function does not return, but gives error.. Gnanavel Shanmugam
- Re: Function does not return, but gives error.. M.D.G. Lange
- Re: Function does not return, but gives error.. M.D.G. Lange
- Re: Function does not return, but gives error.. Michael Fuhr
- Re: PostgreSQL and Delphi 6 grupos
- Re: SELECT with sum on groups ORDERING by the subtotals grupos
- Re: PostgreSQL and Delphi 6 Din Adrian
- Re: SELECT with sum on groups ORDERING by the subtotals Gnanavel Shanmugam
- Re: PostgreSQL and Delphi 6 grupos
- Re: PostgreSQL and Delphi 6 Din Adrian
- Re: SELECT very slow Scott Marlowe
- Re: funny update, say update 1, updated 1 added 2nd. Jim Buttafuoco
- Re: SELECT very slow Thomas Kellerer
-
Re: cursor "
" does not exist Andrew Sullivan - Re: PostgreSQL and Delphi 6 grupos
- Re: SELECT with sum on groups ORDERING by the subtotals grupos
- Re: SELECT very slow PFC
- Re: SELECT very slow Thomas Kellerer
- Re: SELECT with sum on groups ORDERING by the subtotals Greg Sabino Mullane
- UPDATEABLE VIEWS ... Examples? Marc G. Fournier
- Re: UPDATEABLE VIEWS ... Examples? elein@varlena.com (elein)
- Re: UPDATEABLE VIEWS ... Examples? Dmitri Bichko
- Re: UPDATEABLE VIEWS ... Examples? Michael Fuhr
- Still getting autoreplies from list member Michael Fuhr
- Re: Still getting autoreplies from list member Dmitri Bichko
- Re: Still getting autoreplies from list member Kenneth Gonsalves
- Putting an INDEX on a boolean field? Marc G. Fournier
- Re: Putting an INDEX on a boolean field? David Dick
- Re: Putting an INDEX on a boolean field? Tom Lane
- Re: Putting an INDEX on a boolean field? Marc G. Fournier
- Re: Putting an INDEX on a boolean field? Jaime Casanova
- substr or char_length problem Fatih Cerit
- Re: [despammed] substr or char_length problem Andreas Kretschmer
- Re: substr or char_length problem Michael Fuhr
- how can i UPDATE without dead rows csepinek@freemail.hu
- Re: UPDATEABLE VIEWS ... Examples? Bricklen Anderson
- Re: how can i UPDATE without dead rows Richard Huxton
- Re: SELECT with sum on groups ORDERING by the subtotals grupos
- partial index on non default tablespace syntax Rajesh Kumar Mallah
- Re: partial index on non default tablespace syntax Michael Fuhr
- Re: partial index on non default tablespace syntax Tom Lane
- Looking for info on 8.1 features, and some examples Larry Meadors
- AYUDA CON LA INSTALACION DEL POSTGRESQL Steph Frias
- Set Membership operator -- test group membership Sophie Yang
- Dynamic PL/pgSQL Ruediger Herrmann
- Re: Putting an INDEX on a boolean field? Erik Aronesty
- Re: [GENERAL] Set Membership operator -- test group membership Igor Katrayev
- Re: Returning a Cross Tab record set from a function Marc Wrubleski
- WHY transaction waits for another transaction? Vilinski Vladimir
- Re: partial index on non default tablespace syntax Rajesh Kumar Mallah
- Re: Set Membership operator -- test group membership Oleg Bartunov
- Re: Dynamic PL/pgSQL PFC
- Re: Looking for info on 8.1 features, and some examples Michael Fuhr
- Re: WHY transaction waits for another transaction? Tom Lane
- Re: WHY transaction waits for another transaction? Michael Fuhr
- Re: WHY transaction waits for another transaction? Michael Fuhr
- Re: Putting an INDEX on a boolean field? Tom Lane
- accessing database without a persistent connection mohammad izwan ibrahim
- Re: AYUDA CON LA INSTALACION DEL POSTGRESQL Nahum Castro
- Re: accessing database without a persistent connection Michael Fuhr
- Re: UPDATEABLE VIEWS ... Examples? David Pradier
- Re: UPDATEABLE VIEWS ... Examples? Jaime Casanova
- Re: UPDATEABLE VIEWS ... Examples? David Pradier
- Re: UPDATEABLE VIEWS ... Examples? Michael Glaesemann
- Re: UPDATEABLE VIEWS ... Examples? David Pradier
- FW: help with serial Luca Rasconi
- info Luca Rasconi
- Re: [despammed] info Andreas Kretschmer
- Re: info Richard Huxton
- Re: FW: help with serial Richard Huxton
- Re: UPDATEABLE VIEWS ... Examples? Din Adrian
- Re: info Theodore Petrosky
- SQL repr of bytea val Markus Bertheau ☭
- Array in plpgsql with composite type grupos
- Re: Array in plpgsql with composite type Michael Fuhr
- Re: SQL repr of bytea val Michael Fuhr
- customising serial type Kenneth Gonsalves
- Re: customising serial type Krasimir Dimitrov
- Re: customising serial type Michael Glaesemann
- Alias to a type Veikko Mäkinen
- Re: Alias to a type Achilleus Mantzios
- Re: Alias to a type Sean Davis
- Re: Alias to a type Richard Huxton
- Re: Alias to a type Bruno Wolff III
- Re: Alias to a type Achilleus Mantzios
- Re: Alias to a type Veikko Mäkinen
- Re: Alias to a type KÖPFERL Robert
- after delete trigger behavior Russell Simpkins
- Re: after delete trigger behavior Stephan Szabo
- Re: after delete trigger behavior Tom Lane
- Re: after delete trigger behavior Stephan Szabo
- Re: after delete trigger behavior Russell Simpkins
- encoding question Joel Fradkin
- Re: after delete trigger behavior Tom Lane
- Re: after delete trigger behavior Russell Simpkins
- Re: after delete trigger behavior Russell Simpkins
- optimizer, view, union Markus Bertheau
- Grouping Too Closely Thomas F. O'Connell
- Re: optimizer, view, union Tom Lane
- Re: Grouping Too Closely Russell Simpkins
- empty view, replace view, column type change? Markus Bertheau
- Re: empty view, replace view, column type change? Markus Bertheau
- Re: empty view, replace view, column type change? Rod Taylor
- Re: empty view, replace view, column type change? Markus Bertheau
- Re: empty view, replace view, column type change? Rod Taylor
- Re: empty view, replace view, column type change? Tom Lane
- Re: empty view, replace view, column type change? Bruce Momjian
- Re: empty view, replace view, column type change? Tom Lane
- Converting TBL->View complaining about indexes KÖPFERL Robert
- Re: Converting TBL->View complaining about indexes Michael Fuhr
- Default index space? Dmitri Bichko
- Re: people who buy A, also buy C, D, E Greg Sabino Mullane
- Re: Grouping Too Closely Greg Sabino Mullane
- Re: Grouping Too Closely Thomas F. O'Connell
- Re: Grouping Too Closely Greg Sabino Mullane
- Re: people who buy A, also buy C, D, E Jan Wieck
- using 'zoneinfo' to manipulate dates ... Marc G. Fournier
- Re: using 'zoneinfo' to manipulate dates ... Alvaro Herrera
- multiple PK with a non UNIQUE field davide
- Re: multiple PK with a non UNIQUE field Mathieu Arnold
- Re: multiple PK with a non UNIQUE field Jim Buttafuoco
- Re: people who buy A, also buy C, D, E PFC
- assorted problems with intarray and other GiST contribs. PFC
- Re: assorted problems with intarray and other GiST contribs. Oleg Bartunov
- Re: assorted problems with intarray and other GiST contribs. PFC
- Re: assorted problems with intarray and other GiST contribs. Michael Fuhr
- Re: multiple PK with a non UNIQUE field davide
- SELECT * FROM foo OFFSET -1 LIMIT 1 Markus Bertheau ☭
- How can I simply substatue a value in a query? Roy Souther
- pg_attribute.attlen -1 for varchar e pbchar fields jimmy.olsen
- Re: How can I simply substatue a value in a query? Sean Davis
- Re: How can I simply substatue a value in a query? Jim Buttafuoco
- Re: How can I simply substatue a value in a query? Bryan Encina
- Re: How can I simply substatue a value in a query? davide
- Re: SELECT * FROM foo OFFSET -1 LIMIT 1 Martín Marqués
- Re: SELECT * FROM foo OFFSET -1 LIMIT 1 Markus Bertheau
- Re: SELECT * FROM foo OFFSET -1 LIMIT 1 Greg Stark
- Re: pg_attribute.attlen -1 for varchar e pbchar fields Michael Fuhr
- ORDER records based on parameters in IN clause Riya Verghese
- Help with query, stuck :( bumby
- Unique primary index? orange_crush_068@hotmail.com
- cross-table reference Mukesh Ghatiya
- SELECT INTO returning more than one row Zac
- Re: customising serial type Stefan Becker
- ENUM like data type MRB
- Re: scroll cursor bug or me? Sim Zacks
- Re: ORDER records based on parameters in IN clause Michael Fuhr
- Re: Unique primary index? M.D.G. Lange
- Re: ENUM like data type Kenneth Gonsalves
- Re: ENUM like data type Mike Rylander
- ERROR: "TZ"/"tz" not supported Sergey Levchenko
- Re: ENUM like data type Bruno Wolff III
- Re: cross-table reference Bruno Wolff III
- Re: Unique primary index? Bruno Wolff III
- Re: Unique primary index? PFC
- Re: ENUM like data type PFC
- Re: ENUM like data type Martín Marqués
- Re: Unique primary index? Scott Marlowe
- Re: ENUM like data type Scott Marlowe
- Re: ENUM like data type Nick Johnson
- Re: people who buy A, also buy C, D, E Greg Sabino Mullane
- Re: ORDER records based on parameters in IN clause Greg Sabino Mullane
- Re: ENUM like data type Dawid Kuroczko
- Re: ORDER records based on parameters in IN clause Russell Simpkins
- Re: ORDER records based on parameters in IN clause Dawid Kuroczko
- Re: ORDER records based on parameters in IN clause Michael Fuhr
- Re: ORDER records based on parameters in IN clause Zac
- Re: ORDER records based on parameters in IN clause Zac
- Re: ENUM like data type KÖPFERL Robert
- Insert rule and default values for PK KÖPFERL Robert
- Re: ENUM like data type Martín Marqués
- Re: cross-table reference Bruno Wolff III
- Re: ENUM like data type Rod Taylor
- Re: ORDER records based on parameters in IN clause Russell Simpkins
- Re: ORDER records based on parameters in IN clause Michael Fuhr
- Re: ORDER records based on parameters in IN clause Scott Marlowe
- Re: ENUM like data type Peter Eisentraut
- Re: ENUM like data type Tom Lane
- Error saving image to PostgresSQL 8.x database Fred Cunningham
- Foreign key pg_dump issue and serial column type Vsevolod (Simon) Ilyushchenko
- Re: Foreign key pg_dump issue and serial column type Tom Lane
- Re: Error saving image to PostgresSQL 8.x database Josh Berkus
- Re: ORDER records based on parameters in IN clause M.D.G. Lange
- Re: ORDER records based on parameters in IN clause Dawid Kuroczko
- Re: ENUM like data type KÖPFERL Robert
- SQL Query question Nick Stone
- Re: ORDER records based on parameters in IN clause Greg Sabino Mullane
- Re: ENUM like data type Peter Eisentraut
- Re: SQL Query question Peter Eisentraut
- Re: SQL Query question Richard Huxton
- Re: ORDER records based on parameters in IN clause Daryl Richter
- Re: SQL Query question Nick Stone
- Updatable view M.D.G. Lange