> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> 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.