On Wed, 1 Apr 1998, Thomas G. Lockhart wrote:
> > > tgl=> select extract (year from date 'now');
> > > date_part
> > > ---------
> > > 1998
> > > (1 row)
> > It doesn't work for me. Why ??
> > psql=> select extract (year from current_timestamp);
> > ERROR: function date_part(unknown, timestamp) does not exist
>
> What version of Postgres are you running? Something may have gone a
> little screwy in v6.3.1, since the numerology regression test has been
> reported to have failed with it unable to compare an int4 to a float8.
>
> It must work for some installations though since they wouldn't have
> released without a clean regression test, right? :)
>
> I'm still developing with v6.3 because I'm in the middle of working on
> the automatic type conversion stuff...
>
I I'm running version 6.3 and my regress.out is like this:
=============== Notes... =================
postmaster must already be running for the regression tests to succeed.
The time zone is now set to PST8PDT explicitly by this regression test
client frontend. Please report any apparent problems to
ports@postgresql.org
See regress/README for more information.
=============== destroying old regression database... =================
=============== creating new regression database... =================
=============== running regression queries... =================
boolean .. ok
char .. ok
char2 .. ok
char4 .. ok
char8 .. ok
char16 .. ok
varchar .. ok
text .. ok
strings .. ok
int2 .. ok
int4 .. ok
oid .. ok
oidint2 .. ok
oidint4 .. ok
oidname .. ok
float4 .. ok
float8 .. ok
numerology .. ok
point .. ok
lseg .. ok
box .. ok
path .. ok
polygon .. ok
circle .. ok
geometry .. failed
timespan .. ok
datetime .. ok
reltime .. ok
abstime .. ok
tinterval .. ok
horology .. ok
comments .. ok
create_function_1 .. ok
create_type .. ok
create_table .. ok
create_function_2 .. ok
constraints .. ok
triggers .. ok
copy .. ok
create_misc .. ok
create_aggregate .. ok
create_operator .. ok
create_view .. ok
create_index .. ok
sanity_check .. ok
errors .. ok
select .. ok
select_into .. ok
select_distinct .. ok
select_distinct_on .. ok
subselect .. ok
aggregates .. ok
transactions .. ok
random .. ok
portals .. ok
misc .. ok
arrays .. ok
btree_index .. ok
hash_index .. ok
select_views .. ok
alter_table .. ok
portals_p2 .. ok
Ciao, Jose'
