Received: from rhea.arexim.ro (root@mail.arexim.ro [193.230.225.5]) by hub.org (8.9.1/8.9.1) with ESMTP id LAA16970 for ; Thu, 7 Jan 1999 11:08:51 -0500 (EST) (envelope-from george@flex.ro) Received: from arexim.arexim.ro (root@arexim.arexim.ro [193.230.225.2] (may be forged)) by rhea.arexim.ro (8.9.0/8.9.0) with ESMTP id TAA24520; Thu, 7 Jan 1999 19:09:39 +0200 Received: from flex.ro ([193.230.255.93]) by arexim.arexim.ro (8.7.5/8.7.3) with ESMTP id TAA18093; Thu, 7 Jan 1999 19:09:09 +0200 Sender: gestoc@arexim.ro Message-ID: <3694DBB4.CCF4DB9D@flex.ro> Date: Thu, 07 Jan 1999 18:07:16 +0200 From: George Moga X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i586) MIME-Version: 1.0 To: Larry Bottorff , SQL PostgreSQL Subject: Re: [SQL] int4 to varchar conversion References: Content-Type: multipart/alternative; boundary="------------D304A8C4F27BA5FC53DD7B07" --------------D304A8C4F27BA5FC53DD7B07 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Larry Bottorff wrote: > I'm doing something very typical: I created a sequence "seq" and then > wanted to insert the NEXTVAL('seq') into a varchar field of a table to be > used as a primary key. > > INSERT INTO products (prodno, ...) VALUES (NEXTVAL('seq'), 'blah', > 'blah'); > > Where prodno is varchar. I tried a text(...) cast, but it complains of a > text-varchar mismatch. There is no varchar(...). > > Apparently, this is not possible in Postgres(?). > > 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 try: INSERT INTO products (prodno, ...) VALUES (NEXTVAL('seq')::text, 'blah', ...); Example: test=>CREATE TABLE seq_varchar (field1 varchar(4), field2 text, primary key (field1)); NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index var_pkey for table var CREATE test=>CREATE SEQUENCE seq_test; test=>INSERT INTO seq_varchar VALUES (NEXTVAL ( 'seq_test' )::text, 'blablabla'); INSERT 741504 1 test=>SELECT * FROM seq_varchar; field1|field2 ------+--------- 1|blablabla (1 row) test=>INSERT INTO seq_varchar VALUES (NEXTVAL ( 'seq_test' )::text, 'blahblahblah'); INSERT 741505 1 test=>SELECT * FROM seq_varchar; field1|field2 ------+------------ 1|blablabla 2|blahblahblah (2 rows) -- Best, George Moga, george@flex.ro george@cicnet.ro Braila, ROMANIA --------------D304A8C4F27BA5FC53DD7B07 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Larry Bottorff wrote:
I'm doing something very typical: I created a sequence "seq" and then
wanted to insert the NEXTVAL('seq') into a varchar field of a table to be
used as a primary key.

INSERT INTO products (prodno, ...) VALUES (NEXTVAL('seq'), 'blah',
'blah');

Where prodno is varchar. I tried a text(...) cast, but it complains of a
text-varchar mismatch. There is no varchar(...).

Apparently, this is not possible in Postgres(?).

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


try:

INSERT INTO products (prodno, ...) VALUES (NEXTVAL('seq')::text, 'blah', ...);
 

Example:

test=>CREATE TABLE seq_varchar (field1 varchar(4), field2 text, primary key (field1));
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index var_pkey for table var
CREATE
test=>CREATE SEQUENCE seq_test;
test=>INSERT INTO seq_varchar VALUES (NEXTVAL ( 'seq_test' )::text, 'blablabla');
INSERT 741504 1
test=>SELECT * FROM seq_varchar;
field1|field2
------+---------
     1|blablabla
(1 row)

test=>INSERT INTO seq_varchar VALUES (NEXTVAL ( 'seq_test' )::text, 'blahblahblah');
INSERT 741505 1
test=>SELECT * FROM seq_varchar;
field1|field2
------+------------
     1|blablabla
     2|blahblahblah
(2 rows)

-- 
Best,
        George Moga,
        george@flex.ro
        george@cicnet.ro
        Braila, ROMANIA --------------D304A8C4F27BA5FC53DD7B07--