I don't know about the date formatting (although I know that can always be done easily on the application end, which is usually more convenient), but about the regex: They should work pretty much like perl (there may be a few differences) except that you aren't retrieving matches in PG or replacing, it is just a boolean test to see if a pattern is found. here is some brief documentation on perl regexes, to get you started at least: http://www.perl.com/pub/doc/manual/html/pod/perlre.html#Regular_Expressions Hope it helps. You might also try documentation for other programming languages that use regexes (PHP, Sed & Awk, etc). -Jeff Davis --- Frank R Callaghan <[EMAIL PROTECTED]> wrote: > Excuse my ignorance but is there anyway to > format a returned date aka 'mm/dd/yy' in a query > like > sybase dateformat(date, 'mm/dd/yy'); > also is the a good document explaining the use > of regex in postgresql. > > TIA, > Frank. > > > > > > > ************ > > __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com ************
