Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

0 views
Skip to first unread message

Martin Bowes

unread,
Oct 27, 2009, 5:04:58 AM10/27/09
to Ingres and related product discussion forum

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

 

 

Ingres Forums

unread,
Oct 27, 2009, 7:26:28 AM10/27/09
to

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/Potential_Catalog_Updates)

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


--
nick....@barclays.com
------------------------------------------------------------------------
nick....@barclays.com's Profile: http://community.ingres.com/forum/member.php?userid=733
View this thread: http://community.ingres.com/forum/showthread.php?t=11286

0 new messages