Re: [GENERAL] Postgresql and programming

2000-06-14 Thread Ron Peterson
If you're only consideration is raw performance of lookups on text fields, I suppose there might be some measureable performance advantage in putting everything in one table, but I doubt you'd really notice the difference. If you *did* do this, what is the significance of the authorID field? Nor

[GENERAL] Postgresql and programming

2000-06-13 Thread T.J.Farrell
Hello all, as usual in CS, there can be many ways to do the same thing. For instance, I can uppercase a string in a function in POstgreSQL or I can uppercase it before sending the query to the database. I am reading Bruce Monjian's book right now (page 204, Functions & triggers/triggers), and I a