Re: MySQL insert() and instr() equiv

On Jun 17, 2006, at 1:18 PM, Mark Constable wrote:
> On Sunday 18 June 2006 02:33, Tom Lane wrote:
>>> uid is an email address stored in the passwd table as
>>> user(at)domain(dot)com
>>> and this construct allows an incoming username such as
>>> "user.domain.com"
>>> to be compared to the stored "user(at)domain(dot)com".
>
>> 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.

You should hop on the IRC channel (#postgresql on irc.freenode.net).
There's almost always people on, and it's a great way to get help.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461