When using MySQL I have one select that uses MySQL functions so I am
wondering about the best way to go to end up with the same result in
PostgreSQL.
uid is an email address stored in the passwd table as [EMAIL PROTECTED]
and this construct allows an incoming username such as "user.domain.com"
to be compared to the stored "[EMAIL PROTECTED]".
SELECT wpath FROM passwd WHERE uid="\L" OR insert(uid,instr(uid,'@'),1,'.')="\L"
--markc
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
