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

2006-06-19 Thread Jim Nasby
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 [EMAIL PROTECTED] and this construct allows an incoming username such as "user.domain.com" to be compared to the stored "[EMAIL PROTECTED]".

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

2006-06-18 Thread Marco Bizzarri
Not sure this is the right answer: in older version you could enable it via the postgresql.conf file, modifing the variable log_statement and setting that to true. Also, you should check the syslog level variable in the same file. Regards Marco On 6/17/06, Mark Constable <[EMAIL PROTECTED]> wrot

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

2006-06-17 Thread Bruno Wolff III
On Sun, Jun 18, 2006 at 04:18:23 +1000, Mark Constable <[EMAIL PROTECTED]> wrote: > > Another anti-burnout question, how would I turn on the ability > to view any SQL requests in the logfile ? I think this section of the manual will answer your question: http://developer.postgresql.org/docs/pos

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

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

2006-06-17 Thread Michael Fuhr
On Sun, Jun 18, 2006 at 02:06:28AM +1000, Mark Constable wrote: > 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. You might be interested in the MySQL Compatibility Functions: http://pgfoundr

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

2006-06-17 Thread Tom Lane
Mark Constable <[EMAIL PROTECTED]> writes: > 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(

[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