Tried your suggestion, but. . . .
=> create table seq_varchar (field1 varchar(4), field2 text, CONSTRAINT
pk_sq PRIMARY KEY (field1));
=> insert into seq_varchar values (NEXTVAL ( 'seq_test' )::text,
'blablabla');
ERROR: parser: attribute 'field1' is of type 'varchar' but expression is
of type 'text'
Is this a version or settings issue? We're not 6.4, I know that much. . .
Larry Bottorff SouthWind Internet Access, Inc.
System Programmer 120 S. Market St. Suite 300
swprenzl@southwind.net Wichita, KS 67202
---------------------------------------------------------------------
In Wichita:(316)263-7964 Elsewhere:1-877-525-7964