Horton
Menu

Thread

  1. no operator '=' for types char16 and text

    Brett McCormick <brett@work.chicken.org> — 1998-03-03T21:43:33Z

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

  2. Re: [HACKERS] no operator '=' for types char16 and text

    Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-03-04T03:05:12Z

    > 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

  3. Re: [HACKERS] no operator '=' for types char16 and text

    D'Arcy Cain <darcy@druid.net> — 1998-03-04T03:12:12Z

    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.

  4. Re: [HACKERS] no operator '=' for types char16 and text

    Bruce Momjian <maillist@candle.pha.pa.us> — 1998-03-04T03:35:53Z

    > 
> 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)

  5. Re: [HACKERS] no operator '=' for types char16 and text

    D'Arcy Cain <darcy@druid.net> — 1998-03-04T04:23:25Z

    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.

  6. Re: [HACKERS] no operator '=' for types char16 and text

    Bruce Momjian <maillist@candle.pha.pa.us> — 1998-03-04T16:01:16Z

    > 
> 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)

  7. Re: [HACKERS] no operator '=' for types char16 and text

    Brett McCormick <brett@work.chicken.org> — 1998-03-04T17:26:36Z

    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! :)

  8. Re: [HACKERS] no operator '=' for types char16 and text

    Bruce Momjian <maillist@candle.pha.pa.us> — 1998-03-04T18:23:38Z

    > 
> 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)

  9. Re: [HACKERS] no operator '=' for types char16 and text

    D'Arcy Cain <darcy@druid.net> — 1998-03-04T21:57:06Z

    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.