"Kelly, Brian" <Brian.Kelly AT uwsp DOT edu> writes:

> I've seen lots of posts regarding the decoding of Lstat data. I'm
> currently using a few functions to decoded the lstat data and make
> it human readable.  These functions have been tested and are known
> to work with mysql 5.0.70

hi, I spent quite a bit of work trying different approaches to find
the fastest way to do this in MySQL, and the result is included in

    gui/bweb/script/bweb-mysql.sql

it's essentially the same as yours, though, based on INSTR.
PostgreSQL users can look in

    gui/bweb/script/bweb-postgresql.sql

(not written by me.)
-- 
Kjetil T. Homme
Redpill Linpro AS - Changing the game


------------------------------------------------------------------------------
Stay on top of everything new and different, both inside and 
around Java (TM) technology - register by April 22, and save
$200 on the JavaOne (SM) conference, June 2-5, 2009, San Francisco.
300 plus technical and hands-on sessions. Register today. 
Use priority code J9JMT32. http://p.sf.net/sfu/p
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users