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: | Raw Message | Whole Thread | 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 |