On Wed, Jun 18, 2008 at 2:00 PM, Roberto Garcia
<roberto.garcia@cptec.inpe.br> wrote:
> Just to mention one issue we had here:
>
> In 8.1 we did this to retrieve all data from a specific date:
> SELECT * FROM xxx
> WHERE <timestamp_column> LIKE '2008-05-20%'
>
> In 8.3 we had to change to:
> SELECT * FROM xxx
> WHERE <timestamp_column> >= CAST('2008-05-20' as timestamp) AND
> <timestamp_column> < CAST('2008-05-21' as timestamp)
Also, don't forget that bareword numbers don't automatically cast to
text anymore.
For instance, assuming col is a text type (char, varchar, text), the query
select * from table where col = 1000
Will throw an error in 8.3 whereas it will work under pre-8.3
releases. You can one either of the following to make it work.
select * from table where col = 1000::text
select * from table where col = '1000'
I've been bitten by that bug a few times.
Peter