error creating sql function
От | Matthew T. O'Connor |
---|---|
Тема | error creating sql function |
Дата | |
Msg-id | 400890D1.7070408@zeut.net обсуждение исходный текст |
Ответы |
Re: error creating sql function
Re: error creating sql function |
Список | pgsql-general |
I was trying to create a sql function today (see below) using postgresql 7.3.3. I don't see how to get around this error, anyone have any suggestions? Thanks much, Matthew tocr=# CREATE OR REPLACE FUNCTION public.update_dncl(bpchar, bpchar) tocr-# RETURNS void AS tocr-# ' tocr'# begin; tocr'# update area_codes tocr'# set last_updated = now() tocr'# where code = $1; tocr'# DELETE from do_not_call_list tocr'# where area_code = $1; tocr'# copy do_not_call_list (area_code, number) from $2 with delimiter as \',\'; tocr'# commit; tocr'# ' tocr-# LANGUAGE 'sql' VOLATILE; ERROR: parser: parse error at or near "$2" at character 178 tocr=# COMMENT ON FUNCTION public.update_dncl(bpchar, bpchar) IS 'Will be used to update an area code in the DNCL tables.'; COMMENT tocr=# SELECT version(); version --------------------------------------------------------------------------------------------------------- PostgreSQL 7.3.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2 20020903 (Red Hat Linux 8.0 3.2-7) (1 row)
В списке pgsql-general по дате отправления: