August 7th, 2003, 02:48 AM
how can i use delete in postgresql
how can i use delete in postgresql WITH PHP??
i have used for example
<delete from "table name" where "auto id" ="3";>
but when i execute this it is giving a problem
the errror is Attribute not found
can any one help me?????????????
August 7th, 2003, 07:36 AM
Double quotes are for attribute names, single quotes are for string literals (values). In your case, you should be using single quotes (or none at all since it's numeric) around the 3. Because it's double quoted, the engine thinks you are referring to a field named 3, not the value 3.