In general, the manual is quite good. It is fully searchable and easy to
read. It can be found here:
There are also a books, three of which are available online:
And, of course, there is always the MANY postgresql email lists and their
Open source and the postgresql community are full of resources, and those
above are only a few.
----- Original Message -----
From: "Rodolfo J. Paiz" <rpaiz(at)simpaticus(dot)com>
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.
> Rodolfo J. Paiz <rpaiz(at)simpaticus(dot)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
In response to
pgsql-novice by date
|Next:||From: Jason Dixon||Date: 2005-01-25 02:20:30|
|Subject: Re: Output HTML, or just a handle?|
|Previous:||From: Jason Dixon||Date: 2005-01-25 02:13:43|
|Subject: Re: SQL and function reference?|