Jonathan Ellis wrote:
First, you don't give enough context to see where your python code
generates a timestamp, but in any case it's more of a limitation than a
bug that plpython doesn't try to autoconvert certain datatypes. (Are
you even returning a datetime class, or a string?)
I gave
Hello!
create or replace function trigger_keywords_maintain() returns trigger as $$
return 'MODIFY'
$$ language plpythonu;
update table set id = id where id = 7;
ERROR: invalid input syntax for type timestamp: 2005-05-03
14:07:33,279213
I see that Python's timestamp format is
Mage wrote:
create or replace function trigger_keywords_maintain() returns
trigger as $$
return 'MODIFY'
$$ language plpythonu;
update table set id = id where id = 7;
ERROR: invalid input syntax for type timestamp: 2005-05-03
14:07:33,279213
I see that Python's timestamp format is