Re: parser: parse error at or near "$1" - Mailing list pgsql-sql

On Wed, 14 Aug 2002 17:56:16 +0530
"Sugandha Shah" <Sugandhas@cybage.com> 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