Skip site navigation (1) Skip section navigation (2)

Re: SQL and function reference?

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Rodolfo J(dot) Paiz" <rpaiz(at)simpaticus(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: SQL and function reference?
Date: 2005-01-25 02:18:06
Message-ID: 003501c50284$1b5aa0b0$7d75f345@WATSON (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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 
SEARCHABLE archives:

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>
To: <pgsql-novice(at)postgresql(dot)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(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 DixonDate: 2005-01-25 02:20:30
Subject: Re: Output HTML, or just a handle?
Previous:From: Jason DixonDate: 2005-01-25 02:13:43
Subject: Re: SQL and function reference?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group