[DOCS] Section "Routine Reindexing"

2003-11-03 Thread Peter Eisentraut
The section "Routine Reindexing" (21.2) has been reduced to: """ In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command. (There is also contrib/reindexdb which can reindex an entire database.) However, PostgreSQL 7.4 has substantially reduced the need for this

Re: [DOCS] Section "Routine Reindexing"

2003-11-03 Thread Josh Berkus
Peter, > """ > In some situations it is worthwhile to rebuild indexes periodically with > the REINDEX command. (There is also contrib/reindexdb which can reindex an > entire database.) However, PostgreSQL 7.4 has substantially reduced the > need for this activity compared to earlier releases. > ""

Re: [DOCS] INNER JOINS in sql-select.html

2003-11-03 Thread Henry B. Hotz
At 5:56 PM -0500 10/30/03, Tom Lane wrote: Stefan Weiss <[EMAIL PROTECTED]> writes: From : > | A CROSS JOIN or INNER JOIN is a simple Cartesian product, the same | as you get from listing the two items at the top level of FROM. CROSS | JOIN is equivalent to INNER JOIN ON (TRUE), that is, no row

Re: [DOCS] INNER JOINS in sql-select.html

2003-11-03 Thread Tom Lane
"Henry B. Hotz" <[EMAIL PROTECTED]> writes: > You can imply the issue without obfuscating things. How about: > A CROSS JOIN or INNER JOIN is a simple Cartesian product, the same > as you get from listing the two items at the top level of FROM. > CROSS JOIN yields the same results as INNER JOIN

Re: [DOCS] INNER JOINS in sql-select.html

2003-11-03 Thread Henry B. Hotz
At 7:38 PM -0500 11/3/03, Tom Lane wrote: "Henry B. Hotz" <[EMAIL PROTECTED]> writes: You can imply the issue without obfuscating things. How about: A CROSS JOIN or INNER JOIN is a simple Cartesian product, the same as you get from listing the two items at the top level of FROM. CROSS JOIN yi

Re: [DOCS] Annotated release notes

2003-11-03 Thread Carroll, Catherine A.
I'm hoping one of you an answer a question for me. I am accessing Service Center data via an Oracle ODBC driver for reporting and queries. How can I get the resolution field using these methods. Thanks, Catherine Carroll TSG Solutions Center Washington Mutual Bank 565 Lakeview Parkway Sui

Re: [DOCS] Annotated release notes

2003-11-03 Thread Josh Berkus
Ms. Carroll, > I'm hoping one of you an answer a question for me. I am accessing > Service Center data via an Oracle ODBC driver for reporting and queries. > How can I get the resolution field using these methods. Howdy from one of your customers! I'm not certain how, exactly, you got the set o