Never mind, it seems I found the bug. May I suggest something in the docs a bit more explicit than it is...
Regards and many_ thanks On Mon, 31 Mar 2003, Tom Lane wrote: > Date: Mon, 31 Mar 2003 13:24:42 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: [HACKERS] What's wrong > > [EMAIL PROTECTED] writes: > > It worked fine in 7.2 but now IFAICS, it never gives the original result > > and moreover, if I run SELECT sql_crypt('xxx','xxx') several times, it > > gives 3 diferent results and loops other those 3 results. > > I would've expected it to be unreliable under previous versions too. > AFAICS you aren't taking care to ensure that the inputs to crypt() > are null-terminated. > > regards, tom lane > -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: [EMAIL PROTECTED] ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org