> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] 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:[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.
As does
select '£123.44'::money
In en_GB on the same box, so I guess this is a windows issue.
/D
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
