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

2003-11-21 Thread Christoph Haller
> > 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" > <[

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