Re: =???UTF-8?Q?re: How to insert .xls...

> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Adrian Klaver
>
> Dates don't transfer correctly. When I try it the date moves
> two days ahead.

I just checked it, on my computer it works fine, no date shift.

Regards

Tomas

>
>From pgsql-general-owner(at)postgresql(dot)org Thu Jul 13 17:52:54 2006
X-Original-To: pgsql-general-postgresql(dot)org(at)postgresql(dot)org
Received: from localhost (mx1.hub.org [200.46.208.251])
by postgresql.org (Postfix) with ESMTP id 739E79FB2AC
for <pgsql-general-postgresql(dot)org(at)postgresql(dot)org>; Thu, 13 Jul 2006 17:52:53 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
with ESMTP id 61550-05 for <pgsql-general-postgresql(dot)org(at)postgresql(dot)org>;
Thu, 13 Jul 2006 17:52:43 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.116.145.2])
by postgresql.org (Postfix) with ESMTP id 947899FA5E9
for <pgsql-general(at)postgresql(dot)org>; Thu, 13 Jul 2006 17:52:43 -0300 (ADT)
Received: by floppy.pyrenet.fr (Postfix, from userid 106)
id 7FD1A30BA1; Thu, 13 Jul 2006 22:52:42 +0200 (MET DST)
From: Joseph Shraibman <jks(at)selectacast(dot)net>
X-Newsgroups: pgsql.general
Subject: How come index isn't being used when query by function return value?
Date: Thu, 13 Jul 2006 16:52:41 -0400
Organization: Hub.Org Networking Services
Lines: 27
Message-ID: <e96bql$blk$1(at)news(dot)hub(dot)org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet(at)news(dot)hub(dot)org
User-Agent: Thunderbird 1.5.0.4 (X11/20060614)
To: pgsql-general(at)postgresql(dot)org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/549
X-Sequence-Number: 98173

db:db=>explain select * from elog where id = eds('2006-01-01');
QUERY PLAN
-------------------------------------------------------------------------------------------
Seq Scan on elog (cost=0.00..1894975.10 rows=1 width=204)
Filter: (id = eds('2006-01-01 00:00:00'::timestamp without time zone))
(2 rows)

db:db=>explain select * from elog, (select eds('2006-01-01') as trg) aa
where id = trg;
QUERY PLAN
--------------------------------------------------------------------------------------
Nested Loop (cost=0.00..4.36 rows=1 width=208)
-> Subquery Scan aa (cost=0.00..0.02 rows=1 width=4)
-> Result (cost=0.00..0.01 rows=1 width=0)
-> Index Scan using elog_pkey on elog (cost=0.00..4.33 rows=1
width=204)
Index Cond: (elog.id = "outer".trg)
(5 rows)

Time: 0.978 ms
db:db=>select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.8 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 3.4.4 20050721 (Red Hat 3.4.4-2)
(1 row)