[Omaha.pm] Quiz: select *

Jay Hannah jay at jays.net
Sun Jan 30 19:31:11 PST 2005


On Jan 30, 2005, at 8:55 PM, Andy Lester wrote:
> On Fri, Jan 28, 2005 at 02:38:12PM -0600, Jay Hannah 
> (jhannah at omnihotels.com) wrote:
>> Quiz: What's wrong with doing "select *" followed by fetchrow_array?
>
> Wrong in which sense?  In the sense that the column order may change in
> the future and break your code?

Yes. That was exactly the sense I was looking for. -grin-

Our code lives a long time. Our tables tend to change.

(Plus the less concerning fact that it's wasting CPU cycles on the 
columns that aren't used.)

j



More information about the Omaha-pm mailing list