Re: [SQL] Expressional Indexes

2003-11-20 Thread Tom Lane
"Randolf Richardson, DevNet SysOp 29" <[EMAIL PROTECTED]> writes: > For the application I will need to develop in the future, it would be > okay for this index to hold data more than 30 days old, and then be > redefined on a monthly basis along with regular database vacuuming (and > other

Re: [SQL] FATAL 2: PageIndexTupleDelete

2003-11-20 Thread cristi
Yes, you right! I used pg_dump command and now is working. Thank you very much! PS. I have version 7.2.2 on RH 8.0 > > FATAL 2: PageIndexTupleDelete: corrupted page pointers: lower =3D 12289, up= > > per =3D > > 1, special =3D 60672 > > > Why do I have this error message and how can I fix it? > >

Re: [SQL] Need another way to do this, my sql much to slow...

2003-11-20 Thread Jerry Wintrode
Ok, I figured that part out by simply changing the way I'm doing to query, and writing a function to handle the reply. But it will introduce another problem. How to I pass special characters, any character, to a function like this: select msg_2_env('"Ann's Free Gifts & Coupons" <[EMAIL PROTECTED

Re: [SQL] Need another way to do this, my sql much to slow...

2003-11-20 Thread Jerry Wintrode
Let me give you a better dataset: msg_sender_num | env_sender_num + 118 | 53003 118 | 51778 118 | 49679 118 | 49457 118 | 37434 118 | 3738

Re: [SQL] Need another way to do this, my sql much to slow...

2003-11-20 Thread Christoph Haller
> > I am attempting to write a spam management add-on for my corporate > server, I have the database and the apps written but one part is WAY to > slow to be usefull. > > The following view: > > Column | Type | Modifiers > ---+-+--- > env_send

[SQL] Need another way to do this, my sql much to slow...

2003-11-20 Thread Jerry Wintrode
I am attempting to write a spam management add-on for my corporate server, I have the database and the apps written but one part is WAY to slow to be usefull. The following view: Column | Type | Modifiers ---+-+--- env_sender_num| in