Mailing lists [pgsql-sql]
- Re: combination of function to simple query makes query slow jan aerts (RI)
- Re: combination of function to simple query makes query slow Jaime Casanova
- Re: combination of function to simple query makes query slow jan aerts (RI)
- Re: combination of function to simple query makes query slow Tom Lane
- using pg_tables and tablename in queries solarsail
- Re: using pg_tables and tablename in queries Tom Lane
- Re: using pg_tables and tablename in queries solarsail
- Re: using pg_tables and tablename in queries Yasir Malik
- Re: using pg_tables and tablename in queries Jim Buttafuoco
- Re: using pg_tables and tablename in queries solarsail
- Re: using pg_tables and tablename in queries Gregory S. Williamson
- Re: Help with multistage query Jim C. Nasby
- Re: Why doesn't the SERIAL data type automatically have a Jim C. Nasby
- Re: Why doesn't the SERIAL data type automatically have a Richard Huxton
- Re: Why doesn't the SERIAL data type automatically have a Ferindo Middleton Jr
- Re: Why doesn't the SERIAL data type automatically have a Ferindo Middleton Jr
- Re: Why doesn't the SERIAL data type automatically have a Jim C. Nasby
- Re: using pg_tables and tablename in queries Jim Buttafuoco
- MOVE in SQL vs PLPGSQL andrew@pillette.com
- regular expression gurkan@resolution.com
- creating postgres tables by passing a string to function Scott cox
- Getting user created tables from SQL Cenk KIZILDAG
- query tables based on a query solarsail
- BirthDay SQL Issue brett
- Re: regular expression Gnanavel S
- Re: regular expression Michael Fuhr
- Re: MOVE in SQL vs PLPGSQL Richard Huxton
- Re: creating postgres tables by passing a string to function Richard Huxton
- Re: BirthDay SQL Issue Richard Huxton
- Re: Getting user created tables from SQL Richard Huxton
- Help with simple SQL query? Joost Kraaijeveld
- Re: Help with simple SQL query? Gregory S. Williamson
- Re: Help with simple SQL query? Frank van Vugt
- Re: Help with simple SQL query? Joost Kraaijeveld
- Re: BirthDay SQL Issue Andreas Kretschmer
- Re: MOVE in SQL vs PLPGSQL Richard Huxton
- Re: using pg_tables and tablename in queries codeWarrior
- Re: MOVE in SQL vs PLPGSQL Tom Lane
- Re: BirthDay SQL Issue Kenneth Gonsalves
- Use of partial index Leif B. Kristensen
- Re: Use of partial index Dmitri Bichko
- Re: Use of partial index Tom Lane
- Re: Use of partial index Stephan Szabo
- Re: Use of partial index Leif B. Kristensen
- Re: Use of partial index Leif B. Kristensen
- Scripting GRANT on functions Stewart Ben (RBAU/EQS4) *
- catching errors in function padmanabha konkodi
- Re: catching errors in function Eugene E.
- Noob question about types and lists xchris
- Re: Noob question about types and lists Richard Huxton
- Re: Noob question about types and lists xchris
- Re: Noob question about types and lists Richard Huxton
- Re: Scripting GRANT on functions Russell Simpkins
- Re: Scripting GRANT on functions Tom Lane
- Re: catching errors in function John DeSoi
- UNION index use help Dmitri Bichko
- Re: UNION index use help Tom Lane
- Re: UNION index use help Dmitri Bichko
- DATESTYLE and 0000-00-00 Joshua Kramer
- Re: DATESTYLE and 0000-00-00 D'Arcy J.M. Cain
- Re: DATESTYLE and 0000-00-00 Andrew Sullivan
- Re: DATESTYLE and 0000-00-00 Michael Fuhr
- Selecting records not present in related tables Hector Rosas
- Re: MOVE in SQL vs PLPGSQL Greg Stark
- Re: Selecting records not present in related tables Frank Bax
- Re: Selecting records not present in related tables Scott Marlowe
- Re: Selecting records not present in related tables Anthony Molinaro
- RULES on SELECT with JDBC/perlDBI from other RDBMS products? Bath, David
- How to delete Large Object from Database? Premsun Choltanwanich
- Re: RULES on SELECT with JDBC/perlDBI from other RDBMS products? Richard Huxton
- Re: How to delete Large Object from Database? Richard Huxton
- Re: RULES on SELECT with JDBC/perlDBI from other RDBMS Sean Davis
- Re: using pg_tables and tablename in queries solarsail
- Re: How to delete Large Object from Database? Volkan YAZICI
- convert time Simon Law
- Re: convert time Michael Fuhr
- Re: How to delete Large Object from Database? Premsun Choltanwanich
- Re: How to delete Large Object from Database? Richard Huxton
- Re: How to delete Large Object from Database? Premsun Choltanwanich
- Re: How to delete Large Object from Database? Tom Lane
- Re: How to delete Large Object from Database? Premsun Choltanwanich
- SEVEN cross joins?!?!? Frank Bax
- Re: SEVEN cross joins?!?!? Richard Huxton
- question re. count, group by, and having Rick Schumeyer
- Re: question re. count, group by, and having Sean Davis
- Difference from average Neil Saunders
- Re: question re. count, group by, and having Tom Lane
- ichar Judith Altamirano Figueroa
- Re: Difference from average Richard Huxton
- Returning NULL results? Mario Splivalo
- Re: ichar Tom Lane
- Re: Returning NULL results? Richard Huxton
- Re: ichar Richard Huxton
- Re: SEVEN cross joins?!?!? Frank Bax
- pg, mysql comparison with "group by" clause Rick Schumeyer
- Re: pg, mysql comparison with "group by" clause Scott Marlowe
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Re: question re. count, group by, and having Muralidharan Ramakrishnan
- Re: pg, mysql comparison with "group by" clause Stephan Szabo
- Re: SEVEN cross joins?!?!? Greg Patnude
- Re: Returning NULL results? Mario Splivalo
- Re: SEVEN cross joins?!?!? Richard Huxton
- Re: SEVEN cross joins?!?!? Daryl Richter
- Strange join...maybe some improvements??? Andy
- Text->Date conversion in a WHERE clause Collin Peters
- Re: regular expression Michael Fuhr
- Re: Text->Date conversion in a WHERE clause cadiolis@gmail.com
- Re: pg, mysql comparison with "group by" clause Greg Stark
- Re: regular expression Yasir Malik
- Re: Text->Date conversion in a WHERE clause Greg Stark
- Re: Text->Date conversion in a WHERE clause Tom Lane
- Re: pg, mysql comparison with "group by" clause Scott Marlowe
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Re: Text->Date conversion in a WHERE clause Tom Lane
- Update timestamp on update Jeff Williams
- Re: pg, mysql comparison with "group by" clause Greg Stark
- Re: Update timestamp on update Tom Lane
- Re: SEVEN cross joins?!?!? Frank Bax
- Re: pg, mysql comparison with "group by" clause Tom Lane
- Re: SEVEN cross joins?!?!? Stewart Ben (RBAU/EQS4) *
- Re: Update timestamp on update Jeff Williams
- Re: Update timestamp on update Tom Lane
- Re: Update timestamp on update Stewart Ben (RBAU/EQS4) *
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Re: Update timestamp on update Michael Glaesemann
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Re: pg, mysql comparison with "group by" clause Greg Stark
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Re: pg, mysql comparison with "group by" clause Greg Stark
- UPDATE Trigger on multiple tables Ferindo Middleton Jr
- Re: UPDATE Trigger on multiple tables Tom Lane
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Storing images from Delphi to postgresql NSO
- Re: SEVEN cross joins?!?!? Daryl Richter
- Re: UPDATE Trigger on multiple tables Muralidharan Ramakrishnan
- Re: pg, mysql comparison with "group by" clause Andrew Sullivan
- Re: Update timestamp on update Andrew Sullivan
- Re: pg, mysql comparison with "group by" clause Scott Marlowe
- Re: Strange join...maybe some improvements??? Thomas F. O'Connell
- Re: [DOCS] Update timestamp on update Jim C. Nasby
- Re: [DOCS] Update timestamp on update Mike Diehl
- Re: pg, mysql comparison with "group by" clause Greg Stark
- Re: Strange join...maybe some improvements??? Andy
- Re: pg, mysql comparison with "group by" clause Scott Marlowe
- Re: pg, mysql comparison with "group by" clause Andrew Sullivan
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Re: pg, mysql comparison with "group by" clause Tom Lane
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Re: pg, mysql comparison with "group by" clause Tom Lane
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- copy tables Shavonne Marietta Wijesinghe
- Re: pg, mysql comparison with "group by" clause Greg Stark
- Re: copy tables A. Kretschmer
- copy table Shavonne Marietta Wijesinghe
- Design problemi : using the same primary keys for inherited objects. David Pradier
- Re: copy table A. Kretschmer
- Re: pg, mysql comparison with "group by" clause Anthony Molinaro
- Re: Design problemi : using the same primary keys for inherited objects. Russell Simpkins
- pgOleDb Alessandro Lima
- Re: Design problem : using the same primary keys for inherited objects. David Pradier
- sql function Shavonne Marietta Wijesinghe
- Re: sql function Andreas Kretschmer
- Re: copy table Muralidharan Ramakrishnan
- Re: Design problem : using the same primary keys for inherited Daryl Richter
- Re: Design problemi : using the same primary keys for inherited objects. codeWarrior
- owner of data type "areas" appears to be invalid ? george young
- Re: Design problem : using the same primary keys for inherited objects. Russell Simpkins
- Re: owner of data type "areas" appears to be invalid ? Tom Lane
- Re: owner of data type "areas" appears to be invalid ? george young
- FULL OUTER JOIN Question Tyler Kellen
- FULL OUTER JOIN Question (mistake) Tyler Kellen
- cast Judith Altamirano Figueroa
- Re: cast Andrew Sullivan
- Re: FULL OUTER JOIN Question Tom Lane
- Re: copy tables Dau Sy Manh
- Question about functions Mike Plemmons
- Re: Question about functions Stewart Ben (RBAU/EQS4) *
- Re: Question about functions Richard Huxton
- Re: Question about functions Richard Huxton
- Re: Question about functions Richard Huxton
- Re: Design problem : using the same primary keys for inherited objects. David Pradier
- Re: Design problem : using the same primary keys for inherited objects. David Pradier
- Re: Design problemi : using the same primary keys for inherited objects. David Pradier
- Re: Design problemi : using the same primary keys for inherited Richard Huxton
- Consulta! Adriana Marcela Aguirre
- Re: Consulta! Mario Splivalo
- Re: What Am I Doing Wrong? Lane Van Ingen
- What Am I Doing Wrong? Lane Van Ingen
- Problem while using start transaction ans commit; Sri
- problems with array paperinik 100
- Re: cast Dan Feiveson
- Shavonne Marietta Wijesinghe
- Query information needed djzanky@gmail.com
- Re: generating a sequence table against which to do a LEFT OUTER JOIN david@fetter.org (David Fetter)
- Very Urgent Req for SQL-DBS In Chennai farhin
- Problem -Postgre sql Vikas J
- Double query (limit and offset) Michael Landin Hostbaek
- Re: Problem while using start transaction ans commit; Stewart Ben (RBAU/EQS4) *
- Re: Problem -Postgre sql Michael Glaesemann
- Re: Query information needed Michael Glaesemann
- Re: What Am I Doing Wrong? Michael Fuhr
- query to file Judith Altamirano Figueroa
- Re: query to file Michael Glaesemann
- Re: query to file Michael Fuhr
- Re: Problem -Postgre sql Michael Fuhr
- Re: Scott Marlowe
- Re: problems with array Matthew Peter
- Re: problems with array Michael Fuhr
- Re: Problem -Postgre sql Michael Glaesemann
- Re: query to file Eugene E.
- Re: problems with array Matthew Peter
- Re: Problem -Postgre sql Chris Travers
- Re: Double query (limit and offset) Janning Vygen
- Re: Double query (limit and offset) Richard Huxton
- Re: Query information needed Oliver Elphick
- Re: Problem while using start transaction ans commit; Oliver Elphick
- Field Separator not working? Mario Splivalo
- Re: SEVEN cross joins?!?!? Frank Bax
- Re: Field Separator not working? Richard Huxton
- Re: Field Separator not working? Mario Splivalo
- Sql - Error en ejecución de función Postgres desde cliente VFoxPro Adriana Marcela Aguirre
- Character set error Mauricio Fernandez A.
- Re: Problem -Postgre sql Muralidharan Ramakrishnan
- NULL in IN clause Havasvölgyi Ottó
- Re: NULL in IN clause Terry Fielder
- Re: NULL in IN clause David Dick
- Re: NULL in IN clause Tom Lane
- Re: NULL in IN clause Stephan Szabo
- casting character varying to integer - order by numeric sort Bryce W Nesbitt
- Re: casting character varying to integer - order by numeric Terry Fielder
- Re: casting character varying to integer - order by numeric sort Tom Lane
- Re: casting character varying to integer - order by numeric Bryce Nesbitt (mailing list account)
- Re: casting character varying to integer - order by numeric Richard Huxton
- Sql - Error : Relation tmp_datos already exists Adriana Marcela Aguirre
- Problema con migracion de SQL a PostgreSQL Fernando Garcia
- Re: casting character varying to integer - order by numeric Bryce Nesbitt (mailing list account)
- Re: pg, mysql comparison with "group by" clause Chris Travers
- Postgres 7.4.9 slow! Mario Splivalo
- Re: Postgres 7.4.9 slow! Havasvölgyi Ottó
- Re: Postgres 7.4.9 slow! Mario Splivalo
- Re: Postgres 7.4.9 slow! Thomas Pundt
- Delete rule chain stops unexpectedly Wiebe Cazemier
- Re: Postgres 7.4.9 slow! Tom Lane
- Re: Postgres 7.4.9 slow! Mario Splivalo
- Re: Delete rule chain stops unexpectedly Tom Lane
- Re: Delete rule chain stops unexpectedly Wiebe Cazemier
- Re: Delete rule chain stops unexpectedly Tom Lane
- Reading bytea field Jochen Kokemüller
- Re: Delete rule chain stops unexpectedly Wiebe Cazemier
- Re: Delete rule chain stops unexpectedly Tom Lane
- Blank-padding (was: Oracle buys Innobase) Dean Gibson (DB Administrator)
- Re: Blank-padding (was: Oracle buys Innobase) Tom Lane
- Re: Blank-padding Chris Travers
- Re: Blank-padding Dean Gibson (DB Administrator)
- unsuscribe Nicolas Cornu
- ... Илья Конюхов
- Re: Blank-padding Scott Marlowe
- Re: Blank-padding Shaun Watts
- ... Илья Конюхов
- Re: Blank-padding Tom Lane
- Re: Silke Trissl
- Re: Problema con migracion de SQL a PostgreSQL Cristian Prieto
- Re: query tables based on a query Bruno Wolff III
- how to create rule as on delete efa din
- writable joined view Sarah Asmaels
- automatic update or insert tobbe
- Article on Oracle & MySQL in E-week Wendell Anderson
- SQL language krishnaa sridharan
- Merging lines with NULLs (with example data) MaXX
- How much more would you earn? Charles
- SQL Functions gurkan@resolution.com
- Re: Sql - Error : Relation tmp_datos already exists tobbe
- Aggregate versus lineitem report Jerry Blumenthal
- SQL Functions gurkan@resolution.com
- Re: automatic update or insert Stewart Ben (RBAU/EQS4) *
- Re: how to create rule as on delete Stewart Ben (RBAU/EQS4) *
- Re: SQL language Michael Glaesemann
- Re: Article on Oracle & MySQL in E-week Michael Glaesemann
- Re: how to create rule as on delete elein
- convert timezone to string ... Marc G. Fournier
- Re: automatic update or insert PFC
- Re: convert timezone to string ... Magnus Hagander
- Re: writable joined view Wiebe Cazemier
- Re: convert timezone to string ... Tom Lane
- Re: Merging lines with NULLs (with example data) Harald Fuchs
- Re: Merging lines with NULLs (with example data) Daryl Richter
- Re: automatic update or insert Daryl Richter
- Re: writable joined view Richard Huxton
- Re: convert timezone to string ... Marc G. Fournier
- Re: automatic update or insert codeWarrior
- Re: Delete rule chain stops unexpectedly Wiebe Cazemier
- 8.0.x windows installer fails? george young
- Re: 8.0.x windows installer fails? Magnus Hagander
- Re: Delete rule chain stops unexpectedly Tom Lane
- backend error Judith Altamirano Figueroa
- broken join optimization? (8.0) chester c young
- ?Equiv to oracle (ENABLE|DISABLE) (CONSTRAINT|TRIGGER) statements? Bath, David
- Re: ?Equiv to oracle (ENABLE|DISABLE) (CONSTRAINT|TRIGGER) statements? Bruce Momjian
- Re: broken join optimization? (8.0) Michael Fuhr
- Re: backend error Michael Fuhr
- Re: broken join optimization? (8.0) Tom Lane
- padding an integer ... Marc G. Fournier
- pl/* overhead ... Marc G. Fournier
- Re: padding an integer ... Michael Fuhr
- why vacuum Kenneth Gonsalves
- Re: why vacuum Tom Lane
- Re: why vacuum Michael Fuhr
- Re: why vacuum Bath, David
- Re: pl/* overhead ... Michael Fuhr
- Re: why vacuum Tom Lane
- Re: why vacuum Kenneth Gonsalves
- Re: automatic update or insert Patrick JACQUOT
- Re: broken join optimization? (8.0) Richard Huxton
- converting epoch to timestamp Rajesh Kumar Mallah
- Re: converting epoch to timestamp A. Kretschmer
- Re: converting epoch to timestamp Richard Huxton
- Re: converting epoch to timestamp Stef
- Re: pl/* overhead ... Marc G. Fournier
- SETOF RECORD RETURN VALUE Christian Paul B. Cosinas
- Re: SETOF RECORD RETURN VALUE Sean Davis
- RETURNS SETOF primitive returns results in parentheses Mario Splivalo
- Re: RETURNS SETOF primitive returns results in parentheses Sean Davis
- Re: RETURNS SETOF primitive returns results in parentheses Mario Splivalo
- Re: pl/* overhead ... Jan Wieck
- Re: RETURNS SETOF primitive returns results in parentheses Tom Lane
- Re: why vacuum Scott Marlowe
- Re: RETURNS SETOF primitive returns results in parentheses Stephan Szabo
- Combining two SELECTs by same filters Volkan YAZICI
- select best price Gary Stainburn
- Re: why vacuum Scott Marlowe
- Re: select best price Gary Stainburn
- Re: Combining two SELECTs by same filters Scott Marlowe
- Re: why vacuum Jan Wieck
- Re: why vacuum Scott Marlowe
- Re: broken join optimization? (8.0) chester c young
- Re: why vacuum Tom Lane
- Re: Combining two SELECTs by same filters Michael Fuhr
- Re: why vacuum Scott Marlowe
- Re: broken join optimization? (8.0) Tom Lane
- SUM not matching up on a JOIN Tyler Kellen
- Re: broken join optimization? (8.0) chester c young
- Re: Combining two SELECTs by same filters Bruno Wolff III
- Re: select best price Bruno Wolff III
- Re: RETURNS SETOF primitive returns results in parentheses Mario Splivalo
- Re: RETURNS SETOF primitive returns results in parentheses Tom Lane
- Re: RETURNS SETOF primitive returns results in parentheses Mario Splivalo
- Re: SUM not matching up on a JOIN Tom Lane
- Re: SQL Functions Thomas F. O'Connell
- Yes, pg does triggers first before asserting check constraints! Was Re: why vacuum Bath, David
- Re: Yes, pg does triggers first before asserting check constraints! Was Re: why vacuum Tom Lane
- Re: why vacuum Igor Shevchenko
- handling money type padmanabha konkodi
- How to speed up the database query? Abdul Wahab Dahalan
- Complex Query - Data from 3 tables simultaneously
- Re: How to speed up the database query? Andreas Kretschmer
- Re: How to speed up the database query? Christian Paul B. Cosinas
- Re: How to speed up the database query?
- Re: why vacuum Mario Splivalo
- Re: why vacuum Mario Splivalo
- Re: handling money type Richard Huxton
- Re: Complex Query - Data from 3 tables simultaneously Richard Huxton
- Re: why vacuum Andrew Sullivan
- Re: Complex Query - Data from 3 tables simultaneously
- Re: why vacuum Mario Splivalo
- Re: why vacuum Richard Huxton
- Re: why vacuum Jan Wieck
- Re: why vacuum Jan Wieck
- unsuscribe Ing. Jhon Carrillo-Venezuela
- Re: handling money type codeWarrior
- Re: why vacuum Andrew Sullivan
- Re: How to speed up the database query? Bruno Wolff III
- Re: why vacuum Jan Wieck
- Re: How to speed up the database query? Jim C. Nasby
- combining records from a single table and presenting them as one record Abhishek
- Re: why vacuum Jim C. Nasby
- Re: Merging lines with NULLs (with example data) MaXX
- Referencing lucas@presserv.org
- Re: combining records from a single table and presenting them as one record boinger
- Re: combining records from a single table and presenting Frank Bax
- Re: converting epoch to timestamp Rajesh Kumar Mallah
- Re: why vacuum Mario Splivalo
- Re: why vacuum Andrew Sullivan
- Fwd: Re: Referencing lucas@presserv.org
- Re: Fwd: Re: Referencing Daryl Richter
- Re: combining records from a single table and presenting them as one record Abhishek
- Re: Fwd: Re: Referencing lucas@presserv.org
- Re: Complex Query - Data from 3 tables simultaneously Muralidharan Ramakrishnan
- Re: combining records from a single table and presenting them as one record Michael Fuhr
- information_schema problem Kyle Bateman
- Re: Complex Query - Data from 3 tables simultaneously
- Two tables or three? James Cloos
- Re: Aggregate versus lineitem report Bruno Wolff III
- Re: Two tables or three? Tom Lane
- Re: Two tables or three? James Cloos
- Nested Table in PostgreSQL or some alternative Variants Thomas Zuberbuehler
- Re: Fwd: Re: Referencing Daryl Richter
- pgSQL, executing generic query Alessandro Busato
- Poor performance in inet << cidr join Axel Rau
- Re: Fwd: Re: Referencing lucas@presserv.org