no operator '=' for types char16 and text
don't you think there should be some sort of automatic conversion
here?
the charX types (char2, 4, 8, 16) are not well supported. They are
likely to disappear in the next release, with the parser mapping them to
char(X) (or varchar(X), whichever is the best match) for backward
compatibility.
The major string types are char(), varchar(), and text.
- Tom
Thus spake Thomas G. Lockhart
the charX types (char2, 4, 8, 16) are not well supported. They are
likely to disappear in the next release, with the parser mapping them to
char(X) (or varchar(X), whichever is the best match) for backward
compatibility.The major string types are char(), varchar(), and text.
Is there a performance hit if the values chosen are not powers of 2?
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.
Thus spake Thomas G. Lockhart
the charX types (char2, 4, 8, 16) are not well supported. They are
likely to disappear in the next release, with the parser mapping them to
char(X) (or varchar(X), whichever is the best match) for backward
compatibility.The major string types are char(), varchar(), and text.
Is there a performance hit if the values chosen are not powers of 2?
Nope.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)Thus spake Bruce Momjian
The major string types are char(), varchar(), and text.
Is there a performance hit if the values chosen are not powers of 2?
Nope.
Cool.
Except I'm a dinosaur and somehow it doesn't feel right if it isn't a
power of two. Oh well. :-)
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.
the charX types (char2, 4, 8, 16) are not well supported. They are
likely to disappear in the next release, with the parser mapping them to
char(X) (or varchar(X), whichever is the best match) for backward
compatibility.The major string types are char(), varchar(), and text.
Is there a performance hit if the values chosen are not powers of 2?
No, the smaller the better.
Andreas
Import Notes
Resolved by subject fallback
Thus spake Bruce Momjian
The major string types are char(), varchar(), and text.
Is there a performance hit if the values chosen are not powers of 2?
Nope.
Cool.
Except I'm a dinosaur and somehow it doesn't feel right if it isn't a
power of two. Oh well. :-)
That's what char2,char4, char8, and char16 are for.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)On Wed, 4 March 1998, at 11:01:16, Bruce Momjian wrote:
Thus spake Bruce Momjian
The major string types are char(), varchar(), and text.
Is there a performance hit if the values chosen are not powers of 2?
Nope.
Cool.
Except I'm a dinosaur and somehow it doesn't feel right if it isn't a
power of two. Oh well. :-)That's what char2,char4, char8, and char16 are for.
But these types are depreciated! :)
On Wed, 4 March 1998, at 11:01:16, Bruce Momjian wrote:
Thus spake Bruce Momjian
The major string types are char(), varchar(), and text.
Is there a performance hit if the values chosen are not powers of 2?
Nope.
Cool.
Except I'm a dinosaur and somehow it doesn't feel right if it isn't a
power of two. Oh well. :-)That's what char2,char4, char8, and char16 are for.
But these types are depreciated! :)
We can call it our "dinosaur"-compatability module. :-)
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)Thus spake Bruce Momjian
Except I'm a dinosaur and somehow it doesn't feel right if it isn't a
power of two. Oh well. :-)That's what char2,char4, char8, and char16 are for.
I thought that that was going away.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 424 2871 (DoD#0082) (eNTP) | what's for dinner.