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

SQL and function reference?

From: "Rodolfo J(dot) Paiz" <rpaiz(at)simpaticus(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL and function reference?
Date: 2005-01-25 01:39:36
Message-ID: 1106617176.5298.103.camel@rodolfo.gt.factorrent.com (view raw or flat)
Thread:
Lists: pgsql-novice
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>


Responses

pgsql-novice by date

Next:From: Rodolfo J. PaizDate: 2005-01-25 01:42:32
Subject: Formatting a month in query output
Previous:From: Tom LaneDate: 2005-01-25 00:29:57
Subject: Re: extracting date from timestamp

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