Re: Trigger on Postgres for tables syncronization
От | Robby Russell |
---|---|
Тема | Re: Trigger on Postgres for tables syncronization |
Дата | |
Msg-id | 1090988402.2532.0.camel@vacant обсуждение исходный текст |
Ответ на | Re: Trigger on Postgres for tables syncronization (Prabu Subroto <prabu_subroto@yahoo.com>) |
Список | pgsql-general |
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@ecircle-ag.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@planetargon.com 503.351.4730 | blog.planetargon.com
В списке pgsql-general по дате отправления: