Calling plSQL functions - Mailing list pgsql-sql

From Lonnie Cumberland
Subject Calling plSQL functions
Date
Msg-id 20010412041617.71469.qmail@web12506.mail.yahoo.com
Whole thread Raw
Responses Re: Calling plSQL functions
List pgsql-sql
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/


pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Timezone conversion
Next
From: "Josh Berkus"
Date:
Subject: Re: Calling plSQL functions