unsubsribe pgsql-admin
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Hi ,
I made an attempt to dump and reload my 7.3.4 into 7.4b3 following were
the issues i faced , some solved and some unsolved. I used the piped method
for the data transfer , so its not possible to manually edit the sql script.
7.4b3 pg_dumpall and 7.4b3 psql was used for dumping and restore.
10:12a
Dear all,
This is about the same problem which I have been facing for the past one week and
which I am unable to solve.
I have create a function which return +1 of the argument passed.
Function Definition:
CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
BEGIN
RETURN $1 +
On Mon, 22 Sep 2003 [EMAIL PROTECTED] wrote:
> Dear all,
> This is about the same problem which I have been facing for the past one week and
> which I am unable to solve.
> I have create a function which return +1 of the argument passed.
> Function Definition:
> CREATE FUNCTION add_one (integer)
Command: psql test -c "> CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
BEGIN REURN $1 + 1; END; ' LANGUAGE 'plpgsql';"
Result: CREATE FUNCTION
And the function executed perfectly fine.
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalor
On Mon, 22 Sep 2003 [EMAIL PROTECTED] wrote:
> Command: psql test -c "> CREATE FUNCTION add_one (integer) RETURNS
> INTEGER AS ' BEGIN REURN $1 + 1; END; ' LANGUAGE
> 'plpgsql';"
You do realize that the shell is going to interpret that string in
double quotes right?
---
>You do realize that the shell is going to interpret that string in
>double quotes right?
I guess so, for the very same I have tried with
Command: psql test -c "> CREATE FUNCTION add_one (integer) RETURNS
INTEGER AS ' BEGIN RETURN ''$1'' + 1; END; ' LANGUAGE
'plpgsql';"
But still
