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) ) DenesL napsal(a): > Lets document the support for decimal type in the available DBs (my $. > 02): > > 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 > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
