Re: Populate a calendar table

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 'PostgreSQL' <pgsql-general(at)postgresql(dot)org>
Subject: Re: Populate a calendar table
Date: 2007-03-27 17:23:45
Message-ID: 46095321.5070900@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)iol(dot)ie
---------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-03-27 17:31:20 Re: Is there a shortage of postgresql skilled ops people
Previous Message Dmitry Koterov 2007-03-27 17:13:46 Re: Strange behaviour under heavy load