Postgres Pro
Downloads
Home   >   mailing lists

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

From Raymond O'Donnell
Subject Re: Populate a calendar table
Date
Msg-id 46095321.5070900@iol.ie
Whole thread Raw
In response to Re: Populate a calendar table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
On 27/03/2007 17:00, Tom Lane wrote:

> 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...

Duh! Of course.....I didn't spot that.

Thanks to all who replied.

Ray.

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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [pgsql-advocacy] Is there a shortage of postgresql skilled ops people
Next
From: "Merlin Moncure"
Date:
Subject: Re: Is there a shortage of postgresql skilled ops people