From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | windwxc(at)sina(dot)com |
Cc: | pgus-general(at)postgresql(dot)org |
Subject: | Re: about complex type |
Date: | 2008-04-03 02:31:53 |
Message-ID: | 20080402193153.4d6121fe@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgus-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Thu, 03 Apr 2008 10:10:24 +0800
windwxc(at)sina(dot)com wrote:
Hello,
This is off topic for this list. Please try pgsql-novice or
pgsql-general.
Thanks,
Sincerely,
Joshua D. Drake
> hi, now i meet a question about the complex field. Firstly i create a
> complex type (the sql is "CREATE TYPE test11 as (area numeric,
> address character varying(30))")and then i create a table ,set a
> field named "tt" whose type is test11. Now i want insert the data
> which select from another talble yantian_2005 into the tt of test1.
> but i try some SQL and always failure. so i wish you can tell me how
> to do .The following is my sql and their error. (1)select
> (eid,address,area1,marea,shape_area,shape_len,the_geom,gid)into
> table1 from yantian_2005 where gid=2 ERROR: column "row" has
> pseudo-type record (2)insert into test1(tt)select
> row(yantian_2005.address, yantian_2005.area1 )from yantian_2005 where
> gid=3; ERROR: cannot cast type record to test11 (3)select Row
> (yantian_2005.address,yantian_2005.area1)::{tt} into table1 from
> yantian_2005 where gid=2 ERROR: syntax error at or near "{"
> LINE 1: ...ct Row (yantian_2005.address,yantian_2005.area1)::{tt}
> into ... please tell me how to do. my postgresql is 8.2 and system is
> windows XP.
>
> wuxiaochun
>
> -------------------------------------------------------------------
> 外企高薪职位急聘( http://d1.sina.com.cn/sina/limeng3/mail_zhuiyu/2008/mail_zhuiyu_20080331.html )
>
> -------------------------------------------------------------------
> 注册新浪2G免费邮箱(http://mail.sina.com.cn/)
- --
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFH9EGZATb/zqfZUUQRAnrjAKCS8NPNk/AdqwTs6bgp5zt9xRQQ+QCeNB5f
JdJpnrEZ3lY7asDRJGQpYXc=
=ygx5
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2008-04-04 17:36:46 | Quick update on the 1023 |
Previous Message | windwxc | 2008-04-03 02:10:24 | about complex type |