Roy,

<< 'm sure you've said that before somewhere but I'd obviously forgotten. Would it be possible to enhance COMPUTED to use simple scripts. >>

No.  That would require re-engineering the entire way that computed/generated columns work, which seems rather silly when you can just change the word 'COMPUTED" to "GENERATED" and get what you want.

Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< 'm sure you've said that before somewhere but I'd obviously forgotten. Would it be possible to enhance COMPUTED to use simple scripts. >>
>
>No. That would require re-engineering the entire way that computed/generated columns work

OK

>which seems rather silly when you can just change the word 'COMPUTED" to "GENERATED" and get what you want.

Not quite - I do not want to store the data, and yes I know disk is cheap but I still don't want to store ephemeral transient data.

Roy Lambert

Roy,

<< Not quite - I do not want to store the data, and yes I know disk is cheap but I still don't want to store ephemeral transient data. >>

Yes, but after thinking about this further - a script would have the same issues with identifier resolution that a function reference would have.  The bottom line is that you can't evaluate database-wide operations during a client-side operation.  There's just a bunch of inaccessible information that is only server-side.

Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< Not quite - I do not want to store the data, and yes I know disk is cheap but I still don't want to store ephemeral transient data. >>
>
>Yes, but after thinking about this further - a script would have the same issues with identifier resolution that a function reference would have. The bottom line is that you can't evaluate database-wide operations during a client-side operation. There's just a bunch of inaccessible information that is only server-side.

Yes but only if the script contained things like SELECT or CALL. Unless you go to the effort of creating a second programming system for COMPUTED columns I can see it would be difficult to check these sort of things and have to rely on the sanity of the programmer.

Shame but I understand an accept the restrictions

I can think of some ways of doing it that would almost certainly bomb at some point - just in case you'd like those sort of suggestions

Roy