The following seems to work, but I don't feel confident this is really
the correct code:
CREATE RULE shoe_upd AS
ON UPDATE TO shoe
DO INSTEAD (
UPDATE shoes
SET sh_name = NEW.sh_name, sh_avail = NEW.sh_avail
WHERE shoes.sh_id = NEW.sh_id;
INSERT INTO shoelaces (sh_id, sl_na
On Sat, Jun 13, 2009 at 12:12 AM, Erik Jones wrote:
>
> On Jun 9, 2009, at 10:51 AM, Rob Sargent wrote:
>
>> Caching helps a *lot* and I'm thankful for that but I would like to take
>> it out of the picture as I massage my queries for better performance.
>> Naturally the first invocation of the qu
On Jun 9, 2009, at 10:51 AM, Rob Sargent wrote:
Caching helps a *lot* and I'm thankful for that but I would like to
take it out of the picture as I massage my queries for better
performance. Naturally the first invocation of the query cannot
take advantage of the cache and these queries w
Hi,
I'm taking a first foray into writing rules, and am struggling with one
for a view that has a left joined table:
------
CREATE TABLE shoes (
sh_id serial PRIMARY KEY,
sh_name text,
sh_avail integer
);
Dobro Vece,
smth like:
SELECT a.user_id,a.action_mark,a.action_time,a.action_time-
(select a2.action_time from actions a2 where a2.oid=
(select a3.oid from actions a3 where a3.user_id=a.user_id and
a3.action_mark='BEGIN' and
a3.action_time I have a table where there are
I have a table where there are actinos for some user logged. It's part
of the MPI system of some sort. For every user, action type and time of
the action is logged. There are many action types but the ones which are
of interest to me are BEGIN and END. I need to find the durations for
all the p
On 2009-06-10, johnf wrote:
> Hi,
> I'm am programming in python using the Dabo modules. www.dabodev.com if your
> interested. Dabo is a framework that provides an easy way to build desktop
> app's. To clear a data entry form. I have been setting the where clause
> to "where 1=0". This of c
