Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 27 Mar 2007 18:23:45 +0100
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 ---------------------------------------------------------------
- References:
- Populate a calendar table
- From: Raymond O'Donnell
- Re: Populate a calendar table
- From: Tom Lane
- Populate a calendar table
- Prev by Date: Re: Strange behaviour under heavy load
- Next by Date: Re: Is there a shortage of postgresql skilled ops people
- Previous by thread: Re: Populate a calendar table
- Next by thread: Re: Populate a calendar table
- Indexes: