Re: Timestamp Error - 7.2 - Mailing list pgsql-sql

From Josh Berkus
Subject Re: Timestamp Error - 7.2
Date
Msg-id web-1660268@davinci.ethosmedia.com
Whole thread Raw
In response to Timestamp Error - 7.2  (Keith Gray <keith@heart.com.au>)
List pgsql-sql
Keith,

> We have moved from 7.1 to 7.2 and get the following error when
> extracting dates.
> 
> Bad timestamp external representation ' '
> 
> 
> eg. INSERT INTO mytable VALUES('1', '2001-09-24')

The error, as you have described it, is highly unlikely.   You will
need to provide more information if you still want help. Please:

1. Post table defintions.
2. Post your *actual* SQL statements which trigger the error, not
example ones which you have nto actually tested.

-Josh Berkus


pgsql-sql by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Is there a better way than this to get the start and end of a month?
Next
From: Tom Lane
Date:
Subject: Re: Getting current transaction id