SQL output - Mailing list pgsql-sql

From Simon Law
Subject SQL output
Date
Msg-id 84C5C116-630B-4363-AF37-FF38F9BBC813@gmail.com
Whole thread Raw
Responses Re: SQL output
List pgsql-sql
CREATE TABLE tablename (field INTERVAL);

INSERT INTO tablename VALUES('3 weeks');

SELECT field FROM tablename;
_________
|     field      |
|--------------|
|   21 days |
|________|

The output   shows up in days or months but not weeks how do i make  
it output in weeks?
Any help with this will be greatly appreciated

P.S.
Best postgresql book?



pgsql-sql by date:

Previous
From: "Dmitri Bichko"
Date:
Subject: Re: Problem with a Pettern Matching Check
Next
From: Tom Lane
Date:
Subject: Re: Problem with a Pettern Matching Check