From: | "Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar(dot)Pyatalo(at)honeywell(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | help on looping through query results - urgent !!! |
Date: | 2004-08-02 07:23:23 |
Message-ID: | 77ED2BF75D59D1439F90412CC5B109740FA65148@ie10-sahara.hiso.honeywell.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi all,
In want to write a function PP_ReadPoints() for my project. I have 2 related
tables....
Point(PointId,CreateTime,TechnicalAddress,PointType,Area);
PointHistory(PointId,Flag);
I have written a trigger such that when i insert a tuple into Point table, a
tuple with the same PointId will be inserted into PointHistory table with
Flag set to 0 as default.
Now from my application i keep calling the PP_ReadPoints() function every 60
seconds. This function has to check for the first 10 tuples in PointHistory
table with Flag=0 and if 0, should retrieve data from Point table and return
the data. Now i need some assistance in doing this as i am very new to
PostgreSQL.
> With Best Regards
> Pradeep Kumar P J
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2004-08-02 08:19:03 | Re: Help on triggers |
Previous Message | Pradeepkumar, Pyatalo (IE10) | 2004-08-02 05:33:28 | error in compiling the function -- need help !!! |