Re: [SQL] int4 to varchar conversion - Mailing list pgsql-sql

From Larry Bottorff
Subject Re: [SQL] int4 to varchar conversion
Date
Msg-id Pine.BSI.4.02A.9901071103050.5260-100000@jasper.southwind.net
Whole thread Raw
In response to Re: [SQL] int4 to varchar conversion  (George Moga <george@flex.ro>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: George Moga
Date:
Subject: Re: [SQL] int4 to varchar conversion
Next
From: Kim Markle
Date:
Subject: Postgres functions and Stored Procedures?