Type conversion

From: Ice Planet <ice(at)adiemus(dot)sk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Type conversion
Date: 2000-06-20 19:24:48
Message-ID: SAK.2000.06.20.ogetqkls@adiemus
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-sql

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(at)adiemus(dot)sk
ICQ#: 67765483

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-06-20 19:48:45 Re: Type conversion
Previous Message Tom Lane 2000-06-20 18:16:53 Re: BETWEEN