From: | "Andy Marden" <amarden(at)usa(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Casting Varchar to Numeric |
Date: | 2001-11-27 09:55:41 |
Message-ID: | 9tvo1j$1u7g$1@news.tht.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Just undertaking a port of a small Data Warehouse-type batch load
application from Oracle to PostgreSQL. It's common practice in such a system
to load data into a staging table whose fields are typically all varying
text. Then the conversion and mapping of the data is done as a second stage
into the 'proper' tables.
In Oracle, you can put a text field into a numeric field as long as it
contains a number and teh conversion will be implicit (or you can simply
specify to_number(value)) to make the conversion explicitly.
In PostgreSQL, it seems that an error is thrown up if an implicit conversion
is attempted, and the only explicit conversion seems to be to_number(value,
format) which doesn't do what's needed generically enough.
I can't believe that this isn't possible - can anyone point me in the right
direction?
Cheers
Andy Marden
From | Date | Subject | |
---|---|---|---|
Next Message | kingking | 2001-11-27 10:18:15 | Backup Large Object |
Previous Message | petite-etoile@voila.fr | 2001-11-27 09:46:11 | help postgres |