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(at)candle(dot)pha(dot)pa(dot)us