Re: SQL problem?

From: "Charley L(dot) Tiggs" <ctiggs(at)xpressdocs(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL problem?
Date: 2005-08-26 14:51:49
Message-ID: 4C852465-A5C8-4237-955B-FF0C75BBD6B5@xpressdocs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)yahoo(dot)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
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-08-26 15:09:31 Re: SQL problem?
Previous Message Tom Lane 2005-08-26 04:34:15 Re: Selective authentication?