Mailing lists [pgsql-sql]
- defaults on updates Martin Marques
- Re: defaults on updates Tom Lane
- Re: connectby George Essig
- Re: conditional query?
- pgAdmin Ganesan Kanavathy
- Re: [ADMIN] pgAdmin Ganesan Kanavathy
- Re: A tricky sql-query... Mark Stosberg
- Re: A tricky sql-query... Rod Taylor
- Re: A tricky sql-query... Christopher Browne
- pg_dump error - Permission denied Kumar
- 'invalid' value in timestamp with timezone. Stef
- Re: Help on update that subselects other records in table, uses joins Jeff Kowalczyk
- Re: create type input and output function examples Christoph Haller
- query assistance Jodi Kanter
- Re: Using UNION inside a cursor Paul Ganainm
- Re: query assistance Richard Huxton
- Please help me to slove this SQL statements Freshman
- Re: connectby Benoît BOURNON
- Re: Error message during compressed backup Senthil Kumar S
- Problems with NEW.* in triggers Jamie Lawrence
- Re: Problems with NEW.* in triggers Tom Lane
- Re: Problems with NEW.* in triggers Josh Berkus
- Re: Problems with NEW.* in triggers Jamie Lawrence
- Re: Problems with NEW.* in triggers Tom Lane
- Re: query assistance Michael Glaesemann
- UNSUBSCRIBE Atul Pedgaonkar
- Re: Please help me to slove this SQL statements Patrick JACQUOT (DSI NOISIEL)
- Select and functions Stephen J. Thompson
- Re: Select and functions
- Re: Select and functions Jeff Eckermann
- avoid circular references Jerome Alet
- Re: [HACKERS] Schema boggle... Josh Berkus
- Re: avoid circular references Josh Berkus
- Re: avoid circular references Jerome Alet
- Now() in a function sTesting
- Re: Now() in a function Gaetano Mendola
- search facilities Martin Kuria
- DateDiff in PostgreSQL George A.J
- Re: DateDiff in PostgreSQL Yasir Malik
- Re: DateDiff in PostgreSQL Tomasz Myrta
- Re: DateDiff in PostgreSQL George A.J
- Re: DateDiff in PostgreSQL Rod Taylor
- Re: SQL to PLC to diverter gate, can this be done? Christopher Browne
- ... ronald@my.msuiit.edu.ph
- ... ronald@my.msuiit.edu.ph
- query problem ron_tabada
- Re: search facilities Oleg Bartunov
- Re: search facilities George Essig
- off subject - pg web hosting chester c young
- SQL to PLC to diverter gate, can this be done? razorbak71@yahoo.com (Razorbak71)
- No output while using PEAR DB & formatted time-string Marcus Krause
- Re: Problems with NEW.* in triggers Jamie Lawrence
- 7.3 : how add user when last user have lost 'createuser' option alban
- Re: No output while using PEAR DB & formatted time-string Marcus Krause
- 7.3 how remove password valid until alban
- How to know column constraints via system catalog tables so_excited@excite.com (Damon)
- Re: 7.3 how remove password valid until Bruce Momjian
- Re: 7.3 : how add user when last user have lost 'createuser' option Bruce Momjian
- Re: 7.3 : how add user when last user have lost 'createuser' option Tom Lane
- Re: off subject - pg web hosting Marc G. Fournier
- Re: off subject - pg web hosting Robert Creager
- Re: plpgsql question Josh Berkus
- Re: plpgsql question Josh Berkus
- pg 7.4.rc1, Range query performance ow
- Re: pg 7.4.rc1, Range query performance Bruce Momjian
- Re: pg 7.4.rc1, Range query performance Stephan Szabo
- transaction processing after error in statement holger@jakobs.com
- Getting the row_count value outside of a function
- Re: DateDiff in PostgreSQL Yasir Malik
- help me... ron_tabada
- transaction management in plpgsql functions Cris Carampa
- SQL Help luisblock@amauta.rcp.net.pe
- Re: [HACKERS] Schema boggle... Chris Bowlby
- Re: transaction management in plpgsql functions Christopher Browne
- Re: help me... Yasir Malik
- Re: transaction management in plpgsql functions Chester Kustarz
- Re: transaction processing after error in statement Stephan Szabo
- Re: help me... Christopher Browne
- Dynamic Query for System functions - now() Kumar
- Re: Dynamic Query for System functions - now() Christoph Haller
- FOR : Structure control pb Guillaume Houssay
- Re: Dynamic Query for System functions - now() Kumar
- Re: FOR : Structure control pb Richard Huxton
- Re: Dynamic Query for System functions - now() Achilleus Mantzios
- Re: Dynamic Query for System functions - now() Christoph Haller
- Re: help me... Yasir Malik
- Re: Dynamic Query for System functions - now() George Weaver
- Re: Dynamic Query for System functions - now() Stephan Szabo
- Re: transaction processing after error in statement Stephan Szabo
- Re: Louise Cofield
- Re: transaction processing after error in statement Holger Jakobs
- Re: help me... Yasir Malik
- FOR : control structure Guillaume Houssay
- Re: transaction processing after error in statement Jan Wieck
- Re: transaction processing after error in statement Rod Taylor
- Re: Dynamic Query for System functions - now() Gaetano Mendola
- Re: transaction processing after error in statement Rajesh Kumar Mallah
- Re: transaction processing after error in statement Rod Taylor
- Is there a more elegant way to write this query?... Nick Fankhauser
- Re: Is there a more elegant way to write this query?... Eric Soroos
- Re: pg 7.4.rc1, Range query performance ow
- Re: pg 7.4.rc1, Range query performance ow
- Re: pg 7.4.rc1, Range query performance Bruce Momjian
- Re: pg 7.4.rc1, Range query performance Stephan Szabo
- Query Problem Abdul Wahab Dahalan
- Re: pg 7.4.rc1, Range query performance ow
- Re: Query Problem Joe Conway
- Re: pg 7.4.rc1, Range query performance Bruce Momjian
- Re: pg 7.4.rc1, Range query performance Tom Lane
- Re: pg 7.4.rc1, Range query performance Bruce Momjian
- a question to developers sad
- Re: How to know column constraints via system catalog tables Christoph Haller
- Re: pg 7.4.rc1, Range query performance ow
- curly braces to group outer joins in queries from OpenOffice.org? Palle Girgensohn
- Re: Getting the row_count value outside of a function Christoph Haller
- Re: transaction processing after error in statement Jan Wieck
- Re: curly braces to group outer joins in queries from OpenOffice.org? Tom Lane
- Re: How to know column constraints via system catalog tables Christoph Haller
- Re: curly braces to group outer joins in queries from Palle Girgensohn
- Re: curly braces to group outer joins in queries from OpenOffice.org? Tom Lane
- Re: curly braces to group outer joins in queries from Palle Girgensohn
- Re: curly braces to group outer joins in queries from OpenOffice.org? Tom Lane
- Bit strings Yasir Malik
- question to developers sad
- Re: transaction processing after error in statement Holger Jakobs
- Re: transaction processing after error in statement Holger Jakobs
- Is there a more elegant way to write this query?... Nick Fankhauser - Doxpop
- Re: 7.3 how remove password valid until alban
- Re: Is there a more elegant way to write this query?... Nick Fankhauser
- Quota query with decent performance? Troels Arvin
- Re: Quota query with decent performance? Josh Berkus
- Re: Quota query with decent performance? Chester Kustarz
- Re: Quota query with decent performance? Tom Lane
- Re: Quota query with decent performance? Troels Arvin
- Re: Quota query with decent performance? Troels Arvin
- Re: search facilities Martin Kuria
- SQL substring Guy Korland
- Re: SQL substring Franco Bruno Borghesi
- Re: SQL substring Bruno Wolff III
- SQL substring Guy Korland
- Re: How to know column constraints via system catalog tables Damon Chong
- Re: transaction processing after error in statement Jan Wieck
- Looks are important George Weaver
- Re: Looks are important Josh Berkus
- Re: Looks are important Louise Cofield
- Re: Looks are important George Weaver
- Re: Looks are important Tom Lane
- Re: curly braces to group outer joins in queries from OpenOffice.org? Tõnu Põld
- Re: How to know column constraints via system catalog tables Christoph Haller
- Conversion Problem Graham
- Re: Looks are important George Weaver
- Re: Conversion Problem Christoph Haller
- Re: Conversion Problem Richard Huxton
- Re: Looks are important Louise Cofield
- STRICT function returning a composite type Alexander M. Pravking
- Re: STRICT function returning a composite type Richard Huxton
- Re: STRICT function returning a composite type Alexander M. Pravking
- Re: STRICT function returning a composite type Tom Lane
- Re: STRICT function returning a composite type Alexander M. Pravking
- Re: STRICT function returning a composite type Tom Lane
- Re: STRICT function returning a composite type Alexander M. Pravking
- Need Help Abdul Wahab Dahalan
- Re: Need Help Bruno Wolff III
- Programatically switching database ow
- Re: Programatically switching database Peter Eisentraut
- Getting last insert value Yasir Malik
- Re: Getting last insert value Guillaume LELARGE
- Re: Programatically switching database ow
- Re: Programatically switching database Peter Eisentraut
- Re: Getting last insert value Guillaume LELARGE
- Re: Getting last insert value Greg Stark
- Re: Programatically switching database ow
- Re: Programatically switching database ow
- Re: Programatically switching database Peter Eisentraut
- Re: Programatically switching database ow
- Re: Getting last insert value Yasir Malik
- Re: Getting last insert value Theodore Petrosky
- Re: Programatically switching database ow
- Re: Programatically switching database Jan Wieck
- Re: Programatically switching database Jan Wieck
- Re: Programatically switching database ow
- schema Kenneth Gonsalves
- Re: schema Rüdiger Flotmann
- Re: Programatically switching database Tom Lane
- Re: Programatically switching database Christopher Browne
- Addition and subtraction on BIT type Yasir Malik
- WITHOUT OIDS by default ow
- Re: Addition and subtraction on BIT type Yasir Malik
- Re: WITHOUT OIDS by default Bruce Momjian
- Re: Addition and subtraction on BIT type Stephan Szabo
- Re: Programatically switching database Greg Stark
- FATAL 2: PageIndexTupleDelete cristi
- strange "not deferrable" behaviour Tomasz Myrta
- Re: Addition and subtraction on BIT type Yasir Malik
- Re: strange "not deferrable" behaviour Stephan Szabo
- Re: Addition and subtraction on BIT type Stephan Szabo
- Re: strange "not deferrable" behaviour Tomasz Myrta
- Multicolum index and primary key Michele Bendazzoli
- Re: Multicolum index and primary key Peter Eisentraut
- Re: Multicolum index and primary key Tomasz Myrta
- Re: Multicolum index and primary key Rod Taylor
- Re: Multicolum index and primary key Michele Bendazzoli
- Re: Multicolum index and primary key Michele Bendazzoli
- Re: Multicolum index and primary key Michele Bendazzoli
- COPY ritchie turner
- Re: Quota query with decent performance? Troels Arvin
- Re: FATAL 2: PageIndexTupleDelete Gaetano Mendola
- multiple function declarations Majhi, Akas
- Re: multiple function declarations Peter Eisentraut
- Re: Multicolum index and primary key Michele Bendazzoli
- Re: Quota query with decent performance? Bruno Wolff III
- Re: Quota query with decent performance? Troels Arvin
- Re: Quota query with decent performance? Troels Arvin
- Re: Quota query with decent performance? Bruno Wolff III
- Re: Quota query with decent performance? Bruno Wolff III
- Re: Quota query with decent performance? Troels Arvin
- Need query to separate rows by one field's value Jeff Boes
- Re: Addition and subtraction on BIT type Yasir Malik
- Function ROWTYPE Parameter with NEW/OLD Andrew Milne
- Re: Array fields in Postgresql... Randolf Richardson, DevNet SysOp 29
- type conversion needed Kishore Thota (kthota)
- Re: HELP ME Randolf Richardson, DevNet SysOp 29
- Re: SOLVED: Emulating 'connect by prior' using stored proc Randolf Richardson, DevNet SysOp 29
- Re: Oracle 'connect by prior' now eaiser in 7.3? Randolf Richardson, DevNet SysOp 29
- Re: Closed Randolf Richardson, DevNet SysOp 29
- Re: Expressional Indexes Randolf Richardson, DevNet SysOp 29
- strange DEFERRABLE behaviour Tomek
- Arrays - a good idea? Paul Ganainm
- Re: Arrays - a good idea? Yasir Malik
- Need Help : Query problem Abdul Wahab Dahalan
- Re: SOLVED: Emulating 'connect by prior' using stored proc Merrall, Graeme
- Re: Expressional Indexes Greg Stark
- Re: Array fields in Postgresql... Achilleus Mantzios
- Re: Arrays - a good idea? Achilleus Mantzios
- Re: Need Help : Query problem Michael Glaesemann
- Re: Expressional Indexes Randolf Richardson, DevNet SysOp 29
- Addition and subtraction on BIT type Yasir Malik
- Re: Arrays - a good idea? Yasir Malik
- Re: SOLVED: Emulating 'connect by prior' using stored proc Randolf Richardson, DevNet SysOp 29
- Re: Is there a more elegant way to write this query?... Terence Kearns
- Conversion question Graham Vickrage
- Compare strings which resembles each other Gulshan Babajee
- Substrings by Regular Expression drumeng@yahoo.com (Jim Drummey)
- Re: Getting last insert value Yasir Malik
- Re: Substrings by Regular Expression Stephan Szabo
- fmgr_info: function 15238119: cache lookup failed Iain
- Re: fmgr_info: function 15238119: cache lookup failed Iain
- Re: FATAL 2: PageIndexTupleDelete Tom Lane
- current_date timezone documentation suggestion Erik Thiele
- Need another way to do this, my sql much to slow... Jerry Wintrode
- Re: Need another way to do this, my sql much to slow... Christoph Haller
- Re: Need another way to do this, my sql much to slow... Jerry Wintrode
- Re: Need another way to do this, my sql much to slow... Jerry Wintrode
- Re: FATAL 2: PageIndexTupleDelete cristi
- Re: Expressional Indexes Tom Lane
- Re: Substrings by Regular Expression Tom Lane
- Re: Need another way to do this, my sql much to slow... Christoph Haller
- Re: Compare strings which resembles each other Christoph Haller
- Re: Compare strings which resembles each other Oleg Bartunov
- cast varchar to numeric/money Yudie
- Re: cast varchar to numeric/money Bruno Wolff III
- Re: How to quote date value? Gaetano Mendola
- Re: cast varchar to numeric/money Yudie
- Re: Expressional Indexes Greg Stark
- Re: How to quote date value? Stephan Szabo
- Re: cast varchar to numeric/money Tomasz Myrta
- Re: Compare strings which resembles each other Ian Barwick
- Re: Compare strings which resembles each other Oleg Bartunov
- Character invalid saving memo with UpdateSQL Cristian Custodio
- increment int value in subset of rows? george young
- how to read bytea contents by using pgsql scripts vijaykumar M
- Re: increment int value in subset of rows? Matthew Lunnon
- Re: how to read bytea contents by using pgsql scripts Christoph Haller
- Re: how to read bytea contents by using pgsql scripts vijaykumar M
- Re: how to read bytea contents by using pgsql scripts Christoph Haller
- Re: increment int value in subset of rows? george young
- Maintaining an order for a group of records Bruno De Fraine
- Re: increment int value in subset of rows? Matthew Lunnon
- Re: increment int value in subset of rows? Chester Kustarz
- Re: how to read bytea contents by using pgsql scripts vijaykumar M
- ::text problem Kumar
- Re: ::text problem Richard Huxton
- "Permission denied" on view Michael A Nachbaur
- Re: "Permission denied" on view Tom Lane
- Re: "Permission denied" on view Michael A Nachbaur
- Re: ::text problem Kumar
- Unsigned numbers Kaloyan Iliev Iliev
- Re: Unsigned numbers Richard Huxton
- trigger conversion advice needed Clint Stotesbery
- Problem: Postgresql not starting mohan@physics.gmu.edu
- Re: trigger conversion advice needed Tom Lane
- Scaler forms as function arguments Andreas Tille
- Re: Problem: Postgresql not starting Achilleus Mantzios
- Re: trigger conversion advice needed Clint Stotesbery
- Postgres: MS Access and Tomcat mohan@physics.gmu.edu
- Re: Scaler forms as function arguments Richard Huxton
- Re: Postgres: MS Access and Tomcat Richard Huxton
- Re: Problem: Postgresql not starting Martin Knipper
- Equivalent of Reverse() functions Kumar
- Re: Equivalent of Reverse() functions Joe Conway
- Unsigned numbers Kaloyan Iliev Iliev
- Re: Scaler forms as function arguments Andreas Tille
- Re: Problem: Postgresql not starting Christoph Haller
- Validity check in to_date? Alexander M. Pravking
- Re: Scaler forms as function arguments Joe Conway
- Re: Scaler forms as function arguments Andreas Tille
- explicit joins wrong planning Tomasz Myrta
- Re: Scaler forms as function arguments Richard Huxton
- Re: Scaler forms as function arguments Joe Conway
- Re: Scaler forms as function arguments Greg Stark
- Re: explicit joins wrong planning Tom Lane
- Re: explicit joins wrong planning Tomasz Myrta
- Re: explicit joins wrong planning Tom Lane
- Re: SQL a simple menu - plz help Randolf Richardson, DevNet SysOp 29
- Re: How to quote date value? nobody
- Re: SQL a simple menu - plz help Randolf Richardson, DevNet SysOp 29
- Maintaining an order for a group of records Bruno De Fraine
- Re: How to quote date value?
- Re: Expressional Indexes Randolf Richardson, DevNet SysOp 29
- How to quote date value? nobody
- Re: How to quote date value? nobody
- OFFSET and subselects dbichko@genpathpharma.com (Dmitri Bichko)
- rules and return values question Mujdat Pakkan
- Re: SQL a simple menu - plz help Randolf Richardson
- Unsigned numbers Kaloyan Iliev Iliev
- Stored procedures and relations bilaribilari@yahoo.com (FET)
- Bug: Sequence generator insert Burr, Colin
- Do update permissions require select permissions christopher-piker@uiowa.edu (Chris Piker)
- functional index and the planner (v7.4) Roger Ging
- Re: explicit joins wrong planning Tomasz Myrta
- Re: rules and return values question Rod Taylor
- Re: Bug: Sequence generator insert Bruno Wolff III
- Re: explicit joins wrong planning Tom Lane
- Re: Do update permissions require select permissions Tom Lane
- Re: explicit joins wrong planning Tomasz Myrta
- Re: Stored procedures and relations Stephan Szabo
- Infinite loop crashes server George A.J
- Re: OFFSET and subselects Greg Stark
- Seq Scans when index expected to be used ow
- Re: Seq Scans when index expected to be used jasiek
- Re: Seq Scans when index expected to be used Tom Lane
- Re: Seq Scans when index expected to be used Joe Conway
- Re: Seq Scans when index expected to be used Stephan Szabo
- Re: Equivalent of Reverse() functions greg@turnstep.com
- Re: Seq Scans when index expected to be used ow
- Andreas Heissenberger
- Updating session id based on accesstimeout Andreas Heissenberger
- Re: Seq Scans when index expected to be used Joe Conway
- Re: Updating session id based on accesstimeout Jamie Lawrence