Re: [SQL] Date Index

2008-11-03 Thread Ryan Hansen
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer Sent: Friday, October 31, 2008 1:49 AM To: pgsql-sql@postgresql.org Subject: Re: [SQL] Date Index am Thu, dem 30.10.2008, um 14:49:16 -0600 mailte Ryan Hansen folgendes: > Hey all, > > >

[SQL] Date Index

2008-10-30 Thread Ryan Hansen
Hey all, I'm apparently too lazy to figure this out on my own so maybe one of you can just make it easy on me. J I want to index a timestamp field but I only want the index to include the -mm-dd portion of the date, not the time. I figure this would be where the "expression" portion

[SQL] Full Text Index Stats

2008-10-20 Thread Ryan Hansen
Greetings, I couldn't find anything about this in the documentation or the mailing list archives, so forgive me if this has already been addressed. I'm trying to determine if the full text indexing has any built-in capability for providing information about word occurrence, i.e. the numbe