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 448CF56814
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 15 Mar 2005 04:25:59 +0000 (GMT)
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 82759-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue, 15 Mar 2005 04:25:55 +0000 (GMT)
Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158])
	by svr1.postgresql.org (Postfix) with ESMTP id DD08D56819
	for <pgsql-sql@postgresql.org>; Tue, 15 Mar 2005 04:25:51 +0000 (GMT)
Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1])
	by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j2F4PePZ020129
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK);
	Mon, 14 Mar 2005 21:25:42 -0700 (MST)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: from winnie.fuhr.org (localhost [127.0.0.1])
	by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j2F4Pewp060370;
	Mon, 14 Mar 2005 21:25:40 -0700 (MST)
	(envelope-from mfuhr@winnie.fuhr.org)
Received: (from mfuhr@localhost)
	by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j2F4Pd0Q060369;
	Mon, 14 Mar 2005 21:25:39 -0700 (MST) (envelope-from mfuhr)
Date: Mon, 14 Mar 2005 21:25:39 -0700
From: Michael Fuhr <mike@fuhr.org>
To: Timothy Smith <timothy@open-networks.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: postgresql 8.01, plpgsql
Message-ID: <20050315042539.GA60320@winnie.fuhr.org>
References: <42363BD1.6090405@open-networks.net>
	<20050315024104.GA59736@winnie.fuhr.org>
	<42365898.3020904@open-networks.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42365898.3020904@open-networks.net>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200503/207
X-Sequence-Number: 20686

On Tue, Mar 15, 2005 at 01:38:00PM +1000, Timothy Smith wrote:

> ok i tried loading it from a file like you suggested and this is what i 
> got for MY function
> 
> \i /home/timothy/function
> psql:/home/timothy/function:35: ERROR:  unterminated dollar-quoted 
> string at or near "$$

Could you attach the files you're reading?  It might be helpful if
we could see everything you're trying to execute.

What version of PostgreSQL are you using?  Presumably 8.X since
you're using dollar quoting.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/