> -----Original Message----- > From: Tom Lane [mailto:[EMAIL PROTECTED] > Sent: 09 October 2006 04:15 > To: Dave Page > Cc: PostgreSQL Hackers > Subject: Re: [HACKERS] Casting to money > > "Dave Page" <dpage@vale-housing.co.uk> writes: > > select '$123.45'::money > > ERROR: invalid input syntax for type money: "$123.45" > > select '£123.00'::money > > ERROR: invalid input syntax for type money: "£123.00" > > So ... what locale are you trying this in?
Oh, sorry - English_United Kingdom.28591, on 8.1.4/win32. Now I'm back at work I do see that select '$123.45'::money Works OK on 8.0.3/Slackware Linux in en_US. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
