I agree with Yarko, let me add that if you are using a legacy database with a 'bigint' field, you can use SQLField(...,'integer',...) and set the table to migrate=False. It will work fine.
Massimo On Dec 12, 3:12 pm, "Yarko Tymciurak" <yark...@gmail.com> wrote: > Well - you cannot use the BUT datatype portably.... you can set it up w/ > SQL;I think the point is understanding if you really need to... > > For example, if you're looking at legacy / existing database, and want to > manipulate results, then yes you can - with work & SQL.... > > But you cannot use BIG with DAL, but you can directly, and loose the DAL > checks and validators (but write your own for that). > > If you want to write a new app and want to specifically use BIG, that's a > different discussion... > > But - as Massimo pointed out - this is outside the "mainstream" of web2py > application creation, since BIG is not a generally portable data type. > > On Fri, Dec 12, 2008 at 11:33 AM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > SQLField('fielname','text') > > SQLField('fielname','blob') > > > do not have size limitations on postgres. You cannot use the BIG > > datatype because it has not equivalent on other databases. > > > Massimo > > > On Dec 12, 10:07 am, Iraklis <i.kordoma...@gmail.com> wrote: > > > Dear web2py community! > > > > How I can use the big data type from Postgresql in web2py???? > > > > Kind Regards > > > Iraklis --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" 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 -~----------~----~----~----~------~----~------~--~---