Postgres Pro
Downloads
Home   >   mailing lists

Re: EXCEPT doesn't compare TIMESTAMP type? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: EXCEPT doesn't compare TIMESTAMP type?
Date
Msg-id hqs0nt$g8v$1@dough.gmane.org
Whole thread Raw
In response to Re: EXCEPT doesn't compare TIMESTAMP type?  (dipti shah <shahdipti1980@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: dipti shah
Date:
Subject: Re: EXCEPT doesn't compare TIMESTAMP type?
Next
From: Alexandr Popov
Date:
Subject: Re: EXCEPT doesn't compare TIMESTAMP type?