postgres date retrieval difficulties

[Anon]

I am having difficulties retrieving a date value from a postgres database. I can get reults displayed for all other fields in the database, but the message "bad column offset specified..." occurs on the line where i try and obtain the date value.

thanks in advance.

$result=pg_Exec($conn, "SELECT * FROM exception");

$num = pg_NumRows($result);

for ($i=0; $i<$num; $i++) {
$cdate = pg_Result($result, $i, "date");
$cdescription = trim(pg_Result($result, $i, "comments"));

echo "Date: $cdate;";
echo "<br>Result: $cresult;";
}

[Anon]

You might want to look at your SELECT statement. Either you failed to cut and paste properly, or you are missing a semicolon

$result=pg_Exec($conn, "SELECT * FROM exception;");

not ");