News for hackers. Stuff that matters.
Re:ARIN migrated from Oracle to PostgreSQL by electrum on Sunday December 29, 2013 @01:41AM (#6978682)
Oracle's documentation is excellent and is WAY more comprehensive than PostgreSQL. For example, most of PostgreSQL's SQL functions have a single line in a table to describe them, whereas each one in Oracle has it's own section with a full description, examples, etc.

I agree that the relative small size of PostgreSQL documentation and the fact that it fits in a single "book" compared to the many books that comprise the Oracle documentation can make it easier to find something. But can't say I've ever seen a product with as much quality documentation as Oracle.

You can find the documentation for Oracle 12c here: http://www.oracle.com/pls/db121/homepage

As a user, you want to look in "SQL Language Reference" first, followed by "Data Warehousing Guide" (found in a separate folder on the left side). As an administrator, "Concepts" is required reading followed by "Administrator's Guide".

Re:ARIN migrated from Oracle to PostgreSQL by dragonwriter on Sunday December 29, 2013 @02:37AM (#6978791)
> Oracle's documentation is excellent and is WAY more comprehensive than PostgreSQL.

I'd generally agree that Oracle's documentation is more extensive than PostgreSQL's in many respects, but Oracle's is also substantially less well organized than PostgreSQL's.

Re:ARIN migrated from Oracle to PostgreSQL by dschiptsov on Sunday December 29, 2013 @07:48AM (#6979401)
But it is so annoying to filter out all that branding, marketing slogans and self praise.)
Re:ARIN migrated from Oracle to PostgreSQL by samplonius on Sunday December 29, 2013 @03:27AM (#6978888)
> For example, most of PostgreSQL's SQL functions have a single line in a table to describe them

Reference?

Re:ARIN migrated from Oracle to PostgreSQL by VLM on Sunday December 29, 2013 @09:31AM (#6979611)
This is probably a good discussion point

http://www.postgresql.org/docs/9.3/static/functions-aggregat...

Not only as an example of "single line in a table" but also as an example where a huge volume would not add much value.

I'm struggling at this time to figure out how to produce multiple pages of boilerplate explaining "min()" that would be any more useful than the table.

On the other hand the explanation about nulls really sucks. Its important enough to put in the single line. For those too lazy to click and read, when a noob thinks he wants "SUM(bunchastuff)" what he probably wants is along the lines of using COALESCE or a homemade function that smells like COALESCE. There is a meta discussion that whenever NULLs are possible, and its more than just table definitions for example an overactive WHERE clause, then the NULLs will be a PITA. Defensive SQL coding can be tedious.

Re:ARIN migrated from Oracle to PostgreSQL by akira2501 on Sunday December 29, 2013 @10:50AM (#6979899)
It can also be viewed directly in the 'psql' shell with '\df'.
Re:ARIN migrated from Oracle to PostgreSQL by rbanffy on Sunday December 29, 2013 @07:57PM (#6982440)
Unfortunately, Oracle's documentation document Oracle's product. That's reason enough to prefer PostgreSQL's documentation.

That was a bit tongue-in-cheek... Oracle makes an exceptionally solid RDBMS and deserves credit for that. It's just that it hurts every time I write VARCHAR2.

Re:ARIN migrated from Oracle to PostgreSQL by late2part on Sunday December 29, 2013 @01:43AM (#6978685)
Nice try, Larry.