tag:blogger.com,1999:blog-3443854162607009076.post3047828375655271072..comments2023-08-25T08:59:17.907-03:00Comments on asfernandes: Window functions (part3) - new functionsAdrianohttp://www.blogger.com/profile/07470899351244413501noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-3443854162607009076.post-83570258906720431632010-03-07T17:28:26.494-03:002010-03-07T17:28:26.494-03:00@Bert, I added it now. Thanks for the comment!@Bert, I added it now. Thanks for the comment!Adrianohttps://www.blogger.com/profile/07470899351244413501noreply@blogger.comtag:blogger.com,1999:blog-3443854162607009076.post-7040524862150942362010-03-06T07:53:22.179-03:002010-03-06T07:53:22.179-03:00Great functionality, the windows functions!
Using...Great functionality, the windows functions!<br /><br />Using lag with no previous row results in , the same goes for lead when there is no next row.<br /><br />Oracle and postgesql support a default value in that case, it would be a nice-to-have, although COALESCE will do the work also.Berthttps://www.blogger.com/profile/09968863353265834405noreply@blogger.com