From: Lonnie Cumberland <lonnie_cumberland@yahoo.com>
To: pgsql-sql@postgresql.org
Subject: Calling plSQL functions
Date: Wed, 11 Apr 2001 21:16:17 -0700 (PDT)
Message-ID: <20010412041617.71469.qmail@web12506.mail.yahoo.com> (raw)
Hello All,
I have created a plSQL function with the "create function ..." which seems to
be ok and is just very simple.
I then wanted to load the function by:
psql -f test.sql -d trdata
which loads my function fine.
the problem is that I do not know how to call this function from the PLSQL
interpreter.
I tried "select reg_user('name','age');"
but it just gives me an error about an unexpected "select ..."
I am writing some plSQL functions and also some "C" interface functions that I
want to load and then call from with the interpreter.
Any ideas?
cheers,
Lonnie
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: lonnie_cumberland@yahoo.com
Subject: Re: Calling plSQL functions
In-Reply-To: <20010412041617.71469.qmail@web12506.mail.yahoo.com>
References: <20010412041617.71469.qmail@web12506.mail.yahoo.com>
* 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