Hacker News Reader

SQL Server behaviour is: If you have a "select *" view and then add more columns to underlying table, columns will not show up in view until view if refreshed

Thats not too bad, and it does not get the column names mixed up.

View on HN

That's also the way it works in PostgreSQL. I think the view is actually compiled into a parse tree with named columns, and the view given a defined type iirc.

(Select * from ... in PostgreSQL is actually really usefun in anything object-relational because you get objects of a named type back btw.)

That's the way it works now. In earlier versions any added columns would still be retrieved, shifting all the other column values to the right.. So all the data would wind up having the wrong column names.

I've been using MS Sql from version 7, through 2000, 2005, 2008 etc, and I never saw that bug.

Reply on news.ycombinator.com