ll it.
I suppose you have to use TG_OP variable in your triggers. Here is a
bit from documentation:
--
TG_OP
Datatype text; a string of 'INSERT', 'UPDATE' or 'DELETE' telling for which
operation the
trigger is actually fired.
-
So, you can type something about
if TG_OP <> 'UPDATE' then
... ops for insert only
else
... ops for update only
end if;
... ops for both of them
--
Anatoly K. Lasareff Email: [EMAIL PROTECTED]
h a select)
MH> e.g. (this would be nice if it worked (networkID is the PKey))
MH> INSERT into Network (parentID, networkName) values (pid, mname);
MH> netid := new.networkID;
Yes. 'serial' type implements as 'int' type for field and sequence,
which mane is __se
anyone tell where did I make a mistake?
fb> I have a linux on a PC.
Pehaps not 'int', but 'int4' in argument and return type? Except this
I think your example is right.
--
Anatoly K. Lasareff Email: [EMAIL PROTECTED]
Senior programmer
':
the_time timestamp NOT NULL CONSTRAINT df_now DEFAULT (timestamp('now'::datetime))
s> And one more question: How does one construct a foreign key relationship in
s> postgres?
In 6.4 there are no really 'primary ney - foreign key' constraint. If
you wont have this feature you must use 'refint' from postgres
contribs.
--
Anatoly K. Lasareff Email: [EMAIL PROTECTED]
Senior programmer
where tag = 3;
revoke all on a from public;
grant select on v1 to user1, user2...;
grant select on v2 to group gr1, ...;
. . .
--
Anatoly K. Lasareff Email: [EMAIL PROTECTED]
Senior programmer
nature 'xxx() returns opaque', but
not '... returns int'. Pehaps this is your mistake?
--
Anatoly K. Lasareff Email: [EMAIL PROTECTED]
Senior programmer
,field2,link1 from test1,test2 where test1.link1=test2.id2
union
select id1, -1, link1 from test1;
where -1 is value non present in field2 domain.
--
Anatoly K. Lasareff Email: [EMAIL PROTECTED]
Senior programmer
| i
+--
Thu Nov 26 00:00:00 1998 MSK| 1
Wed Nov 25 00:00:00 1998 MSK| 2
Fri Nov 27 00:00:00 1998 MSK| 3
|10
(4 rows)
--
Regards!
--
Anatoly K. Lasareff Email: [EMAIL PROTECTED]
Senior programmer
