Window, window on the wall …
November 20th, 2012 by depesz | Tags: aggregate, array_agg, postgresql, primer, string_agg, window, window functions | 9 comments »

And maybe not on the wall, but instead in your SQLz, eating your data. But a bit more seriously. Ever since PostgreSQL 8.4 we have window functions, but still I see people which do not know it or are wary to ...

Waiting for 8.5 – ordered aggregates
January 6th, 2010 by depesz | Tags: aggregate, array_agg, order, pg85, pg90, postgresql | 3 comments »

On 15th of December Tom Lane committed patch by Andrew Gierth (aka RhodiumToad), which adds interesting capability: Log Message: ----------- Support ORDER BY within aggregate function calls, at long last providing a non-kluge method for controlling the order in which values are fed to ...

Waiting for 8.4 – array aggregate and array unpacker
November 14th, 2008 by depesz | Tags: aggregate, arrays, array_agg, pg84, postgresql, unnest | 4 comments »

Finally, we got very important addons to PostgreSQL, which help with dealing with arrays. It solves a lot of problems, which were usually solved with standard cookbook code, which was in faqs, blog posts and number of examples on irc.

  • Popular Posts

    • Waiting for 9.3 – Create a psql command \gset to store query results into psql variables 0 comment(s) | 547 view(s)
    • Jak obsłużyć klienta, na przykładzie firmy Kurtmedia 9 comment(s) | 264 view(s)
    • Why is UPSERT so complicated? 0 comment(s) | 238 view(s)
    • Adding plans to explain.depesz.com from your psql 2 comment(s) | 217 view(s)
    • “FATAL: Ident authentication failed”, or how cool ideas get bad usage schemas 0 comment(s) | 187 view(s)
    • CHAR(x) vs. VARCHAR(x) vs. VARCHAR vs. TEXT – UPDATED 2010-03-03 0 comment(s) | 181 view(s)
    • Understanding postgresql.conf : log* 0 comment(s) | 152 view(s)
    • Index on (a,b) vs. (b,a)? 0 comment(s) | 150 view(s)
    • Write Ahead Log + Understanding postgresql.conf: checkpoint_segments, checkpoint_timeout, checkpoint_warning 0 comment(s) | 117 view(s)
    • Waiting for 8.4 – RETURN QUERY EXECUTE and cursor_tuple_fraction 0 comment(s) | 110 view(s)

  • postgresql

    • Documentation
    • Explain Analyze analyzer
    • IRC help channel
    • Mailing Lists search
    • PG Planet
    • PostgreSQL Home Page

  • About me

    • CPAN
    • Hardware for tests
    • LinkedIn
    • StackOverflow

  • Theme

    • Related searches:
    comment window depesz aggregate waiting
    gipoco.com is neither affiliated with the authors of this page nor responsible for its contents. This is a safe-cache copy of the original web site.