agora inbox for postgres@postgres.berkeley.edu
help / color / mirror / Atom feedFrom: Keith Sklower <sklower@vangogh.CS.Berkeley.EDU>
To: ren@math.ohio-state.edu
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: About "Queries over variable sized arrays" too!
Date: Fri, 13 May 1994 13:03:54 -0700
Message-ID: <199405132003.NAA13996@vangogh.CS.Berkeley.EDU> (raw)
I shoulda looked before I leaped. I spent 3 hours which I didn't
have writing the document .... sorry.
I also now just spent 20 minutes looking at the 4.1 code.
4.1 arrays have to fit in a page, aren't multidimensional, and can't
be backed by large objects.
It appears, from looking at the older version of arrayfuncs.c
that as before the first 4 bytes is a 32 bit integer telling you
the total size of the array (as with any other varlena).
The array elements may be a fixed size of either 1,2,or4 bytes in
which case you can do the calculation easy enough, or it assumed
to be variable length, in which case you have to walk through
the array (as a sequence of varlena's).
I urge you in the strongest possible terms to upgrade to 4.2;
very large numbers of bugs were fixed, and the support for arrays
is much better and more flexible.
===============================================================================
To add/remove yourself from the POSTGRES mailing list: send mail with
the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"
If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
a human will deal with it. DO NOT post to the "postgres" mailing list.
===============================================================================
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: postgres@postgres.berkeley.edu
Cc: sklower@vangogh.CS.Berkeley.EDU, ren@math.ohio-state.edu
Subject: Re: About "Queries over variable sized arrays" too!
In-Reply-To: <199405132003.NAA13996@vangogh.CS.Berkeley.EDU>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox