This has been discussed (a lot) before.
It should not be too hard to add.

IMO first step would be to document which of the DBs have decimal
support.

>From a previous thread:
http://groups.google.com/group/web2py/browse_thread/thread/0aa4a0671489f6ac

p=precision, s=scale, [means optional]

---DB----  -----syntax-----  --limits---  --dft--
MSSQL2005  decimal[(p[,s])]  0<=s<=p<=38  18,0
DB2/400          "           1<=s<=p<=31  5,0

MYSQL
spec: For DECIMAL(M,D), the maximum M is 65
create: CREATE TABLE foo( bar decimal(10,2) )

POSTGRESQL
spec: DECIMAL(M,D), exact, no limit
create: CREATE TABLE foo( bar decimal(10,2) )

SQLite : no

Denes.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to