I would definitely recommend against using Oracle documentation when your RDBMS is PostgreSQL. I have a book that covers both (as well as MySQL and a fourth option), and even though I primarily use MySQL, I've noticed just from a casual perusal of the book that there are significant differences between the Oracle and PostgreSQL implementations, neither of which seems to adhere to the SQL99 standard at all closely. (Not that the other alternatives adhere to it any better... standardised SQL seems to be a chimera.) My advice is to use documentation intended for the specific RDBMS that you are using. The book that I have (SQL in a Nutshell) is pretty decent IMO, if you're looking for dead-tree documentation. You can see my review of it on Amazon. Or you can use online documentation, or a different book, or whatever, but use documentation that's intended to be used with PostgreSQL, if you're using PostgreSQL. Oracle has differences in many places. For example, in such a commonly used query as INSERT, Oracle has some features that PostgreSQL does not (e.g., partition names), but it also lacks an option (DEFAULT VALUES). Don't confuse yourself: stick with documentation for the RDBMS you are actually using.

$;=sub{$/};@;=map{my($a,$b)=($_,$;);$;=sub{$a.$b->()}}
split//,".rekcah lreP rehtona tsuJ";$\=$ ;->();print$/
[download]