[GENERAL] Populate a calendar table

[Raymond O'Donnell]

'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
[EMAIL PROTECTED]
---------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/