Problem either with PostgreSQL or with PHP

From: Tuo Pe <tuo_pe(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Problem either with PostgreSQL or with PHP
Date: 2010-04-07 16:11:44
Message-ID: 96054.50959.qm@web50306.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I have written this function in PL/pgSQL,
CREATE OR REPLACE FUNCTION MakeSimpleReservation(integer, integer, integer, text, text) RETURNS boolean ...

In my PHP script, I have this code:
$start_ts = '2010-04-12 11:00:00';
$end_ts = '2010-04-12 14:00:00';

$update = pg_query($yhteys, "SELECT MakeSimpleReservation(2, 3, 1, '{$start_ts}' , '{$end_ts}');");

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.

For some reason, the last two function parameters are not recognized as strings. Is this a problem with PHP or with PostgreSQL? Can anyone give me advice how to fix this?

Tuo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-04-07 16:13:26 Re: Problem either with PostgreSQL or with PHP
Previous Message Marc Menem 2010-04-07 16:01:37 Re: cursors from pl/pgsql