Received: from binarna.schizofrenia.sk (IDENT:root@binarna.schizofrenia.sk [195.98.10.23]) by hub.org (8.10.1/8.10.1) with ESMTP id e5KJQFM57184 for ; Tue, 20 Jun 2000 15:26:15 -0400 (EDT) Received: from adiemus ([195.28.79.5]) by binarna.schizofrenia.sk (8.9.0/8.9.0) with SMTP id UAA28582 for ; Tue, 20 Jun 2000 20:33:02 +0200 Message-Id: Date: Tue, 20 Jun 2000 21:24:48 +0200 X-Priority: 3 From: Ice Planet X-Mailer: Mail Warrior To: pgsql-sql@postgresql.org MIME-Version: 1.0 Subject: Type conversion Content-Type: Text/Plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8Bit X-Mailer-Version: v3.55 X-Archive-Number: 200006/184 Hello I have following situation create table t1 (a int8 primary key, b int8); create table t2 (x int2); insert into t1 values (1,1); A: insert into t2 values (select b from t1 where a = 1) B: insert into t2 values (select int2(int4(b)) from t1 where a = 1) Both possibilites fail, how can i do this insert??? Thanks for help Best regards Ice Planet e-mail: ice@adiemus.sk ICQ#: 67765483