Mailing lists [pgsql-sql]
- Re: Fuzzy matching? Timothy H. Keitt
- Re: Fuzzy matching? Timothy H. Keitt
- Converting epoch to timestamp? Roberto Mello
- Re: Converting epoch to timestamp? Richard Huxton
- Re: Converting epoch to timestamp? Roberto Mello
- Re: Converting epoch to timestamp? Tom Lane
- Exclusion List Michael Richards
- Re: Converting epoch to timestamp? Josh Berkus
- Re: Exclusion List Tom Lane
- Re: Exclusion List Michael Richards
- Outer Join Syntax Richard Rowell
- Re: Outer Join Syntax Joe Conway
- Re: Outer Join Syntax Tom Lane
- Foreign key Lorenzo De Vito
- Re: where'd the spaces come from Bruce Momjian
- Re: where'd the spaces come from Gary Stainburn
- Re: Fuzzy matching? Oleg Bartunov
- Re: where'd the spaces come from Bruce Momjian
- RE: Foreign key Robby Slaughter
- Re: Foreign key Jason Earl
- More Database Design Stuff Jimmie Fulton
- Re: Foreign key Jan Wieck
- Re: More Database Design Stuff Chris Ruprecht
- Re: More Database Design Stuff Josh Berkus
- converting timestamps to ints Morgan Curley
- Re: converting timestamps to ints Josh Berkus
- Donations? Josh Berkus
- Re: converting timestamps to ints Tom Lane
- Knowing new item in table... macky
- Activation of plsql David Lizano
- Re: Activation of plsql Christopher Sawtell
- Re: where'd the spaces come from Richard Huxton
- Re: Knowing new item in table... Christopher Sawtell
- Re: [NOVICE] Knowing new item in table... Jason Earl
- `postgresql.conf' has wrong permissions???
- Feature Requests for 7.2 or 7.3 ... Chris Ruprecht
- Re: `postgresql.conf' has wrong permissions??? Tom Lane
- Re: Feature Requests for 7.2 or 7.3 ... Bruce Momjian
- Re: Feature Requests for 7.2 or 7.3 ... clayton cottingham
- Re: [Re: `postgresql.conf' has wrong permissions??? ]
- Re: Where is the database located in 7.1.2? caldodge@fpcc.net (Calvin Dodge)
- Using functions in SQL statements Allan Engelhardt
- Creating foreign key constraint to child table? Allan Engelhardt
- Re: Creating foreign key constraint to child table? Allan Engelhardt
- Re: Creating foreign key constraint to child table? Stephan Szabo
- Re: Creating foreign key constraint to child table? Allan Engelhardt
- Re: Creating foreign key constraint to child table? Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков
- Re: Date Time Functions - ANSI SQL ? Peter Eisentraut
- Re: Fuzzy matching? Peter Eisentraut
- Inheritance is completely broken [was: Re: Creating foreign key constraint to child table?] Allan Engelhardt
- Data type confusion Josh Berkus
- Re: Re: Date Time Functions - ANSI SQL ? Josh Berkus
- Re: Data type confusion Allan Engelhardt
- Re: Data type confusion Tom Lane
- Re: Data type confusion Josh Berkus
- Re: Re: Data type confusion Tom Lane
- Re: Re: Data type confusion Peter Eisentraut
- Re: Re: Data type confusion Tom Lane
- Re: Re: Data type confusion Peter Eisentraut
- Re: Re: Data type confusion Tom Lane
- Re: Re: Data type confusion Josh Berkus
- Re: Re: Data type confusion Tom Lane
- prob with PERL/Postgres Kristopher Yates
- Re: Mirroring the database? Allan Engelhardt
- Re: prob with PERL/Postgres Kate Collins
- Re: Data type confusion Allan Engelhardt
- Re: prob with PERL/Postgres clayton
- Re: prob with PERL/Postgres Thomas Good
- Re: Re: Data type confusion Josh Berkus
- Re: prob with PERL/Postgres Allan Engelhardt
- Re: prob with PERL/Postgres Tom Lane
- Re: Re: Data type confusion Tom Lane
- Re: Re: Data type confusion Josh Berkus
- Re: Re: Data type confusion Tom Lane
- Re: [warning: largely off-topic] Re: Data type confusion Josh Berkus
- Re: Re: Data type confusion Josh Berkus
- [warning: largely off-topic] Re: Data type confusion Allan Engelhardt
- views and null bothering Martín Marqués
- Re: views and null bothering Josh Berkus
- Simple Insert Problem Gonzo Rock
- Re: Simple Insert Problem Josh Berkus
- RE: Simple Insert Problem Robby Slaughter
- RE: Simple Insert Problem GonzoRock@excite.com
- Re: Simple Insert Problem Josh Berkus
- Delete coloumn Suhadi
- Re: Delete coloumn Grant
- RE: Delete coloumn Robby Slaughter
- Re: Delete coloumn Grant
- Delete Trigger Issue Sundararajan
- RE: Delete Trigger Issue Robby Slaughter
- Re: Delete Trigger Issue Stephan Szabo
- RE: Delete coloumn Grigoriy G. Vovk
- Are circular REFERENCES possible ? Denis Bucher
- Re: Are circular REFERENCES possible ? Grigoriy G. Vovk
- Re: Are circular REFERENCES possible ? David Lizano
- Re: prob with PERL/Postgres Thomas Good
- Re: Simple Insert Problem Jan Wieck
- Re: Are circular REFERENCES possible ? Josh Berkus
- Re: Adding an INTERVAL to a variable Vivek Khera
- Why can't I ......... mbenzid@yahoo.de (Mounir Benzid)
- Re: When PostgreSQL compliant JDBC 2.0? Gunnar Rønning
- Re: Are circular REFERENCES possible ? Gary Stainburn
- Re: Re: Adding an INTERVAL to a variable Josh Berkus
- Re: Are circular REFERENCES possible ? Stephan Szabo
- Re: Why can't I ......... Josh Berkus
- Re: Are circular REFERENCES possible ? Jan Wieck
- Re: Are circular REFERENCES possible ? Josh Berkus
- Name Alike Challenge Josh Berkus
- Re: Are circular REFERENCES possible ? Jan Wieck
- Re: Are circular REFERENCES possible ? Tom Lane
- Re: Why can't I ......... Tom Lane
- Re: Are circular REFERENCES possible ? Jan Wieck
- Re: views and null bothering Martín Marqués
- loop on a rule Martín Marqués
- Re: loop on a rule Tom Lane
- Re: loop on a rule Martín Marqués
- Re: Name Alike Challenge Joe Conway
- Re: Are circular REFERENCES possible ? Gary Stainburn
- Referencing named attribute in where clause doesn't work with 7.1.2? Andreas Joseph Krogh
- Functions returning more than one value Chris Ruprecht
- Re: Referencing named attribute in where clause doesn't work with 7.1.2? Thomas Good
- Re: Referencing named attribute in where clause doesn't workwith 7.1.2? Andreas Joseph Krogh
- Re: Referencing named attribute in where clause doesn't work with 7.1.2? Peter Eisentraut
- RE: Referencing named attribute in where clause doesn't work with 7.1.2? Jeff Eckermann
- Re: RE: Referencing named attribute in where clause doesn't work with7.1.2? Andreas Joseph Krogh
- Re: Functions returning more than one value Chris Ruprecht
- REFERENCES constraint Cedar Cox
- RE: RE: Referencing named attribute in where clause doesn't work with7.1.2? Jeff Eckermann
- Re: REFERENCES constraint Josh Berkus
- Problem with aggregate functions and GROUP BY Alex Page
- Re: Functions returning more than one value Josh Berkus
- Re: REFERENCES constraint Josh Berkus
- Re: REFERENCES constraint Grigoriy G. Vovk
- Re: Problem with aggregate functions and GROUP BY Tom Lane
- Re: Functions returning more than one value Grigoriy G. Vovk
- Re: REFERENCES constraint Jan Wieck
- Re: REFERENCES constraint Stephan Szabo
- Re: Problem with aggregate functions and GROUP BY Josh Berkus
- what does this error mean? Carolyn Lu Wong
- Re: Adding an INTERVAL to a variable Graham Coates
- Re: what does this error mean? Tom Lane
- ODBC 7.1 Keith Gray
- Re: ODBC 7.1 Hiroshi Inoue
- INSERT FOLLOW WITH OTHER INSERT Johny Jugianto
- Re: INSERT FOLLOW WITH OTHER INSERT Bhuvan A
- Linuxworld Expo? Josh Berkus
- BUG in EXTRACT(MICROSECONDS...)? Allan Engelhardt
- Small parser bug? Allan Engelhardt
- How to change default time display format (and buglet?)? Allan Engelhardt
- Re: Re: Fuzzy matching? Timothy H. Keitt
- how do i... Robert J. Sanford, Jr.
- RE: how do i... Robert J. Sanford, Jr.
- RE: how do i... omid omoomi
- Re: RE: how do i... Roberto Mello
- RE: RE: how do i... Robert J. Sanford, Jr.
- Re: REFERENCES constraint Cedar Cox
- Re: REFERENCES constraint Peter Eisentraut
- Re: REFERENCES constraint Josh Berkus
- Arithmetic operation on DATE macky
- Arithmetic operation on DATE macky
- Re: Arithmetic operation on DATE Christopher Sawtell
- Re: Arithmetic operation on DATE Antti Linno
- Re: Arithmetic operation on DATE Christopher Sawtell
- Re: Arithmetic operation on DATE Karel Zak
- Mirroring the database? Raymond Chui
- Re: prob with PERL/Postgres Kate Collins
- optimizing select ... not in (select ...) Laurent Martelli
- Re: Donations? Laurent Martelli
- Re: REFERENCES constraint alangutierrez@hotmail.com (agutier)
- Re: optimizing select ... not in (select ...) Josh Berkus
- Re: optimizing select ... not in (select ...) Tomas Berndtsson
- Re: optimizing select ... not in (select ...) Bruce Momjian
- Re: optimizing select ... not in (select ...) Laurent Martelli
- Eh? Josh Berkus
- Re: Eh? Tom Lane
- Re: Eh? Josh Berkus
- Re: Eh? Tod McQuillin
- DateDiff, IsNull? Bill
- on update restrict Mister ics
- Re: on update restrict Jan Wieck
- create function using language SQL Gary Stainburn
- Re: Are circular REFERENCES possible ? William Courtier
- The numbers are not match in 7.1.2 Raymond Chui
- Re: on update restrict Alan Gutierrez
- Where is pgplsql.so located in 7.1.2? Raymond Chui
- deleting large objects from jdbc heatherm@famoice.com
- problem connecting to pg. postgresql
- Re: [GENERAL] Re: Mirroring the database? Justin Clift
- Re: DateDiff, IsNull? Alan Gutierrez
- RE: Re: Are circular REFERENCES possible ? Michael Ansley (UK)
- Re: create function using language SQL Jeff Eckermann
- Re: [NOVICE] Arithmetic operation on DATE Jason Wong
- Re: create function using language SQL Tom Lane
- Re: Re: DateDiff, IsNull? Tom Lane
- Re: Re: DateDiff, IsNull? Manuel Sugawara
- how to use record type Horst Herb
- Re: Eh? Tom Lane
- Re: Re: DateDiff, IsNull? Ross J. Reedstrom
- Re: problem connecting to pg. Josh Berkus
- Date: the day before yesterday. Jason
- Re: the day before yesterday. Carl Karsten
- Re: DateDiff, IsNull? Josh Berkus
- Deadlocks? What happened to MVCC? Josh Berkus
- Re: Re: Are circular REFERENCES possible ? Gary Stainburn
- Re: Deadlocks? What happened to MVCC? Jan Wieck
- Re: Date: the day before yesterday. Jan Wieck
- psql connection being reset during function? Randall Skelton
- Re: Deadlocks? What happened to MVCC? Tom Lane
- Re: psql connection being reset during function? Tom Lane
- Re: Deadlocks? What happened to MVCC? Josh Berkus
- Temp tables being written to disk. Avoidable? Paul McGarry
- result sets from functions... Robert J. Sanford, Jr.
- Re: result sets from functions... Josh Berkus
- Re: DateDiff, IsNull? Bill
- Re: DateDiff, IsNull? Bill
- Re: Re: DateDiff, IsNull? Tom Lane
- Re: result sets from functions... Jan Wieck
- RE: Temp tables being written to disk. Avoidable? Paul McGarry
- Re: psql connection being reset during function? Randall Skelton
- Re: on update restrict Mister ics
- Re: Re: DateDiff, IsNull? Alan Gutierrez
- Re: on update restrict Jan Wieck
- Re: Re: Re: DateDiff, IsNull? Josh Berkus
- \set variant for use in regular sql commands Jeff Barrett
- Re: Temp tables being written to disk. Avoidable? Bruce Momjian
- Thanks Bill
- RE: Temp tables being written to disk. Avoidable? Paul McGarry
- Interval FAQ - please review Josh Berkus
- Re: Interval FAQ - please review Vivek Khera
- Re: Interval FAQ - please review Jeff Eckermann
- Re: Re: Help!!! Trying to "SELECT" and get a tree structure back. Mark Stosberg
- Nested JOINs Oleg Lebedev
- Re: Re: Interval FAQ - please review Vivek Khera
- Re: Interval FAQ - please review Josh Berkus
- Re: Re: Interval FAQ - please review Josh Berkus
- Re: Nested JOINs Tom Lane
- Re: Nested JOINs Josh Berkus
- Re: Interval FAQ - please review Peter Eisentraut
- Re: Nested JOINs Tom Lane
- Fwd: how to use record type Horst Herb
- Query Approach and performance Morgan Curley
- Re: how to use record type Jeff Eckermann
- Re: Nested JOINs - upgrade to 7.1.2 Oleg Lebedev
- Nested set model Renato De Giovanni
- Function define question Bill
- Re: Function define question omid omoomi
- Re: how to use record type Horst Herb
- Array in plpgsql omid omoomi
- Re: deleting large objects from jdbc Grant
- Re: Array in plpgsql Christopher Sawtell
- Altering pg_conndefaults macky
- Simple SQL-syntax Fredrik Thunberg
- pg_ctl start hangs Christophe Labouisse
- Re: Temp tables being written to disk. Avoidable? Tom Lane
- SQL Statement too long Jayson Callaway
- Sequential select queries...?? Mark Mikulec
- Strange DISTINCT ! Jean-Christophe Boggio
- Re: `postgresql.conf' has wrong permissions??? fimbulvetr@lycos.com (fimbulvetr)
- Re: [GENERAL] Query Approach and performance Martijn van Oosterhout
- user defined function question Joseph Syjuco
- Re: Simple SQL-syntax Jeff Eckermann
- Re: SQL Statement too long Josh Berkus
- RE: Sequential select queries...?? Robby Slaughter
- Re: Sequential select queries...?? Josh Berkus
- Finding table constraints spam@freeuk.com (Stephen Patterson)
- RE: Simple SQL-syntax Michael Ansley (UK)
- Re: Simple SQL-syntax Josh Berkus
- RE: Simple SQL-syntax Robby Slaughter
- Re: Sequential select queries...?? Grigoriy G. Vovk
- Re: Strange DISTINCT ! Oleg Lebedev
- Re: Finding table constraints Johannes Grødem
- How to execute a system file in procedure? Raymond Chui
- Re: Strange DISTINCT ! Stephan Szabo
- Re: Sequential select queries...?? Ross J. Reedstrom
- Re: user defined function question Josh Berkus
- Re: Simple SQL-syntax Josh Berkus
- RE: user defined function question Robert J. Sanford, Jr.
- Re: Sequential select queries...?? Jeff Eckermann
- Re: pg_ctl start hangs Peter Eisentraut
- split/explode functions omid omoomi
- Re: Simple SQL-syntax Josh Berkus
- quick server c question Laurette Cisneros
- Re: Simple SQL-syntax Josh Berkus
- exists Joseph Shraibman
- database location question Carolyn Lu Wong
- Re: exists Stephan Szabo
- is it possible to use arrays in plpgsql function?? Bhuvan A
- Primary vs Unique Index Gonzo Rock
- Re: is it possible to use arrays in plpgsql function?? omid omoomi
- Getting 'n-1'th record. Bhuvan A
- Re: Getting 'n-1'th record. omid omoomi
- Re: Primary vs Unique Index darcy@druid.net (D'Arcy J.M. Cain)
- RE: Sequential select queries...?? Henshall, Stuart - WCP
- Re: database location question Tom Lane
- Re: Getting 'n-1'th record. Tom Lane
- Re: split/explode functions Jeff Eckermann
- Re: Getting 'n-1'th record. Josh Berkus
- Re: Primary vs Unique Index Josh Berkus
- Re: exists Joseph Shraibman
- Re: Getting 'n-1'th record. Jeff Eckermann
- Re: exists Stephan Szabo
- Re: exists Joseph Shraibman
- Re: exists Joseph Shraibman
- Re: exists Stephan Szabo
- Re: exists Tom Lane
- Should I worry? Josh Berkus
- Re: exists Joseph Shraibman
- Re: Should I worry? Tom Lane
- Re: exists Tom Lane
- Re: exists Joseph Shraibman
- Re: exists Tom Lane
- Re: exists Joseph Shraibman
- Altering pg_conndefaults macky
- Re: Altering pg_conndefaults Peter Eisentraut
- Re: How to execute a system file in procedure? Albert REINER
- just checking postgresql
- protected ON DELETE CASCADE Murray Hobbs
- Re: [GENERAL] protected ON DELETE CASCADE Jan Wieck
- Function returning an array Francesco Casadei
- Re: Function returning an array Josh Berkus
- Re: Function returning an array Tom Lane
- Execute permsissions on fuctions Zot O'Connor
- Re: [GENERAL] protected ON DELETE CASCADE Murray Hobbs
- Re: Function returning an array Alex Pilosov
- Re: [GENERAL] protected ON DELETE CASCADE Jan Wieck
- Re: [GENERAL] protected ON DELETE CASCADE Murray Hobbs
- Re: Temp tables being written to disk. Avoidable? [Another TO-DO] Chris Ruprecht
- Re: DBD::Pg install error (freebsd) Vivek Khera
- WHERE on an alias Joseph Shraibman
- Re: WHERE on an alias Joseph Shraibman
- Re: WHERE on an alias Stephan Szabo
- Re: WHERE on an alias Joseph Shraibman
- Re: WHERE on an alias Josh Berkus
- Indexing and performance Josh Berkus
- Re: WHERE on an alias Stephan Szabo
- Re: WHERE on an alias Josh Berkus
- Re: WHERE on an alias Tom Lane
- Re: Execute permsissions on fuctions Zot O'Connor
- Re: Execute permsissions on fuctions Dmitry G. Mastrukov" Дмитрий Геннадьевич Мастрюков
- Re: Execute permsissions on fuctions Christopher Sawtell
- Different Choices For Index/Sequential Scan With And Without A Join In 7.2 Mark kirkwood
- undocumented setval() Cedar Cox
- "AND", "OR" and Materialize :(((( Meszaros Attila
- Re: undocumented setval() Tom Lane
- Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2 Tom Lane
- Re: "AND", "OR" and Materialize :(((( Tom Lane
- Re: "AND", "OR" and Materialize :(((( Meszaros Attila
- Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2
- List archives moved and cleaned up ... Marc G. Fournier
- Re: WHERE on an alias A_Schnabel@t-online.de (Andre Schnabel)
- Vladimir Terziev
- getting the oid for a new tuple in a BEFORE trigger Markus Wagner
- Re: omid omoomi
- Re: getting the oid for a new tuple in a BEFORE trigger omid omoomi
- Re: getting the oid for a new tuple in a BEFORE trigger Josh Berkus
- changes to table creation syntax in 7.1.2? Jayson Callaway
- Re: changes to table creation syntax in 7.1.2? Stephan Szabo
- Re: changes to table creation syntax in 7.1.2? Jason Earl
- GRANT ALL ON TO GROUP failure posting-list@MailAndNews.com (Jari Aalto)
- Re: GRANT ALL ON TO GROUP failure Oliver Elphick
- Re: GRANT ALL ON TO GROUP failure Peter Eisentraut
- Latin-2 sort order Michał Pasternak
- Re: Latin-2 sort order Tatsuo Ishii
- Re: getting the oid for a new tuple in a BEFORE trigger Francesco Casadei
- Re: getting the oid for a new tuple in a BEFORE trigger Peter Eisentraut
- Apache authentication with debian linux Giorgio Volpe
- Apache authentication and v7.1 Giorgio Volpe
- Sql Marcia Cunha
- Re: [NOVICE] protected ON DELETE CASCADE Albert Reiner
- Problem with sequences Vladimir Terziev
- GRANT ALL ON TO GROUP failure jari.aalto@poboxes.com (Jari Aalto+usenet)
- HELP: Trend reporting Jason Charette
- Re: DBD::Pg install error (freebsd) jake@omnimode.com (jake johnson)
- Apache authentication with debian linux Giorgio Volpe
- RE: changes to table creation syntax in 7.1.2? Jayson Callaway
- Re: GRANT ALL ON TO GROUP failure Thurstan R. McDougle
- DBD::Pg install error (freebsd) jake@omnimode.com (jake johnson)
- Create table syntax satish rao
- Help On Postgresql Jaydip
- Re: Problem with sequences Josh Berkus
- Re: Help On Postgresql Arne Weiner
- Re: Create table syntax Arne Weiner
- Re: Create table syntax Stephan Szabo
- Re: Where can I find the SQL Commands that I can use with ECPG Arne Weiner
- Re: Help On Postgresql Jeff Eckermann
- Re: Help On Postgresql Stephan Szabo
- Re: Sql Bruce Momjian
- Re: Latin-2 sort order Tatsuo Ishii
- Re: Help On Postgresql Henshall, Stuart - WCP
- 2 tables, joins and same name... Marc André Paquin
- Index Scan Backward vs. Sort/Sequential Scan when using ORDER BY Keith Bussey
- Re: 2 tables, joins and same name... Richard Poole
- Re: 2 tables, joins and same name... Josh Berkus
- Re: 2 tables, joins and same name... Thomas Rehlich
- Re: 2 tables, joins and same name... Josh Berkus
- Re: 2 tables, joins and same name... Stephan Szabo
- Re: 2 tables, joins and same name... Ross J. Reedstrom