| From: | "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at> |
|---|---|
| To: | "Shane Ambler *EXTERN*" <pgsql(at)007Marketing(dot)com>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Casting to money |
| Date: | 2006-10-09 08:19:34 |
| Message-ID: | 52EF20B2E3209443BC37736D00C3C1380ABB2040@EXADV1.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> postgres=# select "123.45"::money;
> ERROR: column "123.45" does not exist
> LINE 1: select "123.45"::money;
> ^
> postgres=# select "$123.45"::money;
> ERROR: column "$123.45" does not exist
> LINE 1: select "$123.45"::money;
> ^
You are on the wrong mailing list :^) Try pgsql-general.
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-SYNTAX-IDE
NTIFIERS
Anything between double quotes is an identifier.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Csaba Nagy | 2006-10-09 08:33:01 | Re: pg_dump exclusion switches and functions/types |
| Previous Message | Shane Ambler | 2006-10-09 08:05:56 | Re: Casting to money |