SQL Script
| От | Kevin Willems |
|---|---|
| Тема | SQL Script |
| Дата | |
| Msg-id | Hz4x6.1028$Tfq.8978590@tomcat.sk.sympatico.ca обсуждение исходный текст |
| Ответы |
Re: SQL Script
Re: SQL Script |
| Список | pgsql-general |
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? 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;'
В списке pgsql-general по дате отправления: