On Wed, 14 Aug 2002 17:56:16 +0530 "Sugandha Shah" <[EMAIL PROTECTED]> wrote:
> -- check for the exact same status string reported > -- previously and skip it if found > > select into last_status top 1 status, last_code status_code from >status_log where schedule_id =schedule_id order by complete_time desc ; PostgreSQL doesn't have a TOP keyword. You'll need to use a LIMIT keyword. See docs. http://www.postgresql.org/idocs/index.php?sql-select.html Regards, Masaru Sugawara ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
