Re: [GENERAL] MySQL insert() and instr() equiv

2006-06-17 Thread Mark Constable
On Sunday 18 June 2006 02:33, Tom Lane wrote: > > 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]". > But, if you're not wedded to that particula

[GENERAL] MySQL insert() and instr() equiv

2006-06-17 Thread Mark Constable
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

Re: [GENERAL] Login username char length

2005-12-24 Thread Mark Constable
On Saturday 24 December 2005 23:13, Tino Wildenhain wrote: > > Please excuse my naivety as I have never used postgresql. Could > > anyone please let me know if there is any char length limit for the > > username that logs into the database itself ? > ... > "name 64 bytesinternal type for ob