Populate a calendar table - Mailing list pgsql-general

'Lo all,

I've created a calendar table based on an article I found on the web,
but I can't figure out what's wrong with the query I've written to
populate it. Here's the table -

CREATE TABLE aux_dates
(
   the_date date NOT NULL,
   the_year smallint NOT NULL,
   the_month smallint NOT NULL,
   the_day smallint NOT NULL,
   month_name character varying(12),
   day_name character varying(12),
   CONSTRAINT aux_dates_pkey PRIMARY KEY (the_date)
)

- and here's what I've come up with to populate it -

insert into aux_dates
select * from (
select
     d.dates as the_date,
     extract (year from d.dates) as the_year,
     extract (month from d.dates) as the_month,
     extract (day from d.dates) as the_day,
     to_char(extract (month from d.dates), 'FMmonth') as month_name,
     to_char(extract (day from d.dates), 'FMday') as day_name
   from
   (
     select ('2007-01-01'::date + s.a) as dates
     from generate_series(0, 14) as s(a)
   ) d
) dd;

The error I get is:

     ERROR: "." is not a number
     SQL state: 22P02

Any help will be appreciated!

Thanks,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------