What does the following error mean?
Warning: PostgreSQL query failed: ERROR: Unable to identify an operator '=' for types 'int4' and 'text' You will have to retype this
query using an explicit cast in /home/www/site.com/htdocs/store/process.php on line 8
Here's the table layout...
Table "orders"
Attribute | Type | Modifier
-----------+---------+---------------------------------------------------------
order_id | integer | not null default nextval('"orders_order_id_seq"'::text)
b_email | text |
Index: orders_pkey
And here's the sql insert statement
$sql_order = "INSERT INTO orders(b_email) VALUES('$b_email');";
$result = pg_Exec($connection, $sql_order);
Thanks,
Steven