Re: EXCEPT doesn't compare TIMESTAMP type?

dipti shah, 23.04.2010 13:17:
> Thanks but I don't have text type in my table.
> sysdb=# \d changelogtest
> techdb=# INSERT INTO changelogtest (id, txid, txtime) values (5, 123, 'now')
> except select id, txid, txtime
> from changelogtest
> where id=5;

'now' *is* a text type value

Thomas