Mailing lists [pgsql-sql]
- converting interval to timestamp teknokrat
- length of recordset read through a cursor Knut P. Lehre
- join optimization problem Toby Tremayne
- Does a the block of code within a stored procedure constitute a transaction?
- Re: One to many query question Richard Poole
- select query that would join two databases Keith H.K. Lam (U1 Tech.)
- Re: [GENERAL] ALTER TABLE ... DROP CONSTRAINT Andrew Gould
- Re: Does a the block of code within a stored procedure constitute Rod Taylor
- Re: join optimization problem Tom Lane
- Re: join optimization problem Rod Taylor
- Re: select query that would join two databases Rod Taylor
- Using contrib/fulltext on multiple tables Eric Johnson
- Re: Does a the block of code within a stored procedure constitute a transaction?
- Re: length of recordset read through a cursor Christoph Haller
- Re: converting interval to timestamp Mike Rylander
- duplicate dates Jodi Kanter
- Re: duplicate dates Christopher Browne
- Re: Fwd: Bad Join moment - how is this happening? Jamie Lawrence
- What day is it - when it isn't NOW()? tomg@sqlclinic.net
- Re: What day is it - when it isn't NOW()? Rod Taylor
- Re: What day is it - when it isn't NOW()? Josh Berkus
- Re: What day is it - when it isn't NOW()? tomg@sqlclinic.net
- Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Robert Treat
- Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus
- Re: NEW and a subselect in a rule Denis Zaitsev
- backend cpu usage? [7.2] george young
- Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Richard Poole
- Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus
- Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian
- Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Josh Berkus
- Re: TODO item for plpgsql Was Re: obtuse plpgsql function needs Bruce Momjian
- Re: backend cpu usage? [7.2] Tom Lane
- Efficient deletions? Bertrand Petit
- Re: Efficient deletions? A.Bhuvaneswaran
- Re: join optimization problem Rod Taylor
- Re: join optimization problem Toby Tremayne
- Re: join optimization problem Toby Tremayne
- Re: join optimization problem Tom Lane
- Re: Problem with looping on a table function result Christoph Haller
- Re: [PERFORM] EXTERNAL storage and substring on long strings Scott Cain
- Re: [PERFORM] EXTERNAL storage and substring on long strings Tom Lane
- Re: [PERFORM] EXTERNAL storage and substring on long strings Richard Huxton
- Re: [PERFORM] EXTERNAL storage and substring on long strings Scott Cain
- Re: [PERFORM] EXTERNAL storage and substring on long strings Scott Cain
- Re: [PERFORM] EXTERNAL storage and substring on long strings Joe Conway
- Re: [PERFORM] EXTERNAL storage and substring on long strings Matt Clark
- Re: [PERFORM] EXTERNAL storage and substring on long strings Shridhar Daithankar
- Timestamp in PG - 7.1 & 7.2 Anagha Joshi
- Re: length of recordset read through a cursor Christoph Haller
- Re: [PERFORM] EXTERNAL storage and substring on long strings Scott Cain
- Re: [PERFORM] EXTERNAL storage and substring on long strings Scott Cain
- Re: Timestamp in PG - 7.1 & 7.2 Tom Lane
- Re: [PERFORM] EXTERNAL storage and substring on long strings Joe Conway
- JDBC encoding problem Kurt Overberg
- JDBC encoding problem Kurt Overberg
- Re: JDBC encoding problem LEON
- Re: length of recordset read through a cursor Knut P. Lehre
- Re: length of recordset read through a cursor Rod Taylor
- Using rowtype as function argument Martin Brommer
- looking for empty fields Jodi Kanter
- Re: looking for empty fields Viorel Dragomir
- Re: JDBC encoding problem Kurt Overberg
- Re: looking for empty fields Jodi Kanter
- Re: Using rowtype as function argument Tom Lane
- Analyze makes queries slow... Stef
- Postgresql slow on XEON 2.4ghz/1gb ram Wilson A. Galafassi Jr.
- User-defined SQL function has slower query on 7.3.3 than 7.1.3 Andrew Droffner
- Re: User-defined SQL function has slower query on 7.3.3 than 7.1.3 Tom Lane
- PostgreSql under Linux Wilson A. Galafassi Jr.
- PostgreSQL and Journaled File Systems Roberto Mello
- Re: User-defined SQL function has slower query on 7.3.3 than Andrew Droffner
- Re: PostgreSQL and Journaled File Systems Tom Lane
- Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Maksim Likharev
- Books in french BenLaKnet
- (no subject) A. Van Hook
- Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Martijn van Oosterhout
- Re: (no subject) Tom Lane
- Re: [GENERAL] Postgresql slow on XEON 2.4ghz/1gb ram Robert Treat
- Abort Transaction DP PK (again) alexandre :: aldeia digital
- Testing gateway Marc G. Fournier
- [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet
- Re: duplicate dates Jonathan Gardner
- Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo
- Re: converting interval to timestamp Jonathan Gardner
- Re: Analyze makes queries slow... Jonathan Gardner
- Re: RI_ConstraintTrigger_11264756 Jonathan Gardner
- Re: Abort Transaction DP PK (again) Josh Berkus
- unexpected chunk value Eric Anderson Vianet SAO
- Re: Analyze makes queries slow... Stef
- Re: Abort Transaction DP PK (again) alexandre :: aldeia digital
- Re: Abort Transaction DP PK (again) Josh Berkus
- Comparing arrays Bertrand Petit
- How to check: is some key referenced from sometable evl@my-mail.com.ua
- Error message with a SQL function proghome@silesky.com (krystoffff)
- Re: Retrieving tuple data on insert Prasanth
- Re: Error message with a SQL function Tom Lane
- Re: How to check: is some key referenced from sometable Bruno Wolff III
- Re: Comparing arrays Tom Lane
- Re: Comparing arrays Joe Conway
- Re: How to check: is some key referenced from sometable eVl One
- Re: How to check: is some key referenced from sometable Stephan Szabo
- OFF-TOPIC: Richard Huxton, Please Contact Us! Josh Berkus
- Re: Retrieving tuple data on insert sebmil
- Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet
- Re: Comparing arrays Bertrand Petit
- sub-sel/group problem Gary Stainburn
- Re: sub-sel/group problem Gary Stainburn
- Re: sub-sel/group problem Christoph Haller
- update system table? Eric Anderson Vianet SAO
- Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo
- Re: sub-sel/group problem Stephan Szabo
- Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 BenLaKnet
- Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Stephan Szabo
- Re: sub-sel/group problem Tomasz Myrta
- Query suddenly taking longer.... Kurt Overberg
- Re: Query suddenly taking longer.... Tom Lane
- possible? Fejes Jozsef
- Re: Query suddenly taking longer.... Kurt Overberg
- Re: possible? Franco Bruno Borghesi
- string function -- replace needs a clear doc Jie Liang
- Re: [ADMIN] string function -- replace needs a clear doc Stephan Szabo
- Re: string function -- replace needs a clear doc Tom Lane
- Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Benoît Bournon
- INSERT INTO ... SELECT Silke Trissl
- optimisation of a code proghome@silesky.com (krystoffff)
- Re: [pg-sql] - Problem with duplicate table (PostgreSQL 7.2.3 Benoît Bournon
- Re: INSERT INTO ... SELECT Christopher Browne
- Re: INSERT INTO ... SELECT Jonathan Gardner
- Re: optimisation of a code Jonathan Gardner
- Re: How to check: is some key referenced from sometable Jonathan Gardner
- Re: INSERT INTO ... SELECT Vernon Smith
- How to optimize this query ? proghome@silesky.com (krystoffff)
- Re: How to optimize this query ? Stephan Szabo
- Re: How to optimize this query ? Franco Bruno Borghesi
- Re: How to optimize this query ? Stephan Szabo
- How to speeed up the query performance Abdul Wahab Dahalan
- Order of triggers - totally lost SZŰCS Gábor
- Re: INSERT INTO ... SELECT Christoph Haller
- Insert a description while creating a table luiz@klais.com.br
- Re: Insert a description while creating a table Rod Taylor
- Re: Insert a description while creating a table BenLaKnet
- Re: Insert a description while creating a table Christoph Haller
- Re: Insert a description while creating a table luiz@klais.com.br
- Re: Insert a description while creating a table Reinoud van Leeuwen
- Re: Insert a description while creating a table Christoph Haller
- Re: Order of triggers - totally lost Christoph Haller
- Re: How to speeed up the query performance Christoph Haller
- Re: How to speeed up the query performance Jonathan Gardner
- Re: Order of triggers - totally lost Jonathan Gardner
- Re: Order of triggers - totally lost SZŰCS Gábor
- Re: Order of triggers - totally lost Josh Berkus
- Re: Order of triggers - totally lost SZŰCS Gábor
- Re: How to optimize this query ? Franco Bruno Borghesi
- Re: Order of triggers - totally lost Jonathan Gardner
- Changing data type must recreate all views? Yudie
- Re: How to optimize this query ? Stephan Szabo
- Re: INSERT INTO ... SELECT Vernon Smith
- Re: Order of triggers - totally lost Josh Berkus
- Re: Order of triggers - totally lost SZŰCS Gábor
- Re: How to optimize this query ? Stephan Szabo
- Re: How to optimize this query ? Stephan Szabo
- Re: How to optimize this query ? proghome@silesky.com (krystoffff)
- Re: How to optimize this query ? ProgHome
- Re: How to optimize this query ? ProgHome
- Re: Insert a description while creating a table Benoît Bournon
- Why table has drop, but the foreign key still there? Raymond Chui
- Porting from PL/SQL to PLPGSQL Jomon Skariah
- Re: Error message with a SQL function proghome@silesky.com (krystoffff)
- Re: How to optimize this query ? proghome@silesky.com (krystoffff)
- Re: [ADMIN] Why table has drop, but the foreign key still there? Stephan Szabo
- Re: Porting from PL/SQL to PLPGSQL Josh Berkus
- Re: Porting from PL/SQL to PLPGSQL Rod Taylor
- Re: [ADMIN] Why table has drop, but the foreign key still there? Tom Lane
- Re: Why table has drop, but the foreign key still there? Rod Taylor
- Re: How to speeed up the query performance Abdul Wahab Dahalan
- Re: How to speeed up the query performance Stephan Szabo
- Timezone troubles Jesse Scott
- Re: How to speeed up the query performance Abdul Wahab Dahalan
- Re: How to speeed up the query performance Abdul Wahab Dahalan
- Re: Timezone troubles Josh Berkus
- Re: Timezone troubles Jesse Scott
- Re: Timezone troubles Jesse Scott
- independent sequence for each month Tomasz Myrta
- Re: Timezone troubles Tom Lane
- Re: Timezone troubles Tom Lane
- Re: independent sequence for each month Bruno Wolff III
- Re: Changing data type must recreate all views? Christoph Haller
- Re: [PERFORM] EXTERNAL storage and substring on long strings Jan Wieck
- Re: [PERFORM] EXTERNAL storage and substring on long strings Tom Lane
- Re: [PERFORM] EXTERNAL storage and substring on long strings Scott Cain
- Re: [PERFORM] EXTERNAL storage and substring on long strings Jan Wieck
- lower/upper functions and strings in searches Gregory S. Williamson
- Re: lower/upper functions and strings in searches Stephan Szabo
- Re: lower/upper functions and strings in searches Josh Berkus
- Porting from PL/SQL to PLPGSQL Jomon Skariah
- Re: How to optimize this query ? proghome@silesky.com (krystoffff)
- Optional join Slawek Jarosz
- Re: Porting from PL/SQL to PLPGSQL Jomon Skariah
- Re: Optional join Bruno Wolff III
- Re: Optional join Stephan Szabo
- sequence cristi
- Re: sequence Dennis Björklund
- Re: sequence Bertrand Petit
- Re: sequence Tom Lane
- Re: About primary keys. Tim Andersen
- Re: About primary keys. Tom Lane
- Re: About primary keys. Tim Andersen
- Re: About primary keys -- made some progress Tim Andersen
- Re: How to optimize this query ? ProgHome
- Re: Optional join David Fetter
- [Newbie] migrating a stored procedure from MSSQL to postgresql Bengali
- Re: About primary keys -- made some progress Tom Lane
- Re: Optional join Ian Barwick
- Do it exist? Hal Davison
- Re: Do it exist? Rod Taylor
- Expression transformation curiosity Richard Huxton
- Re: Expression transformation curiosity Tom Lane
- Re: Expression transformation curiosity Alexander M. Pravking
- Re: Expression transformation curiosity Richard Huxton
- Reverse pattern match. Moonstruck
- Re: Reverse pattern match. Rod Taylor
- Re: Reverse pattern match. Josh Berkus
- Inheritance or no inheritance, there is a question Vernon Smith
- Re: Inheritance or no inheritance, there is a question Josh Berkus
- Re: Changing data type must recreate all views? Peter Eisentraut
- postgres 7.1.3: why does the query plan ignore indexes? Marco Vezzoli
- Migration from db2 to postgres' shyamperi@davlin.co.in
- Re: Migration from db2 to postgres' Tim Andersen
- Query problem Rado Petrik
- Re: postgres 7.1.3: why does the query plan ignore indexes? Tom Lane
- Re: postgres 7.1.3: why does the query plan ignore indexes? Marco Vezzoli
- Re: Query problem Richard Huxton
- Re: Query problem Bruno Wolff III
- Re: Inheritance or no inheritance, there is a question Josh Berkus
- Re: Wicked screensaver
- Re: Wicked screensaver
- Re: Approved
- "SELECT IN" Still Broken in 7.4b Mike Winter
- Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo
- Re: "SELECT IN" Still Broken in 7.4b Mike Winter
- Re: "SELECT IN" Still Broken in 7.4b Rod Taylor
- Re: "SELECT IN" Still Broken in 7.4b Rod Taylor
- Before/After Trigger User Switching Aasmund Midttun Godal
- Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo
- Re: "SELECT IN" Still Broken in 7.4b Mike Winter
- Re: "SELECT IN" Still Broken in 7.4b Joe Conway
- Re: Before/After Trigger User Switching Aasmund Midttun Godal
- Re: Inheritance or no inheritance, there is a question David Fetter
- Table conversion query... George McQuade
- Porting from PL/SQL to PLPGSQL Jomon Skariah
- Re: Before/After Trigger User Switching Tom Lane
- Re: Reverse pattern match. Moonstruck
- Re: Table conversion query... Joe Conway
- Re: "SELECT IN" Still Broken in 7.4b Tom Lane
- Re: Before/After Trigger User Switching Aasmund Midttun Godal
- Re: "SELECT IN" Still Broken in 7.4b Rod Taylor
- Re: Porting from PL/SQL to PLPGSQL Roberto Mello
- Configuring Problem on Solaris............ Chidananda
- link toward pgsql-sql is missing on the left menu at http://archives.postgresql.org/ Richard NAGY
- Re: Before/After Trigger User Switching Tom Lane
- Re: Configuring Problem on Solaris............ Peter Eisentraut
- problem with automatic altering of groups Matthias Nagl
- problem with automatic altering of groups Matthias Nagl
- Re: Configuring Problem on Solaris............ LAIN Lucas TECHTEL
- Re: problem with automatic altering of groups Josh Berkus
- Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo
- Re: Table conversion query... George McQuade
- Re: [Newbie] migrating a stored procedure from MSSQL to postgresql Richard Hall
- Re: Table conversion query... Joe Conway
- URGENT : free result (libpq++ API) Anagha Joshi
- Re: [ADMIN] URGENT : free result (libpq++ API) Stephan Szabo
- Re: "SELECT IN" Still Broken in 7.4b Oleg Bartunov
- Re: "SELECT IN" Still Broken in 7.4b Dani Oderbolz
- Re: "SELECT IN" Still Broken in 7.4b Stephan Szabo
- logging messages from inside pgPLSQL routine? Drew Wilson
- Re: logging messages from inside pgPLSQL routine? Roberto Mello
- date calculation MichaelHoeller@t-online.de
- Re: "SELECT IN" Still Broken in 7.4b Bertrand Petit
- Re: date calculation Tomasz Myrta
- Joined deletes but one table being a subquery. Rajesh Kumar Mallah
- Re: Joined deletes but one table being a subquery. Tomasz Myrta
- Bug on parameter bigint in PL/PGSQL Michele Bendazzoli
- Re: "SELECT IN" Still Broken in 7.4b Rod Taylor
- Re: "SELECT IN" Still Broken in 7.4b Tom Lane
- Re: date calculation Tom Lane
- Re: Bug on parameter bigint in PL/PGSQL Stephan Szabo
- Re: Bug on parameter bigint in PL/PGSQL Richard Huxton
- Re: "SELECT IN" Still Broken in 7.4b Bertrand Petit
- Re: Bug on parameter bigint in PL/PGSQL Michele Bendazzoli
- composite type in a table
- Delete denied? Josh Berkus
- Re: Delete denied? Josh Berkus
- Re: Delete denied? Tom Lane
- Re: Delete denied? Stephan Szabo
- Auto-update a field when record is changed Stuart
- Re: Auto-update a field when record is changed Stephan Szabo
- Re: Joined deletes but one table being a subquery. Rajesh Kumar Mallah
- Re: Delete denied? Jeff Eckermann
- Equality operators on NULL values Bertrand Petit
- Re: Equality operators on NULL values Peter Eisentraut
- Re: Auto-update a field when record is changed Jamie Lawrence
- Re: Porting from PL/SQL to PLPGSQL denis@coralindia.com
- Re: "SELECT IN" Still Broken in 7.4b Tom Lane
- Re: Joined deletes but one table being a subquery. Tomasz Myrta
- Re: [ZODB-Dev] What are the ZopeDB limit? Michele Bendazzoli
- Re: [ZODB-Dev] What are the ZopeDB limit? Michele Bendazzoli
- Strange behavior with timestamptz George Weaver
- How to join from two tables at once? Joseph Shraibman
- Re: How to join from two tables at once? Ian Barwick
- Re: postgres 7.1.3: why does the query plan ignore indexes? Bruce Momjian
- Re: How to join from two tables at once? Stephan Szabo
- Re: Strange behavior with timestamptz George Weaver
- Re: Strange behavior with timestamptz Tom Lane
- Re: [ZODB-Dev] What are the ZopeDB limit? BenLaKnet
- Re: [ZODB-Dev] What are the ZopeDB limit? Michele Bendazzoli
- One-2-many relation - need distinct counts PS PS
- Re: postgres 7.1.3: why does the query plan ignore indexes? Tom Lane
- Re: Strange behavior with timestamptz Tom Lane
- Re: Strange behavior with timestamptz George Weaver
- Eliminating duplicate lists Richard Huxton
- Restore deleted records Konstantin Petrenko
- Fetch the required rows shyamperi@davlin.co.in
- Re: Fetch the required rows Bruno Wolff III
- regarding the same in db2 - fetch tuples shyamperi@davlin.co.in
- Fetch the required rows shyamperi@davlin.co.in
- Re: Restore deleted records CoL
- Re: postgres 7.1.3: why does the query plan ignore indexes? Tom Lane
- How to return a record set from function. Kumar
- Re: postgres 7.1.3: why does the query plan ignore indexes? Bruce Momjian
- Canceling other backend's query daq
- Re: One-2-many relation - need distinct counts Richard Huxton
- length of array Chris Faulkner
- Re: How to return a record set from function. Joe Conway
- Re: How to optimize this query ? Stephan Szabo
- Re: length of array Joe Conway
- Re: Canceling other backend's query scott.marlowe
- Re: How to return a record set from function. Stephan Szabo
- Re: Canceling other backend's query Bruce Momjian
- Re: How to return a record set from function. Richard Huxton
- script to create a sample database Popeanga Marian
- Re: Restore deleted records Bruno Wolff III
- [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Marco Vezzoli
- Re: postgres 7.1.3: why does the query plan ignore indexes? Gaetano Mendola
- smallfloat with postgresql Alessandro Depetro
- smallint with postgresql Alessandro Depetro
- smallint with postgresql Alessandro Depetro
- Re: [OT?]*_fsm_* parameters in postgresql.conf: which versions supports them? Bruno Wolff III
- Re: smallfloat with postgresql Bruno Wolff III
- Q: Multicolumn lookup, Join or Sub-query ? radevenz@ix.netcom.com (Richard A. DeVenezia)
- Re: How to optimize this query ? ProgHome
- lock row in table Daniel Michał
- Re: lock row in table Yudha Setiawan
- Re: lock row in table Daniel
- Re: lock row in table Tom Lane
- interval conversion Brett Dikeman
- Re: interval conversion Tomasz Myrta
- Re: length of array Chris Faulkner
- Re: interval conversion Brett Dikeman
- Re: length of array Joe Conway
- BEFORE UPDATE Triggers Chris Anderson
- Forcing a trigger to run Michael A Nachbaur
- Re: How to join from two tables at once? Joseph Shraibman
- Migrating Stored Procedures from MS SQL Server Kumar
- Re: Migrating Stored Procedures from MS SQL Server David Witham
- Unique constraints for a list Anuradha Ratnaweera
- Re: Unique constraints for a list Richard Huxton
- Select Match on PostgreSQL. Laurent Patureau
- Re: Select Match on PostgreSQL. Oleg Bartunov
- Re: BEFORE UPDATE Triggers Jan Wieck
- Getting the return type right for SETOF Dan Langille
- Re: Getting the return type right for SETOF Stephan Szabo
- Re: BEFORE UPDATE Triggers Tom Lane
- Re: Getting the return type right for SETOF Dan Langille