From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Casting to money |
Date: | 2006-10-09 07:49:13 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40176D393@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> -----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
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Ambler | 2006-10-09 08:05:56 | Re: Casting to money |
Previous Message | Dave Page | 2006-10-09 07:41:34 | Re: Casting to money |