Forum OpenACS Development: Oracle's Number Datatype

Collapse
1: Oracle's Number Datatype
Posted by Gilbert Wong on 05/20/01 09:32 PM
What is the PostgreSQL equivalent to Oracle's number datatype?
Thanks.
Collapse
2: Response to Oracle's Number Datatype (response to 1)
Posted by Don Baccus on 05/20/01 11:29 PM
"numeric".  Oracle supports it, too, because it is the SQL92 standard name.  I don't know why aD doesn't use the standard name.

Hmmm...another one for the porting guide, I guess.  The query extractor could handle this for both Oracle and Postgres, but I don't have time at the moment to put it in.

Collapse
3: Response to Oracle's Number Datatype (response to 1)
Posted by Gilbert Wong on 05/21/01 12:06 AM
Thanks.
Collapse
4: which datatype i should use in postgre instead of char and date of oracle (response to 1)
Posted by amit jain on 12/07/06 12:02 PM
I need to migrate from oracle to postgre so kindly suggest some important information like
datatype variaon.

Which datatype should i use at the place of char and date in postgre sql.

very urgent please help me

Regards
Amit 9818450022