CREATE TABLE test (id NUMBER);
Oracle treats NUMBER as NUMBER(40) I think.
This seems to be an example of Oracle making up standards as they go along - do we want to copy this sort of thing ?
I usually just run a substitution of NUMBER(..) -> NUMERIC(..) and NUMBER -> INTEGER when transporting schemas from Oracle to Pg.
(This needs a little care - as NUMBER in Oracle has bigger scale than INTEGER in Pg)
regards
Mark
+ PostgreSQL does not support the NUMBER keyword without (...)
i.e. something in parenthesis following it.
Don't follow this one either. We don't have NUMBER --- are you speaking
of NUMERIC? If so, I'm not aware of any context where you're required
to put a precision on NUMERIC. Again, may we see an example?
Ditto.
Sincerely,
Joshua D. Drake
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])