On Tuesday 21 Jun 2005 8:50 pm, MRB wrote: > I'm working with a lot of data from MySQL where the MySQL ENUM type > is used.
just a thought - it took me five years after migrating from mysql to pg to start thinking like an sql programmer. I used to keep trying to write stuff for pg 'like' i used to for mysql. When i did that - i didnt get any of the benefits of pg - might as well have continued to write in mysql. Especially so when i went into convolutions trying to translate the enum type and the 'set' syntax on insert. In these cases i suggest dumping the mysql way and rewriting in the pg way. -- regards kg http://www.livejournal.com/users/lawgon tally ho! http://avsap.org.in ಇಂಡ್ಲಿನಕ್ಸ வாழ்க! ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]