Re: Populate a calendar table

Raymond O'Donnell escreveu:
> '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!
>

Try:
to_char(d.dates, 'FMmonth') as month_name,
to_char(d.dates, 'FMday') as day_name

[]s
Osvaldo

_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/