From: Michael Fuhr <mike@fuhr.org>
To: Dinesh Pandey <dpandey@secf.com>
Cc: pgsql-general@postgresql.org
Subject: Re: "pltcl" function.
Date: Mon, 18 Apr 2005 22:50:17 -0600
Message-ID: <20050419045017.GB76187@winnie.fuhr.org> (raw)
In-Reply-To: <20050418063520.D9018538C1@svr1.postgresql.org>
References: <20050418063520.D9018538C1@svr1.postgresql.org>
On Mon, Apr 18, 2005 at 12:01:58PM +0530, Dinesh Pandey wrote:
>
> What is error in this statement of "pltcl" function.
>
> set var 'SENDING EMAIL TO: '||$mailto||' from: '||$mailfrom||' with:
> '||$emailserver
>
> I am getting this error:
>
> ERROR: wrong # args: should be "set varName ?newValue?"
You're mixing languages: you're using the SQL concatenation operator
(||) in a Tcl function. See a Tcl reference for the details of Tcl
syntax. The following should work:
set var "SENDING EMAIL TO: $mailto from: $mailfrom with: $emailserver"
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, dpandey@secf.com, pgsql-general@postgresql.org
Subject: Re: "pltcl" function.
In-Reply-To: <20050419045017.GB76187@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox