Matthew,
select * from quote where sybmol = 'MSFT' and extract(doy from time) = 340
order by time
Aha, that should be easy.
CREATE INDEX quote_doy_symbol ON quote ( (extract(doy from time)), symbol );
The reason that I'm putting the DOY first is because it's liable to be
slightly more
On Sun, 12 Dec 2004 19:18:00 -0700, Michael Fuhr [EMAIL PROTECTED] wrote:
On Thu, Dec 09, 2004 at 03:19:56PM -0500, Alex Beamish wrote:
I'm getting a frustrating error
ERROR: parser: parse error at or near ( at character 201
in a CREATE TABLE statement from an SQL script that I'm