In general, the manual is quite good. It is fully searchable and easy to
read. It can be found here:
http://www.postgresql.org/docs/8.0/interactive/
There are also a books, three of which are available online:
http://www.postgresql.org/docs/books/
And, of course, there is always the MANY postgresql email lists and their
SEARCHABLE archives:
http://archives.postgresql.org/
Open source and the postgresql community are full of resources, and those
above are only a few.
Sean
----- Original Message -----
From: "Rodolfo J. Paiz" <rpaiz@simpaticus.com>
To: <pgsql-novice@postgresql.org>
Sent: Monday, January 24, 2005 8:39 PM
Subject: [NOVICE] SQL and function reference?
> Hey, everyone:
>
> My first post here, so nice to meet y'all. I've recently started working
> with PostgreSQL (in fact, recently started working with SQL...) and
> although I'm getting off to a good start, sometimes things go bump in
> the night.
>
> In particular, I quite frequently don't know where to find answers; and
> I don't want to post every bloody question here. It's slow for me, and
> doubtless 99% will be FAQs or would have been solved by RTFM... if I
> could find the darn FM to R.
>
> In general, could someone point me to a good reference for SQL and
> PostgreSQL commands? Immediately after subbing to this list, for
> example, I saw the "extracting date from timestamp" thread which
> mentions the date_trunc() function. This one function does part of what
> I'd like to do in one query (thanks!) but I had not found it before.
> Where can I find either a reference or a tutorial to SQL in general and
> to this kind of functions?
>
> I'll also shoot off a quick three questions if y'all don't mind, in
> separate threads to make life easy on the archives.
>
> Cheers!
>
> --
> Rodolfo J. Paiz <rpaiz@simpaticus.com>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>