X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 807FDD7FE7 for ; Thu, 6 Oct 2005 03:15:59 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 57085-01 for ; Thu, 6 Oct 2005 06:15:52 +0000 (GMT) Received: from mail.unika.ac.id (unknown [203.130.205.66]) by svr1.postgresql.org (Postfix) with SMTP id BE058DA338 for ; Thu, 6 Oct 2005 03:15:47 -0300 (ADT) Received: (qmail 18120 invoked by uid 507); 6 Oct 2005 11:54:40 +0700 Message-ID: <20051006045440.18119.qmail@mail.unika.ac.id> From: "dedy" To: "pgsql-admin@postgresql.org" Subject: faster or ..... ???? Date: Thu, 06 Oct 2005 11:54:40 +0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8" Content-Transfer-Encoding: 7bit X-Sender: slackman@unika.ac.id X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.365 required=5 tests=[AWL=-0.105, TO_ADDRESS_EQ_REAL=0.47] X-Spam-Level: X-Archive-Number: 200510/76 X-Sequence-Number: 19148 Hii all, I eould like to asking about creating table in postgres here is the 1> can postgres do such things like this one? # create table address as object(address varchar(100), post(6)); # create table id (id integer not null primary key, name char(100),address); now i will compare with this one >> # create table id (id integer not null primary key, name char(100)); # create table address (id integer not null references id, address varchar(100), post(6)); which is most faster??? Thank you very much for all your kind to answer my question and my english is so bad isn't? Dedy Styawan Semarang