Hi!
I am getting error when update with current_time.
----
bandwidth=> select * from dummy1;
esn|status|us|ds| tdate|time
---+------+--+--+----------+----
12|on |12|23|04-19-2001| 9
13|on |14|25|04-19-2001| 9
14|on |14|25|04-19-2001| 9
12|on |17|25|04-19-2001| 10
13|off |17|25|04-19-2001| 10
(5 rows)
bandwidth=> update dummy1 set time=current_time where esn=12;
ERROR: Attribute 'time' is of type 'varchar' but expression is of type 'time' You will need to rewrite or cast the expression.
Can You help me in this same.
Thanks in Advance!
Tulasi
I am getting error when update with current_time.
----
bandwidth=> select * from dummy1;
esn|status|us|ds| tdate|time
---+------+--+--+----------+----
12|on |12|23|04-19-2001| 9
13|on |14|25|04-19-2001| 9
14|on |14|25|04-19-2001| 9
12|on |17|25|04-19-2001| 10
13|off |17|25|04-19-2001| 10
(5 rows)
bandwidth=> update dummy1 set time=current_time where esn=12;
ERROR: Attribute 'time' is of type 'varchar' but expression is of type 'time' You will need to rewrite or cast the expression.
Can You help me in this same.
Thanks in Advance!
Tulasi