Timestamp Update with PHP
От | Timothy J Hitchens |
---|---|
Тема | Timestamp Update with PHP |
Дата | |
Msg-id | DGEBJCBBIECKHBIGFEJHAEMKGBAA.tim@hitcho.com.au обсуждение исходный текст |
Список | pgsql-interfaces |
I am having trouble updating a timestamp field inside my database whenever I use the normal udpate xyz set x = now() etc etc I get must use case I use cast and I get a ph error for the =... ERROR: Unable to identify an operator '=' for types 'bpchar' and 'numeric' You will have to retype this query usingan explicit cast Does anyone have an example of an update for a timestamp field using php. I am really trying to use this with PHP and everytime I updated the record because of a certain state I update the timestamp field. Thanks.. Timothy Hitchens (Hitcho) Web Evangelist/Technologist Voice: +61 7 3396 3500 Fax: +61 7 3396 2633 Cell: +61 419 521 440 SMS: tim.sms@hitcho.com.au (subject only) E-Mail: tim@hitcho.com.au URL: http://www.hitcho.com.au/ ------------------------------------------------- "Everyone is born into this world with two things freewill and potential what we do from then on is totally up to us. Let's all start today and make a difference in this world." -------------------------------------------------
В списке pgsql-interfaces по дате отправления: