By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,906 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

can you use variables in PostgreSQL rules?

P: n/a
i am currently migrating a db from Oracle to Pg and in some of my
triggers i use variables, i.e. i have some thing like this:



[Oracle version]



CREATE OR REPLACE TRIGGER "USERACTION_VIEW" INSTEAD OF INSERT ON
"USERACTION_VIEW" DECLARE

UserActionID INTEGER;

UserActionDataID INTEGER;

begin

SELECT USERACTION_SQ.nextval into UserActionID FROM DUAL;

SELECT USERACTIONDATA_SQ.nextval into UserActionDataID FROM DUAL;



INSERT INTO USERACTION

(

UserActionID,

LocalID,

UserActionTypeID,

ActionDate

)

VALUES

(

UserActionID,

:new.LocalID,

:new.UserActionTypeID,

SYSDATE

);



INSERT INTO USERACTIONDATA

(

UserActionDataID,

UserActionID,

AccountID,

CourseRecordID,

CourseRecordPaymentID,

StudentID,

CourseRecordTestID,

CourseRecordLessonID

)

VALUES

(

UserActionDataID,

UserActionID,

:new.AccountID,

:new.CourseRecordID,

:new.CourseRecordPaymentID,

:new.StudentID,

:new.CourseRecordTestID,

:new.CourseRecordLessonID

);



end;





so basically i have two variables here, UserActionID and
UserActionDataID. so when i am porting to PostgreSQL i will need to make
this a rule since Pg triggers only work for tables. The problem though
is that i don't know how to use variabvles in Pg rules. Any ideas? Is it
possible at all?



Thanks.
Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.