Re: SQL Script

Kevin Willems writes:

> I have written the following function but when I try to run it, I get Error:
> ERROR: parser: parse error at or near "". As you can see, there is no
> instance of "" in my function. Does anyone have any idea why this is
> happening?

"" means 'empty string', which often indicates end of input.

>
> CREATE FUNCTION dropifexists(text)
> RETURNS text
> AS 'DECLARE
> numcount integer;
> nameoftable text;
> BEGIN
> nameoftable := lower($1);
> SELECT INTO numcount count(tablename)
> FROM pg_tables
> WHERE tablename = nameoftable;
>
> if numcount = 1
> then DROP TABLE nameoftable;
> end if;
> RETURN nameoftable;
> END;'

You're missing LANGUAGE '...' here.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/

From pgsql-general-owner(at)postgresql(dot)org Sun Apr 1 06:44:32 2001