Re: Casting to money

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Dave Page
> Sent: 09 October 2006 08:42
> To: Tom Lane
> Cc: PostgreSQL Hackers
> Subject: Re: [HACKERS] Casting to money
>
>
>
> > -----Original Message-----
> > From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> > Sent: 09 October 2006 04:15
> > To: Dave Page
> > Cc: PostgreSQL Hackers
> > Subject: Re: [HACKERS] Casting to money
> >
> > "Dave Page" <dpage(at)vale-housing(dot)co(dot)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.

As does

select '£123.44'::money

In en_GB on the same box, so I guess this is a windows issue.

/D