Tuo Pe <tuo_pe@xxxxxxxxx> writes: > I have written this function in PL/pgSQL, > CREATE OR REPLACE FUNCTION MakeSimpleReservation(integer, integer, integer, text, text) RETURNS boolean ... > On psql, I can run a command such as > select * from MakeSimpleReservation(2, 30, 1, '2010-04-12 11:00:00', '2010-04-12 14:00:00'); > without any problems, but when I try to run it via PHP, I get this error message: > ERROR: function makesimplereservation(integer, integer, integer, unknown, unknown) does not exist LINE 1: SELECT MakeSimpleReservation(2, 3, 1, '2010-04-12 11:00:00' ... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. Hmm. That function should match that call. Are you sure php is connecting to the same database you created the function in? Or maybe you created the function in a schema that is not in the php client's search_path? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
