Обсуждение: no operator '=' for types char16 and text
don't you think there should be some sort of automatic conversion here?
> 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.
> > 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.