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]

In reply to Re: deleting using DBI from PostgresSQL table by jonadab
in thread deleting using DBI from a PostgreSQL table by indapa

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.