Re: [GENERAL] md5 function

2003-12-18 Thread Reece Hart
On Wed, 2003-12-17 at 06:30, Jon Earle wrote: Is there a way to, when I add a record to a table, have the md5 hash computed and stored in the same table and then returned to the calling program? I recommend that you write a trigger to compute the md5 and shove that into a column. There are

Re: [GENERAL] md5 function

2003-12-17 Thread Marek Lewczuk
Miso Hlavac wrote: Hello, Sorry for just stupid question, but I need use md5 function in 7.4 When I write: select md5('text'); ERROR: Function md5("unknown") does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecast

Re: [GENERAL] md5 function

2003-12-17 Thread Michael Fuhr
On Wed, Dec 17, 2003 at 09:37:07AM +, Richard Huxton wrote: > On Wednesday 17 December 2003 08:47, Miso Hlavac wrote: > > Hello, > > > > Sorry for just stupid question, but I need use md5 function in 7.4 > > When I write: > > select md5('text'); > > ERROR: Function md5("unknown") does not exis

Re: [GENERAL] md5 function

2003-12-17 Thread Richard Huxton
On Wednesday 17 December 2003 08:47, Miso Hlavac wrote: > Hello, > > Sorry for just stupid question, but I need use md5 function in 7.4 > When I write: > select md5('text'); > ERROR: Function md5("unknown") does not exist > Unable to identify a function that satisfies the given argument >

Re: [GENERAL] md5 function

2003-12-17 Thread Michael Fuhr
On Wed, Dec 17, 2003 at 09:47:01AM +0100, Miso Hlavac wrote: > Sorry for just stupid question, but I need use md5 function in 7.4 > When I write: > select md5('text'); > ERROR: Function md5("unknown") does not exist > Unable to identify a function that satisfies the given argument types >

[GENERAL] md5 function

2003-12-17 Thread Miso Hlavac
Hello, Sorry for just stupid question, but I need use md5 function in 7.4 When I write: select md5('text'); ERROR: Function md5("unknown") does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts where is problem?

[GENERAL] MD5() function not available ??

2003-09-13 Thread Marek Lewczuk
Hey, I've searched for MD5 crypting function in PG, but I did not find it. Anyone knows how to implement this function in PG ? Best wishes, Marek L. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archive

Re: [GENERAL] MD5 function is not available ?

2003-09-11 Thread Richard Huxton
On Thursday 11 September 2003 09:38, Marek Lewczuk wrote: > Hey, > I've searched for MD5 crypting function in PG, but I did not find it. > Anyone knows how to implement this function in PG ? Is it not in the contrib/pgcrypto directory in the source distro? Or, check the contrib package of your bi

[GENERAL] MD5 function is not available ?

2003-09-11 Thread Marek Lewczuk
Hey, I've searched for MD5 crypting function in PG, but I did not find it. Anyone knows how to implement this function in PG ? Best wishes, Marek L. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]