Re: parser: parse error at or near "$1"

From: Masaru Sugawara <rk73(at)sea(dot)plala(dot)or(dot)jp>
To: "Sugandha Shah" <Sugandhas(at)cybage(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: parser: parse error at or near "$1"
Date: 2002-08-14 13:21:50
Message-ID: 20020814221050.C853.RK73@sea.plala.or.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, 14 Aug 2002 17:56:16 +0530
"Sugandha Shah" <Sugandhas(at)cybage(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2002-08-14 13:34:16 Re: Few Queries
Previous Message Oliver Elphick 2002-08-14 13:10:46 Re: Few Queries