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

Re: SQL and function reference?

From: Jason Dixon <jason(at)dixongroup(dot)net>
To: "Rodolfo J(dot) Paiz" <rpaiz(at)simpaticus(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL and function reference?
Date: 2005-01-25 02:13:43
Message-ID: BCF355D0-6E76-11D9-8CFE-000D93C63BA8@dixongroup.net (view raw or flat)
Thread:
Lists: pgsql-novice
On Jan 24, 2005, at 8:39 PM, Rodolfo J. Paiz wrote:

> Hey, everyone:

Hi Rodolfo.  Funny how we keep running into each other.  :)

> 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.

http://www.postgresql.org/docs/manuals/

> 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?

The postgres manuals are very comprehensive but aren't tailored to SQL 
beginners.  However, the development team strives for compliance with 
the SQL standards, so you should be ok with a good SQL 
(non-db-specific) book.  I picked up Bruce Momjian's PostgreSQL book 
some time ago.  While much of it is dated with regards to 7.4 and 8.0, 
it is still a good introduction to basic postgres methodologies.

> 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.

Bzzzt!  Sorry, you've exceeded your daily quota.  You will be kicked.  
;-)

--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net



In response to

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2005-01-25 02:18:06
Subject: Re: SQL and function reference?
Previous:From: Sean DavisDate: 2005-01-25 02:08:58
Subject: Re: Formatting a month in query output

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