Postgres Pro
Downloads
Home   >   mailing lists

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

From Raymond O'Donnell
Subject Re: EXCEPT doesn't compare TIMESTAMP type?
Date
Msg-id 4BD1788E.9010204@iol.ie
Whole thread Raw
In response to EXCEPT doesn't compare TIMESTAMP type?  (dipti shah <shahdipti1980@gmail.com>)
Responses Re: EXCEPT doesn't compare TIMESTAMP type?
List pgsql-general
Tree view 
On 23/04/2010 11:31, dipti shah wrote:

> ERROR:  EXCEPT types text and timestamp without time zone cannot be matched
> LINE 2: except select id, txid, txtime

Try adding a cast to one of them.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: EXCEPT doesn't compare TIMESTAMP type?
Next
From: Morgan Taschuk
Date:
Subject: Re: PSQL segmentation fault after setting host