From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Jose Soares Da Silva <sferac(at)bo(dot)nettuno(dot)it> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] Re: [DOCS] Reference Manual |
Date: | 1998-04-01 16:08:30 |
Message-ID: | 3522667E.8B821829@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > 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...
- Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-04-01 16:10:26 | Re: [HACKERS] Memory leak while creating indices? |
Previous Message | Bruce Momjian | 1998-04-01 16:02:47 | Re: [PORTS] Port Bug Report: int2 negative numbers not parsed correctly |