Re: [SQL] sorting months according to fiscal year

2011-08-22 Thread Gavin Flower
On 23/08/11 01:27, Enzen user wrote: Hi I have to rearrange the months according to the fiscal year i.e from April to march and use the same in the order by clause of a query. I have written the following postgresql function for the same, but to_number is returning an error. Can you please tell

Re: [SQL] sorting months according to fiscal year

2011-08-22 Thread Pavel Stehule
Hello 2011/8/22 Enzen user : > Hi > I have to  rearrange the months according to the fiscal year i.e from April > to march and use the same in the order by clause of a query. > I have written the following postgresql function for the same, but to_number > is returning an error. > Can you please te

[SQL] sorting months according to fiscal year

2011-08-22 Thread Enzen user
Hi I have to rearrange the months according to the fiscal year i.e from April to march and use the same in the order by clause of a query. I have written the following postgresql function for the same, but to_number is returning an error. Can you please tell me where i'm going wrong? Instead of t