Postgres Pro
Downloads
Home   >   mailing lists

v7.0.2: can't use 'EXTRACT(EPOCH FROM' - Mailing list pgsql-bugs

From Trevin Chow
Subject v7.0.2: can't use 'EXTRACT(EPOCH FROM'
Date
Msg-id 20010731002256.H15708-100000@benny.geektank.org
Whole thread Raw
Responses Re: v7.0.2: can't use 'EXTRACT(EPOCH FROM'
List pgsql-bugs
Tree view 
I'm running postgres 7.0.3 on one machine and 7.1.2 on another.  I tried
running the exact SQL sample from the user manual for date time
functions:

SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');

This example won't run on the v7.0.3 and I get teh following error:

ERROR:  parser: parse error at or near "epoch"

However, the same SQL sample runs on v7.1.2.  Am I doing something wrong
here? Is this a known bug?

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Odpověď: Re: backend don't use index whenquerying by indexed column
Next
From: Wolfgang Winkler
Date:
Subject: locale and german umlauts