| 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:41:34 |
| Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40176D392@ratbert.vale-housing.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> -----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.
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2006-10-09 07:49:13 | Re: Casting to money |
| Previous Message | Jeremy Drake | 2006-10-09 05:30:47 | width_bucket function for timestamps |