Re: varchar() troubles

> Pretty sure only after but it's hard to tell for sure. My trees for 971204
> and 971222 both core dump on inserts to varchar, but I can't remember what
> else I was doing with the trees at the time. v6.2.1p5 works OK on this:
>
> postgres=> create table t (v varchar(80),i int);
> CREATE
> postgres=> insert into t values ('hi',1);
> INSERT 142735 1
> postgres=> select * from t;
> v |i
> --+-
> hi|1
> (1 row)

I am working on it.  Look at this:

    test=> create table t15 (x varchar(7),x1 int, x2 int, x3 int)
    test-> ;
    CREATE
    test=> insert into t15 values ('as',1,2,3);
    INSERT 143436 1
    test=> select * from t15;
    x |x1|x2|x3
    --+--+--+--
    as| 2| 3| 0
    (1 row)

Srange, huh?

--
Bruce Momjian
maillist@candle.pha.pa.us