On Sunday 18 June 2006 02:33, Tom Lane wrote: > > uid is an email address stored in the passwd table as user@xxxxxxxxxx > > and this construct allows an incoming username such as "user.domain.com" > > to be compared to the stored "user@xxxxxxxxxx". > But, if you're not wedded to that particular way, why not use replace()? I only decided to ditch MySQL tonight so I'm within the first 1/2 dozen hours of using pgsql for almost the first time. I've lost a fair amount of hair with the basics of db and user setup and close to burnout. > SELECT wpath FROM passwd WHERE uid="\L" OR replace(uid, '@', '.')="\L" Excellent. Just the double quotes needed to be changed to single quotes to avoid this error and replace() indeed works for my needs. ERROR: column "user.domain.com" does not exist Another anti-burnout question, how would I turn on the ability to view any SQL requests in the logfile ? No doubt there is an answer in the list archives somewhere but my first few searches brought up nothing useful. --markc
