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: (view raw, whole thread or download thread mbox)
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 ;


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-2017 The PostgreSQL Global Development Group