Postgres Pro
Downloads
Home   >   mailing lists

Re: Populate a calendar table - Mailing list pgsql-general

From Tom Lane
Subject Re: Populate a calendar table
Date
Msg-id 27754.1175011249@sss.pgh.pa.us
Whole thread Raw
In response to Populate a calendar table  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: Populate a calendar table  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general
Tree view 
"Raymond O'Donnell" <rod@iol.ie> writes:
>      to_char(extract (month from d.dates), 'FMmonth') as month_name,
>      to_char(extract (day from d.dates), 'FMday') as day_name

I think you want just to_char(d.dates, 'FMmonth') and so on.
What you're invoking above is to_char(numeric) which has entirely
different format codes...

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-advocacy] Is there a shortage of postgresql skilled ops people
Next
From: Osvaldo Rosario Kussama
Date:
Subject: Re: Populate a calendar table