From: b t <qtboyzz@yahoo.com>
To: pgsql-interfaces@postgresql.org
Subject: Question Regarding Procedural Function (store procedure)
Date: Wed, 16 Feb 2005 18:11:16 -0800 (PST)
Message-ID: <20050217021116.777.qmail@web61009.mail.yahoo.com> (raw)
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
-brian
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search. Learn more.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: qtboyzz@yahoo.com
Subject: Re: Question Regarding Procedural Function (store procedure)
In-Reply-To: <20050217021116.777.qmail@web61009.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox