[SQL] Re: Heres a good one...

2001-04-30 Thread Steve Meynell
First, thank you very much for trying but you were a bit off the mark but close. Second, posting_date being of type char(4) is quite legal and irrelevant for this exercise but for argument sake lets say char(15) but apart from all that... Your sql statement was close but it only update 4 out of

[SQL] views and rules on update

2001-04-30 Thread Martín Marqués
OK, I got some views and I'm building the rules to insert, update and delete on the view. The question I have is, what if certain column on the view is not specified on an insert or an update? What does the rule do with that column? Saludos... :-) -- El mejor sistema operativo es aquel que te