dbTalk Databases Forums  

[Info-Ingres] Allowing integer constants to be expressed in 'k'

comp.databases.ingres comp.databases.ingres


Discuss [Info-Ingres] Allowing integer constants to be expressed in 'k' in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Martin Bowes
 
Posts: n/a

Default [Info-Ingres] Allowing integer constants to be expressed in 'k' - 10-27-2009 , 03:04 AM






Hi All,



I've worked out how to munge the Opensource to allow me to express
integer constants in k....only 4 files need to be altered, its really
sweet!



This allows us to do things like:

create table x (a integer) with page_size=8k;

modify x to hash unique on a with minpages=120k;

insert into x(a) values(5k);



etc...



The 'k' is case insensitive, it could be a 'K'.



Before I go through the hassle of submitting a DDS etc I was wondering
if there was any desire to allow megabytes, Gigabytes etc.



Martin Bowes

Reply With Quote
  #2  
Old   
Ingres Forums
 
Posts: n/a

Default Re: [Info-Ingres] Allowing integer constants to be expressed in 'k' - 10-27-2009 , 05:26 AM






I refer you to the comments Karl made on the desirability of supporting
huge data page sizes for data warehousing (right at the end).

'Potential Catalog Updates - Ingres Community Wiki'
(http://community.ingres.com/wiki/Pot...atalog_Updates)

At some point we may see multi-megabyte page sizes (!), so why limit it
whilst you are already messing with the code.


--
nick.bolton (AT) barclays (DOT) com
------------------------------------------------------------------------
nick.bolton (AT) barclays (DOT) com's Profile: http://community.ingres.com/forum/member.php?userid=733
View this thread: http://community.ingres.com/forum/sh...ad.php?t=11286

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.