Re: faster or ..... ????

dedy wrote:
> Hii all,
> I eould like to asking about creating table in postgres

Koq belum ada yg jawab - pada kurang ngerti, kali, Mas :).

> here is the
> 1> can postgres do such things like this one?
>  # create table address as object(address varchar(100), post(6));

post varchar(6), maksudnya, kan? But why the "as object" business - what
do you expect it to do?

>  # 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));

Sudah lihat

http://www.postgresql.org/docs/8.0/interactive/sql-createtable.html

belum? For clarity, you're probably better off mentioning both the table
and column in the references constraint. And what's post, again? Is it a
type, or is it a mistyped varchar?

By the way, there isn't usually much point to using varchar(), char()
etc - just use text; PostgreSQL always stores text efficiently, whatever
length it is.

> which is most faster???

Faster for what, exactly? It's not clear (to me...) what you think the
difference between your two alternatives is, except that the first one
doesn't look like it has any hope of being understood by the database. Eg:

mus=# create table address as object(address varchar(100), post(6));
ERROR:  syntax error at or near "object" at character 25
LINE 1: create table address as object(address varchar(100), post(6)...
                                 ^


> Thank you very much for all your kind to answer my question
> and my english is so bad isn't?

Bahasa Inggrisnya lumayan, dong, cuma bahasa SQL yg wajar diragukan ;-).

> Dedy Styawan
> Semarang

Tim

--
-----------------------------------------------
Tim Allen          tim@proximity.com.au
Proximity Pty Ltd  http://www.proximity.com.au/