With pre V3, PSQL (stored procedure or EXECUTE BLOCK) comes to my mind. -- With regards, Thomas Steinmaurer http://www.upscene.com
Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. 'Piotr Olszewski' [email protected] [firebird-support] schrieb am 29.03.2016 11:53: > let's assume that I have 2.5.3 > > Pozdrawiam > > Piotr Olszewski > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] > Sent: Tuesday, March 29, 2016 11:45 AM > To: [email protected] > Subject: Re: [firebird-support] How to add previous column value to current > value? > > 29.03.2016 11:40, 'Piotr Olszewski' [email protected] > [firebird-support] wrote: >> I need to get a date difference (days between) between rows. > > With Firebird 3.0 you can use window function LAG. > > -- > WBR, SD. > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item on the > main (top) menu. Try FAQ and other links from the left-side menu there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > > > > ------------------------------------ > Posted by: "Piotr Olszewski" <[email protected]> > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > >
