Re: BIT datatype (Fixed)
Hi,
here is an updated version of the bit type with a bugfix and all the necessary
SQL functions defined. This should replace what is currently in contrib. I'd
appreciate any comments on what is there.
Kind regards,
Adriaan
Attachments:
Import Notes
Reference msg id not found: 20000330135203.A4162@fam-meskes.deReference msg id not found: 38E36251.69A58897@albourne.comReference msg id not found: 38E39A65.EF53005C@alumni.caltech.edu
Applied.
Hi,
here is an updated version of the bit type with a bugfix and all the necessary
SQL functions defined. This should replace what is currently in contrib. I'd
appreciate any comments on what is there.Kind regards,
Adriaan
[Attachment, skipping...]
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
here is an updated version of the bit type with a bugfix and all the necessary
SQL functions defined. This should replace what is currently in contrib. I'd
appreciate any comments on what is there.I'm hoping to get a chance to look at it fairly soon. It's already
been committed to the tree...
The bits never even got cold before it was applied. :-)
--
Bruce Momjian | http://www.op.net/~candle
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Import Notes
Reply to msg id not found: 38EA0045.586D6036@alumni.caltech.edu | Resolved by subject fallback
here is an updated version of the bit type with a bugfix and all the necessary
SQL functions defined. This should replace what is currently in contrib. I'd
appreciate any comments on what is there.
I'm hoping to get a chance to look at it fairly soon. It's already
been committed to the tree...
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California
Import Notes
Reference msg id not found: 20000330135203.A4162@fam-meskes.deReference msg id not found: 38E36251.69A58897@albourne.comReference msg id not found: 38E39A65.EF53005C@alumni.caltech.edu
Bruce Momjian wrote:
here is an updated version of the bit type with a bugfix and all the necessary
SQL functions defined. This should replace what is currently in contrib. I'd
appreciate any comments on what is there.I'm hoping to get a chance to look at it fairly soon. It's already
been committed to the tree...The bits never even got cold before it was applied. :-)
Thanks! I spent a day with a debugger to find a silly error, but it all does seem to
behave now. I could not use the name BIT for the example type, as it is reserved. I also
noticed that I could not use BITS(6) for a user-defined type to specify a length. A last
problem is that there are two types of output routines, one returning a bit string in hex
format, and another returning it in binary format. I seem to recall that there once was a
discussion on adding a C-string type for situations like this, so that one output-type
would be the default, but the second could be made available through a function. I also
didn't do anything to make these indexable.
Any suggestions or complaints, please let me know.
Adriaan