Could you please post the exact string how you did?
Thanks
Deepak
On Thu, Apr 29, 2010 at 12:59 AM, Edward Ross wrote:
> Tom Lane wrote:
>
>> Edward Ross writes:
>>
>>> Here is a sandbox example of what I mean.
>>>
>>
>> CREATE TABLE test_0
>>> (
>>>string_value varchar(2047),
>>>time
Tom Lane wrote:
Edward Ross writes:
Here is a sandbox example of what I mean.
CREATE TABLE test_0
(
string_value varchar(2047),
timestamp_value timestamp with time zone
);
insert into test_0
(string_value)
values
('2010-03-12 17:06:21-0800'),
('2009-08-14
Edward Ross writes:
> Here is a sandbox example of what I mean.
> CREATE TABLE test_0
> (
> string_value varchar(2047),
> timestamp_value timestamp with time zone
> );
> insert into test_0
>(string_value)
> values
>('2010-03-12 17:06:21-0800'),
>('2009-08-14 1
Hi,
I have a table with varchar and timestamp with time zone columns, among
others. Insertions into this table are usually done by a java program;
and there are many tens of thousands of records in the table.
Recently, after changes in the java software, many timestamps values
inadvertently
