firebird-architect - Re: [IB-Architect] System table change

Subject	Re: [IB-Architect] System table change
Author	Olivier Mascia
Post date	2000-11-09T17:01:46Z

-----BEGIN PGP SIGNED MESSAGE-----

I understand your need Dalton.

I however wonder wether such bytes and bits manipulations are really
good additions to the server, not even taking into account the
addition of one or more new data types.

I'd vote for some well chosen and carefully crafted UDFs to be added
(to the default UDF library provided with the server).

Olivier

- ----- Original Message -----
From: "Dalton Calford" <dcalford@...>
To: <IB-Architect@egroups.com>
Sent: Thursday, November 09, 2000 12:35 PM
Subject: Re: [IB-Architect] System table change

> Hi Oliver,
>
> The only thing that I would want to be able to do is extract any
> element out of the binary array and manipulate it.
> That includes casting it to a ASCII equivalent, or XOR'ing it with
> another binary element.
> Left and Right Shift Mathmatics as well. (although multiplying or
> dividing it by 2 works just as well)
> The thing here is, anything we do should be able to be done in
> SP/Trigger code.
> If we use the OCTET subtype, we are limiting our manipulation to
> client side unless we also create a series of UDF's to handle the
> manipulation.
>
> I do not mind the idea of making the UDF's as long as we all agree
> to the format and what exactly needs to be done.
>
> best regards
>
> Dalton