Re: [GENERAL] dunction issue

2008-03-29 Thread Craig Ringer
Sam Mason wrote: Occasionally, though, I do have something where the DB-using app must just submit a request to the DB and see if it works. Either the UI doesn't have the privileges to run the same checks its self, or they're just too expensive to do from the client (or to do twice). In those

Re: [GENERAL] dunction issue

2008-03-28 Thread Sam Mason
On Sat, Mar 29, 2008 at 04:05:15AM +0900, Craig Ringer wrote: > Sam Mason wrote: > >>ALTER TABLE tmp_newsletterreg ADD CONSTRAINT simplistic_email_check > >>CHECK lower(trim(both ' ' from email)) LIKE '[EMAIL PROTECTED]'; > > > >Just out of interest, what's the lower() function call doing? > > Abs

Re: [GENERAL] dunction issue

2008-03-28 Thread Craig Ringer
Sam Mason wrote: ALTER TABLE tmp_newsletterreg ADD CONSTRAINT simplistic_email_check CHECK lower(trim(both ' ' from email)) LIKE '[EMAIL PROTECTED]'; Just out of interest, what's the lower() function call doing? Absolutely nothing. That's what I get for reading my mail at stupid-o-clo

Re: [GENERAL] dunction issue

2008-03-28 Thread Sam Mason
On Fri, Mar 28, 2008 at 06:43:00PM +0900, Craig Ringer wrote: > Alain Roger wrote: > > I do not agree with you Sam. > > > > Stored procedure are safe from hacking (from external access). > > In that a stored procedure encapsulates a series of data operations, > meaning that the client doesn't hav

Re: [GENERAL] dunction issue

2008-03-28 Thread Craig Ringer
Alain Roger wrote: > I do not agree with you Sam. > > Stored procedure are safe from hacking (from external access). In that a stored procedure encapsulates a series of data operations, meaning that the client doesn't have to know the details or even have privileges to run the individual operatio

Re: [GENERAL] dunction issue

2008-03-28 Thread Alain Roger
I do not agree with you Sam. Stored procedure are safe from hacking (from external access). >From my point of view transitions should be used only as internal purpose or via intrAnet and not thru intErnet. at list this is how under MS SQL they use to teach. regarding unique constraint, i already

Re: [GENERAL] dunction issue

2008-03-27 Thread Sam Mason
On Thu, Mar 27, 2008 at 03:34:49PM -0700, Adrian Klaver wrote: > Or a simpler way to do handle my previous suggestion: > > IF (ret_email IS NULL ) OR (ret_email='') THEN > RETURN ('-3') That would be the sane fix, yes. Based on the previous emails from the OP, he seems to be missing a lot

Re: [GENERAL] dunction issue

2008-03-27 Thread Adrian Klaver
On Thursday 27 March 2008 3:17 pm, Sam Mason wrote: > On Thu, Mar 27, 2008 at 08:43:46PM +0100, Alain Roger wrote: > > i have a problem solving my function trouble. > > this function should return an email address stored in a table > > (tmp_newsletterreg) based on a number (sessions ID). > > if the

Re: [GENERAL] dunction issue

2008-03-27 Thread Sam Mason
On Thu, Mar 27, 2008 at 08:43:46PM +0100, Alain Roger wrote: > i have a problem solving my function trouble. > this function should return an email address stored in a table > (tmp_newsletterreg) based on a number (sessions ID). > if the session id is not find it should return a string correspondin

Re: [GENERAL] dunction issue

2008-03-27 Thread Adrian Klaver
-- Original message -- From: "Alain Roger" <[EMAIL PROTECTED]> > Hi, > > i have a problem solving my function trouble. > this function should return an email address stored in a table > (tmp_newsletterreg) based on a number (sessions ID). > if the session id is