Re: [SQL] int4 to varchar conversion

From: Larry Bottorff <swprenzl(at)southwind(dot)net>
To: George Moga <george(at)flex(dot)ro>
Cc: SQL PostgreSQL <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] int4 to varchar conversion
Date: 1999-01-07 17:06:52
Message-ID: Pine.BSI.4.02A.9901071103050.5260-100000@jasper.southwind.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)southwind(dot)net Wichita, KS 67202
---------------------------------------------------------------------
In Wichita:(316)263-7964 Elsewhere:1-877-525-7964

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Kim Markle 1999-01-07 17:44:45 Postgres functions and Stored Procedures?
Previous Message George Moga 1999-01-07 16:07:16 Re: [SQL] int4 to varchar conversion