Thread: Help: insert inheritance class

Help: insert inheritance class

From
"Weon-sun Lee"
Date:
Hi there,

I'm create two classes. I'm sucess insert data into super class.

I want know how do I insert inherits class. Thanx.

First class

CREATE SEQUENCE auth_user_rowid;

CREATE TABLE auth_user (
    "_rowid"    int4,
    "uid"        text,
    "username" text,
    "password" text,
    "perms"    text );

INSERT INTO "auth_user" VALUES(nextval('auth_user_rowid'),
'aciefd90453092jfdaks','1022','Members');

this query is sucess....


CREATE TABLE members (
     "stat" text,
     "address" text,
     "telephone" text,
     "pcsphone" text,
     "homepage" text,
     "email" text,
     "comment" text,
     "changed" text) INHERITS( auth_user );

How do I insert data to members table ?