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
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 |