X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E1BB332A146 for ; Wed, 20 Oct 2004 23:03:36 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55063-04 for ; Wed, 20 Oct 2004 22:03:27 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.205]) by svr1.postgresql.org (Postfix) with ESMTP id AE494329F3B for ; Wed, 20 Oct 2004 23:03:27 +0100 (BST) Received: by mproxy.gmail.com with SMTP id 79so476903rnk for ; Wed, 20 Oct 2004 15:03:22 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding; b=nTUKDoTlGTy9PV0He3F9mECF+DtFO/CfOgbGMU1QrVlNA9My8vr3IAQeJ1sQNi1oiuKxyqMLbVmGfsAHEDA9ElocdwbKoHQIRCYUN3OIMJQ+beiR5PbbzVXBikwOEOr7r1NblZS+W9PLNxNx24odnwkSy04ow0HkCR+/gC+zPZs Received: by 10.38.83.9 with SMTP id g9mr2638517rnb; Wed, 20 Oct 2004 15:03:22 -0700 (PDT) Received: by 10.38.78.31 with HTTP; Wed, 20 Oct 2004 15:03:22 -0700 (PDT) Message-ID: <4f6940a604102015034e5560bb@mail.gmail.com> Date: Wed, 20 Oct 2004 15:03:22 -0700 From: Gifford Hesketh Reply-To: Gifford Hesketh To: pgsql-sql@postgresql.org Subject: "copy from" in "create function" Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200410/172 X-Sequence-Number: 19275 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;