Re: Casting to money

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Casting to money
Date: 2006-10-09 03:15:27
Message-ID: 18826.1160363727@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"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?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Woodward 2006-10-09 03:44:16 Re: Upgrading a database dump/restore
Previous Message Mark Wong 2006-10-09 00:26:11 Re: continuing daily testing of dbt2 against postgresql