From: | Charles Bai <charlesbaiusa(at)yahoo(dot)com> |
---|---|
To: | Jaime Casanova <systemguards(at)gmail(dot)com> |
Cc: | postgre sql- <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: how to test a PL/pgSQL function using pgAdmin III ? |
Date: | 2005-11-23 16:03:11 |
Message-ID: | 20051123160311.18472.qmail@web31903.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Works like a charm, thank you, Jaime.
Charles
Jaime Casanova <systemguards(at)gmail(dot)com> wrote:
On 11/23/05, Charles Bai wrote:
> Hi,
>
> I created a plpgsql function in pgAdmin III and it will insert a record into
> a table. I am not ready to test it with my App. Can I test it first with
> pgAdmin III Query window? What would be the syntax to test it?
>
> My function is myuser_insert(varchar, varchar)
>
> I tried
>
> Execute myuser_insert('mylogin_id', 'mypassword');
>
> But not working. ERROR: prepared statement "myuser_insert" does not exist
>
> Thanks for any help.
>
use "select myuser_insert('mylogin_id', 'mypassword');" instead
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.
From | Date | Subject | |
---|---|---|---|
Next Message | flavio | 2005-11-23 16:47:17 | How Can I use OO concepts? |
Previous Message | Jaime Casanova | 2005-11-23 15:26:09 | Re: how to test a PL/pgSQL function using pgAdmin III ? |