Skip site navigation (1) Skip section navigation (2)

"copy from" in "create function"

From: Gifford Hesketh <gifford(dot)hesketh(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: "copy from" in "create function"
Date: 2004-10-20 22:03:22
Message-ID: 4f6940a604102015034e5560bb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-sql
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;

Responses

pgsql-sql by date

Next:From: IainDate: 2004-10-21 01:31:00
Subject: Re: Reuse previously calculated column in sql query?
Previous:From: Stephan SzaboDate: 2004-10-20 16:56:03
Subject: Re: time of constraint checking

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group