Re: [GENERAL] PSQL Data Type: text vs. varchar(n)

2006-04-10 Thread Mark Aufflick
On 4 Apr 2006 04:15:06 GMT, Patrick TJ McPhee <[EMAIL PROTECTED]> wrote: > In article <[EMAIL PROTECTED]>, > Jim Nasby <[EMAIL PROTECTED]> wrote: > > % Not sure if it's still true, but DB2 used to limit varchar to 255. I > % don't think anyone limits it lower than that. > > Sybase: 254. Silently tr

Re: [GENERAL] stored proc vs sql query string

2006-04-10 Thread Mark Aufflick
tends to have worse sql embedded in it. Again I would point to my previous suggestion of containing db access in a small set of classes/methods/whatever - then you can assign your most sql savvy developer to maintaining that code. Just my 2c. Mark Aufflick. -- Mark Aufflic

Re: [GENERAL] PostgreSQL x Sybase

2006-03-30 Thread Mark Aufflick
I'm not aware of one, but I would also be very interested. Certainly Postgres is much more standards compliant. In terms of developer features, Postgres is also much more advanced. Sybase also has some unusual limitations in wierd areas like the maximum number of bytes of index per row. Sybase wo

Re: [GENERAL] Advantages of PostgreSQL over MySQL 5.0

2006-03-29 Thread Mark Aufflick
To go slightly OT, I have the current displeasure of becomming acquainted with Sybase which has ideas about being flexible with standards (and sanity) much like MySQL. The first of the two intentional "helpful" features I have come across so far is that inserting (or updating) char/varchar columns