Postgres Pro
Downloads
Home   >   mailing lists

Re: timestamp field - select error - Mailing list pgsql-sql

From Tom Lane
Subject Re: timestamp field - select error
Date
Msg-id 3967.1053972532@sss.pgh.pa.us
Whole thread Raw
In response to timestamp field - select error  ("alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>)
Responses Re: timestamp field - select error  ("alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>)
List pgsql-sql
Tree view 
"alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br> writes:
> * But if I do: (...) where cf03dthr <= '2003-05-26' (...)
> * I get: "ERROR:  convert_timevalue_to_scalar: unsupported type 16976"

I could not reproduce this here.  If your column is actually of a domain
over timestamp, then you may need some post-7.3.2 bug fixes; see the
just-released 7.3.3.  Otherwise, please provide a self-contained test
case.
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to delete multiple rows from multiple joined tables
Next
From: "alexandre :: aldeia digital"
Date:
Subject: Re: timestamp field - select error