| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
| Cc: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: plpgsql |
| Date: | 2003-10-20 17:29:33 |
| Message-ID: | 5646.1066670973@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> writes:
>> Line 2 of the function is not where your assignment is; there seems to
>> be something wrong with your first variable declaration.
> Great! I don't understand why I started putting tabs. The first 4 functions
> have spaces between the variable name and the type.
Okay. I've improved the error reporting here for 7.4. CVS tip now does
regression=# create function foo() returns int as '
regression'# declare
regression'# xyzint;
regression'# begin
regression'# ...
regression'# end' language plpgsql;
CREATE FUNCTION
regression=# select foo();
ERROR: invalid type name ""
CONTEXT: compile of PL/pgSQL function "foo" near line 2
which should be at least a little less confusing ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Murthy Kambhampaty | 2003-10-20 17:32:41 | Re: Recomended FS |
| Previous Message | scott.marlowe | 2003-10-20 17:28:37 | Re: Recomended FS |