Re: RE : full featured alter table?

I agree 100%.

this makes very portable code, and usable libraries.

scott.marlowe wrote:

> On Mon, 16 Jun 2003, Jim C. Nasby wrote:
> 
> 
>>On Sat, Jun 14, 2003 at 06:55:36PM +0200, Bruno BAGUETTE wrote:
>>
>>>Hello everybody,
>>>
>>>
>>>>The one thing we don't have that I think would be useful is a 
>>>>way to re-order the columns in a table. Maybe it's just me, 
>>>>but I tend to want column to appear in a specific order, and 
>>>>the only way you can accomplish this today is by re-creating 
>>>>the entire table.
>>>
>>>I agree with Jim, this would be a 'cool but not mandatory' feature ! :-)
>>>
>>>This feature is not mandatory since I avoid the use SELECT * FROM...
>>>(and I forbid the use of SELECT * to my subordinates).
>>
>> 
>>99.999% of the time, if you put SELECT * into code, you should be strung
>>up by your own entrails. But do you mean to tell me that when you're
>>testing stuff on the command line you never, ever use SELECT *?
> 
> 
> I wouldn't go that far.  I build updatable views, select * from them, 
> cycle through the fields getting name / type and build generic forms to 
> let the user edit / insert new records.
> 
> It allows me to reuse the same basic chunk of code over and over.
> 
> Of course, it's select * on a view, not a table, so I set the order when I 
> create the view.
> 
> Now, using select * and ASSUMING the order of the variables in your 
> application code is a punishable offense, but as long as you determine the 
> name / type of the fields after the select * it's not so bad.
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>