| From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Keith Gray <keith(at)heart(dot)com(dot)au>, SQL PostgreSQL <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Timestamp Error - 7.2 |
| Date: | 2002-09-25 16:13:21 |
| Message-ID: | web-1660268@davinci.ethosmedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Boulgakov Andrei | 2002-09-25 16:18:34 | Is it possible to use lo_write in SQL? |
| Previous Message | Dmitry Tkach | 2002-09-25 14:39:44 | Re: Is there a better way than this to get the start and end of a month? |