Navigation

Changeset 3d20bc1379d600f43cfd1385da58f12c1f448d15 for sql

Timestamp:

11/03/10 20:38:14 (3 years ago)

Author:

Theo Schlossnagle <jesus@omniti.com>

git-committer:

Theo Schlossnagle <jesus@omniti.com> 1288816694 +0000

git-parent:

[dbd0c9dbeda6f50b3591b96efc2de01c606c0d25]

git-author:

Theo Schlossnagle <jesus@omniti.com> 1288816694 +0000

Message:

fix the fetch of the check to be the most recent

Files:

r4a0968d	r3d20bc1
17	17	v_fts_data tsvector;
18	18	BEGIN
19		SELECT sid, module, name, target FROM check_archive WHERE sid=in_sid INTO ref_sid,ref_module,ref_name,ref_target;
	19	SELECT sid, module, name, target FROM check_archive WHERE sid=in_sid
	20	ORDER BY whence DESC LIMIT 1 INTO ref_sid,ref_module,ref_name,ref_target;
20	21	IF NOT FOUND THEN
21	22	RETURN NULL;