Re: [SQL] Problems Testing User-Defined Function

2006-06-10 Thread Tom Lane
"Rommel the iCeMAn" <[EMAIL PROTECTED]> writes: > Thanks for the input so far. No it wasn't a direct paste, what I did in fact > type was SELECT sp_insert_manifest('me', '[EMAIL PROTECTED]', '[EMAIL > PROTECTED]', > 'test.txt', NULL, '2006/06/09'). The error message said something like > function

Re: [SQL] Problems Testing User-Defined Function

2006-06-09 Thread Rommel the iCeMAn
Hi guys, Thanks for the input so far. No it wasn't a direct paste, what I did in fact type was SELECT sp_insert_manifest('me', '[EMAIL PROTECTED]', '[EMAIL PROTECTED]', 'test.txt', NULL, '2006/06/09'). The error message said something like function sp_insert_manifest(character varying, character

Re: [SQL] Problems Testing User-Defined Function

2006-06-09 Thread Jim Buttafuoco
"PostgreSQL SQL Mailing List" Sent: Fri, 9 Jun 2006 16:01:26 -0400 Subject: [SQL] Problems Testing User-Defined Function > 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.

Re: [SQL] Problems Testing User-Defined Function

2006-06-09 Thread George Weaver
- Original Message - From: "Rommel the iCeMAn" <[EMAIL PROTECTED]> I am trying to pass the following values to the function but I have been so far unsuccessful. What error message are you receiving? SELECT sp_insert_manifest('me', [EMAIL PROTECTED]', '[EMAIL PROTECTED]', 'test.t

[SQL] Problems Testing User-Defined Function

2006-06-09 Thread Rommel the iCeMAn
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 REPLAC