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' piotr.olszewski@eskrzynka.pl [firebird-support] schrieb am 29.03.2016 11:53:
> let's assume that I have 2.5.3
>
> Pozdrawiam
>
> Piotr Olszewski
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com]
> Sent: Tuesday, March 29, 2016 11:45 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] How to add previous column value to current
> value?
>
> 29.03.2016 11:40, 'Piotr Olszewski' piotr.olszewski@eskrzynka.pl
> [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" <piotr.olszewski@eskrzynka.pl>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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: "Thomas Steinmaurer" <ts@iblogmanager.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
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/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comments:
Post a Comment