[SQL] missing... at end of sql expression

2004-11-21 Thread Justine . Cleary
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! CREATE FUNCTION exp101 () RETURNS text AS ' DECLARE -- Declare a variable to hold book titles and

Re: [SQL] missing... at end of sql expression

2004-11-21 Thread Tom Lane
[EMAIL PROTECTED] 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

Re: [SQL] missing... at end of sql expression

2004-11-21 Thread Michael Fuhr
On Thu, Nov 18, 2004 at 12:28:03PM -0700, [EMAIL PROTECTED] wrote: --row_data enrollment%ROWTYPE; --row_dataa student%ROWTYPE; Your loop variables are commented out. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)---