Received: from trends.net (root@clio.trends.ca [209.47.148.2]) by hub.org
	(8.8.8/8.7.5) with ESMTP id TAA22017 for <pgsql-sql@postgreSQL.org>;
	Fri, 26 Jun 1998 19:51:46 -0400 (EDT)
Received: from linda.pathlink.com (linda.pathlink.com [205.185.79.6])
	by trends.net (8.8.8/8.8.8) with ESMTP id TAA24251
	for <pgsql-sql@postgreSQL.org>; Fri, 26 Jun 1998 19:51:44 -0400 (EDT)
Received: from dvl-1 (dvl-1.pathlink.com [204.30.237.241])
	by linda.pathlink.com (8.8.7/8.8.5) with SMTP
	id QAA03125; Fri, 26 Jun 1998 16:45:58 -0700 (PDT)
Message-Id: <3.0.1.32.19980626164554.006ac384@rr.pathlink.com>
X-Mailer: Windows Eudora Pro Version 3.0.1 (32)
Date: Fri, 26 Jun 1998 16:45:54 -0700
To: Colin Dick <cdick@mail.ocis.net>
From: Kachun Lee <kachun@pathlink.com>
Subject: Re: [SQL] Date fields and libpq....
Cc: pgsql-sql@postgreSQL.org
In-Reply-To: <Pine.LNX.3.96.980626161054.30350B-100000@ocis.ocis.net>
References: <3.0.1.32.19980626150540.006ab3dc@rr.pathlink.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 04:17 PM 6/26/98 -0700, you wrote:
>> It should be:
>> 
>>   select date_part(datetime(start),'epoch') from timebase;
>
>Hi,
>	What version of postgres are you running?  I have tried the above
>query and get the following result:
>
>WARN:func_get_detail: function date_part(datetime, unknown) does not exist
>
>Is this perhaps something that has been written specifically for your
>postgres or is it included in the latest version?  I am currently running
>version 6.1.....  Thanks again for your fast responses.
>
>--
>Colin Dick
>On Call Internet Services
>cdick@mail.ocis.net

Oops! Should have checked the manual first, it should be:

    select date_part('epoch', datetime(start)) from timebase

and I am using v6.3.2.