Skip site navigation (1) Skip section navigation (2)

Re: missing... at end of sql expression

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justine(dot)Cleary(at)c1data(dot)com
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: missing... at end of sql expression
Date: 2004-11-22 01:03:33
Message-ID: 1449.1101085413@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
Justine(dot)Cleary(at)c1data(dot)com writes:
> I am trying to learn pspgsql but I am not having a lot of luck.
 
> I have written a function but I keep getting the error missing... at end of
> sql expression. Can anyone help!

What it's really unhappy about is that you failed to declare the FOR
variable; this is causing it to assume that the FOR is the integer
variant (FOR i IN low .. high).

The error message is pretty confusing, I agree.  I think 8.0 will
do better.

			regards, tom lane

In response to

pgsql-sql by date

Next:From: Michael FuhrDate: 2004-11-22 01:09:18
Subject: Re: missing... at end of sql expression
Previous:From: André ToscanoDate: 2004-11-21 23:07:48
Subject: Functions return a select in a table, which data type I must use? (Brazilian User)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group