Re: INSERT FOLLOW WITH OTHER INSERT

Are you ready to solve your problem using a trigger and 'plpgsql'
function ?? .. 

then proceed ..



trigger :)

+++++++++++++++++++++++++++++++++++++++++++
CREATE TRIGGER trigger_student_club
before INSERT OR UPDATE
ON students
FOR EACH ROW
EXECUTE PROCEDURE ins_student_club_func();
+++++++++++++++++++++++++++++++++++++++++++



function :)

+++++++++++++++++++++++++++++++++++++++++++
CREATE FUNCTION ins_student_club_func()RETURNS OPAQUEAS          'BEGIN     INSERT INTO student_club(student_id) VALUES
                           (new.student_id);    return new;    END;'
 
LANGUAGE 'plpgsql';
+++++++++++++++++++++++++++++++++++++++++++

Hope it works.  :)

Regards,
Bhuvaneswar.

On Aug 9, Johny Jugianto wrote:

> hi all
> 
> i have a table like this 
> 
> CREATE SEQUENCE seq_student_id INCREMENT 1 START 1;
> CREATE TABLE students (
>   student_id INT4 NOT NULL DEFAULT
> NEXTVAL('seq_student_id'),
>   student_name text,
>   student_address text,
>   primary key(student_id)
> )
> CREATE TABLE student_club (
>   student_id INT4 NOT NULL;
>   club_id INT4,
>   CONSTRAINT student_id_update FOREIGN KEY(student_id)
> REFERENCES students(student_id) ON UPDATE CASCADE
> )
> 
> my question is how i can make auto insert student_id
> on table student_club when i insert into table
> students
> 
> example:
> INSERT INTO students(student_name) VALUES('Willy');
> 
> table STUDENT
> student_id | name    | address
> ---------------------------------
> 1          | Willy    |
> 
> and on TABLE student_club
> student_id | club_id
> --------------------
> 1          |
> 
> 
> i have trying with create rule and with
> check_foreign_key, but i haven't found solution.
> anyone can help me?
> 
> Thanks in advance
> 
> 
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>