This is a discussion on Re: Casting to money within the pgsql Hackers forums, part of the PostgreSQL category; --> > postgres=# select "123.45"::money; > ERROR: column "123.45" does not exist > LINE 1: select "123.45"::money; > ^ > ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > 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/s...SQL-SYNTAX-IDE NTIFIERS Anything between double quotes is an identifier. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |