Calling plSQL functions

Поиск
Список
Период
Сортировка
От Lonnie Cumberland
Тема Calling plSQL functions
Дата
Msg-id 20010412041617.71469.qmail@web12506.mail.yahoo.com
обсуждение исходный текст
Ответы Re: Calling plSQL functions  ("Josh Berkus" <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Roberto Mello
Дата:
Сообщение: Timezone conversion
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: Calling plSQL functions