Re: [GENERAL] Case sensitivity issue

2001-09-14 Thread Matthew Rice
o work in PostgreSQL and MySQL and ended up with: lower(Field) = lower('string') Is there another way that works on both? -- matthew rice <[EMAIL PROTECTED]> starnix inc. tollfree: 1-87-pro-linuxthornhill, ontario, canad

Re: [GENERAL] Where do they find the time??? Great Bridge closed now!!!??

2001-09-14 Thread Matthew Rice
roducts!! PostgreSQL is very advanced SQL server > more advanced than mysql. What a coincidence. I was about to say the exact opposite. Obviously, PostgreSQL isn't the one true database and everyone should Jump into MySQL. It is easier to type. I hope your post was meant as a joke becaus

[GENERAL] Q: Record Updating/Locking in Web Environments

2001-03-31 Thread Matthew Rice
bit. Any thoughts on this would be most welcome. Regards, -- matthew rice <[EMAIL PROTECTED]> starnix inc. tollfree: 1-87-pro-linuxthornhill, ontario, canada http://www.starnix.com professional linux services & p

Re: [GENERAL] shared memory settings: SHMMAX and SHMALL

2001-03-15 Thread Matthew Rice
just did this: echo 111 >/proc/sys/kernel/shmmax and got: cat /proc/sys/kernel/shmmax -1773790777 Probably not good, long term :) My kernel also wouldn't let me make SHMALL higher than 16M -- matthew rice <[EMAIL PROTECTED]> s

Re: [GENERAL] Public Database of zip code information

2000-09-20 Thread Matthew Rice
lat/long, and city information--does anyone else > > remember this, or should I check into a drug clinic? Who says these are mutually exclusive :) -- matthew rice <[EMAIL PROTECTED]> starnix inc. tollfree: 1-87-pro-linuxthornhill, ontario,

[GENERAL] Should I upgrade Postgres?

1999-01-05 Thread Matthew . Rice
I just installed postgres 6.1.1 on Caldera 1.3 (it came with it). Should I upgrade this immediately or is this good enough for now? If so, which version should I upgrade to 6.3.x or 6.4.x? Thanks, -- matthew rice, starnix inc.