Feature Requests item #2682714, was opened at 2009-03-11 14:31 Message generated for change (Comment added) made by mr-meltdown You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2682714&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Priority: 5 Private: No Submitted By: Stefan de Konink (skinkie) Assigned to: Niels Nes (nielsnes) Summary: SQL: default with expression Initial Comment: Upon inserting it would be nice to have a default value based on other columns in that same row. ---------------------------------------------------------------------- >Comment By: Fabian (mr-meltdown) Date: 2009-12-01 10:47 Message: as far as I know "DEFAULT NEXT VALUE FOR seq_X" is pretty dynamic ---------------------------------------------------------------------- Comment By: Stefan de Konink (skinkie) Date: 2009-12-01 10:44 Message: ;) Other database support 'dynamic' DEFAULTs. Hence you are allowed to place an expression into the default. This is currently not possible in MonetDB where it is static. I don't see the big problem (performance) problem in this as long the default is added on the end of a bulk transaction. Instead of foreach record. S in general it would be an 'on-insert-update-trigger', opposed to the other request 'on-update-update-trigger'. ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-12-01 10:35 Message: reopen for skinkie, as it seems he doesn't want to clarify otherwise ---------------------------------------------------------------------- Comment By: Fabian (mr-meltdown) Date: 2009-12-01 10:10 Message: Why can't you write that using the current DEFAULT implementation? NEEDINFO ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482471&aid=2682714&group_id=56967 ------------------------------------------------------------------------------ Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
