Re: EXCEPT doesn't compare TIMESTAMP type?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: EXCEPT doesn't compare TIMESTAMP type?
Date: 2010-04-23 11:36:29
Message-ID: hqs0nt$g8v$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexandr Popov 2010-04-23 11:39:46 Re: EXCEPT doesn't compare TIMESTAMP type?
Previous Message dipti shah 2010-04-23 11:17:32 Re: EXCEPT doesn't compare TIMESTAMP type?