Interval examples - Mailing list pgsql-general

From George Robinson II
Subject Interval examples
Date
Msg-id 39998F0B.6F0AB573@eurekabroadband.com
Whole thread Raw
List pgsql-general
    Could someone please send me some examples of the interval data type?
For example, what should the data look like in order to do and insert?
If I have two iso time stamps, how can I insert them into the interval
datatype?  What are some ways to format the output of an interval type?

    Note: When working in perl, I have found the "Perl Cookbook" the most
valuable asset I have.  I think we should get together and produce a web
site where people can submit various type of code involving postgres, so
that newbies (such as myself) have lots of material to learn from.  I'll
have plenty of examples to submit when I'm done with this project.  And
I'd do it myself, but I'm not really a web guy.

    Thanks for the help

-g2

pgsql-general by date:

Previous
From: "Steve Wolfe"
Date:
Subject: Tuning PostgreSQL to use more RAM...
Next
From: Lee Johnson
Date:
Subject: Re: