On 10/20/2004 6:03 PM, Gifford Hesketh wrote:
> Am I forgetting some limitation ? I get "ERROR: syntax error at or
> near "$1" at character 22" with this:
>
> CREATE FUNCTION public.fn_b_import( text ) RETURNS void AS
> '
> COPY b_import FROM $1 ;
> '
> LANGUAGE 'sql' STABLE;
Utility statements don't accept parameters for arguments. Use the
EXECUTE syntax of PL/pgSQL for this.
Jan
--
#=========================================================== ===========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck [at] Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
