Skip site navigation (1) Skip section navigation (2)

Question Regarding Procedural Function (store procedure)

From: b t <qtboyzz(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Question Regarding Procedural Function (store procedure)
Date: 2005-02-17 02:11:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
Hi, first of all thanks for taking the time to read my message. I'm new to Sql and is very confuse of how to write a procedural function. I want to write a function that check if the data is aready in the table then it should not add to the table instead of linking it to the table. This is what I mean, I have a movies table and a stars table and a stars_in_movies (this table keep track of the stars in what movies). So I'm suppose to write a store procedure that add the movie to the database, if there is a star in the new movies then is already exist in the stars table then it should link that star to the new movie.
thanks in advance

Do you Yahoo!?
 Yahoo! Mail - Find what you need with new enhanced search. Learn more.


pgsql-interfaces by date

Next:From: Bruno Wolff IIIDate: 2005-02-17 17:03:46
Subject: Re: Question Regarding Procedural Function (store procedure)
Previous:From: Janet BorschowaDate: 2005-02-17 00:50:26
Subject: Re: Help with returning data type

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group