Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have a trigger on it, I'd like to iterate
through
On Fri, 27 Oct 2006, Ferindo Middleton wrote:
Is there a way to loop through individual query records within a stored
procedure or trigger. If I have table called client_names (id SERIAL, first
name TEXT, middlename TEXT, lastname TEXT, suffix TEXT, pet_id INT,
properly_trained TEXT) and I have
I'm trying to do a select statement where:
field targetApp equals the value acadreg and
field accessed equals the value Y and
filed enteredQue is like 2004-11-09 18% the whole enterqueue
fieild is something like 2004-11-09 16:00:34
Here's what I'm trying to accomplish, I want to get all
How about
SELECT * FROM queLog
WHERE accessed = Y
AND targetApp = acadreg
AND enteredQue = '2004-11-09 18:00:00';
(You said greater than first, then you said greater than or equal to. I
went with the latter.)
Michael
Kory Wheatley wrote:
I'm trying to do a select statement where:
field