Re: [SQL] parse error at or near "(" -- Huh???

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 sc

Re: [SQL] [NOVICE] Indexing Strategy

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 se