Re: Trigger on Postgres for tables syncronization

It's becomes an object in the server, like a table. It doesn't go away
unless you DROP it.

-Robby

On Tue, 2004-07-27 at 07:09, Prabu Subroto wrote:
> And if I restart the postgres server, does the view
> "appointment0" and view "appointment1" still exist?
>
> Sorry for my further question. And thank you for your
> responds..
>
> I am looking forward to your further explanation.
> --- Csaba Nagy <nagy(at)ecircle-ag(dot)com> wrote:
> > Prabu,
> >
> > Views show you the exact content of the table(s)
> > they are built upon,
> > filtered by some conditions.
> > Just try to create appointment0 and appointment1
> > like this:
> >
> > CREATE VIEW appointment0 AS SELECT * FROM
> > appointment WHERE done = 'Y';
> >
> > CREATE VIEW appointment1 AS SELECT * FROM
> > appointment WHERE done = 'N';
> >
> > Now you can use appointment0 and appointment1 for
> > selects exactly as you
> > would use any other table, and they will show you
> > exactly the data in
> > appointment, filtered by the values of the "done"
> > column.
> >
> > If you still don't understand how all this works,
> > then you should take
> > an SQL tutorial and read up on views.
> > In any case you should read the postgres
> > documentation which is quite
> > good:
> > http://www.postgresql.org/docs/7.4/static/index.html
> >
> >
> > HTH,
> > Csaba.
> >
> >
> > On Tue, 2004-07-27 at 15:35, Prabu Subroto wrote:
> > > But I think, the modification of records to the
> > table
> > > "appointment0" dan "appointment1" must be done
> > > automatically if my program modifies the
> > > "appointment". That's why I think I should use
> > trigger
> > > and function.
> > >
> > > Please tell me more detail.
> >
> >
> >
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!
> http://promotions.yahoo.com/new_mail
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Robby Russell | Owner.Developer.Geek
PLANET ARGON | www.planetargon.com
Portland, OR | robby(at)planetargon(dot)com
503.351.4730 | blog.planetargon.com