
don't you think there should be some sort of automatic conversion
here?

Tue,  3 Mar 1998 13:43:33 -0800 (PST)
Brett McCormick <brett@work.chicken.org>
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


Wed, 04 Mar 1998 03:05:12 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] no operator '=' for types char16 and text
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.

Tue, 3 Mar 1998 22:12:12 -0500 (EST)
darcy@druid.net (D'Arcy J.M. Cain)
Re: [HACKERS] no operator '=' for types char16 and text
> 
> 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)

Tue, 3 Mar 1998 22:35:53 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] no operator '=' for types char16 and text
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.

Tue, 3 Mar 1998 23:23:25 -0500 (EST)
darcy@druid.net (D'Arcy J.M. Cain)
Re: [HACKERS] no operator '=' for types char16 and text
> 
> 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)

Wed, 4 Mar 1998 11:01:16 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] no operator '=' for types char16 and text
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! :)

Wed,  4 Mar 1998 09:26:36 -0800 (PST)
Brett McCormick <brett@work.chicken.org>
Re: [HACKERS] no operator '=' for types char16 and text
> 
> 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)

Wed, 4 Mar 1998 13:23:38 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] no operator '=' for types char16 and text
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.

Wed, 4 Mar 1998 16:57:06 -0500 (EST)
darcy@druid.net (D'Arcy J.M. Cain)
Re: [HACKERS] no operator '=' for types char16 and text