Re: SQL problem?
От | Charley L. Tiggs |
---|---|
Тема | Re: SQL problem? |
Дата | |
Msg-id | 4C852465-A5C8-4237-955B-FF0C75BBD6B5@xpressdocs.com обсуждение исходный текст |
Ответ на | Re: SQL problem? (Bruno Wolff III <bruno@wolff.to>) |
Ответы |
Re: SQL problem?
|
Список | pgsql-novice |
What kind of maintenance problems, if you don't mind my asking? Charley On Aug 25, 2005, at 9:21 PM, Bruno Wolff III wrote: > On Thu, Aug 25, 2005 at 16:47:54 -0700, > operationsengineer1@yahoo.com wrote: > >>> Column names are case-sensitive. >>> Btw.: SELECT * is evil... >>> >>> >>> >>> Regards, Andreas. >>> >> >> Andreas, what would you recommend instead of SELECT * >> if you really do wanty all the results? >> > > Explicitly listing the columns. Using '*' causes maintainance > problems. > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend >
В списке pgsql-novice по дате отправления: