Problems Testing User-Defined Function
От | Rommel the iCeMAn |
---|---|
Тема | Problems Testing User-Defined Function |
Дата | |
Msg-id | 000001c68bff$828b5ad0$1264a8c0@theport.com обсуждение исходный текст |
Ответы |
Re: Problems Testing User-Defined Function
|
Список | pgsql-sql |
Hi list, I'm a newbie and I have a problem. I've defined the following function using pgAdmin but I am clueless as to how I can test it. I will eventually be calling this function from a .NET application but I want to test it using raw SQL first. Here's the function definition: CREATE OR REPLACE FUNCTION sp_insert_manifest(_sender varchar(255), _sender_email varchar(255), _reply_tovarchar(255), _filename varchar(255), _file oid, _datetime_sent timestamp) RETURNSinteger AS $$ -- blah blah -- $$ LANGUAGE plpgsql; I am trying to pass the following values to the function but I have been so far unsuccessful. SELECT sp_insert_manifest('me', me@you.com', 'me@you.com', 'test.txt', NULL, '2006/06/09') Can anyone help me here? Thanks, Rommel the iCeMAn.
В списке pgsql-sql по дате отправления: