PostgreSQL has online documentaion at http://www.postgresql.org/docs/.
| [reply] |
Thanks for the reponses. I should have RTFM a little more closely because indeed my sql syntax was for an insert, not a delte.
| [reply] |
Ummm, I had a look at the documentation of postgresSQL you mentioned, the quality of the SQL documentation doesn't even come close to the Oracle SQL documentation though. I was merely giving a good doco site for SQL language. Postgres, Oracle or not. :-)
| [reply] |
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$/
| [reply]
[d/l] |
I wouldn't call oracle's docs really "quality". Sure, there's a LOT of info, but it's presented in a rather disorganized manner. I've found that to get any real info, I have to use the PG docs and Oracle's docs together. I really should just buy a book.
| [reply] |