Re: SQL problem? - Mailing list pgsql-novice

From Charley L. Tiggs
Subject Re: SQL problem?
Date
Msg-id 4C852465-A5C8-4237-955B-FF0C75BBD6B5@xpressdocs.com
Whole thread Raw
In response to Re: SQL problem?  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: SQL problem?  (Bruno Wolff III <bruno@wolff.to>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Selective authentication?
Next
From: Bruno Wolff III
Date:
Subject: Re: SQL problem?