addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1linklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Postgres Window Functions

From: user 1.
Sent on: Thursday, September 22, 2011 11:06 PM
Hello World.

Newer versions of PostgreSQL offer an enhancement to SQL known as
"Window Functions".­

A typical use case for a window function is to start with a table of
stock prices with these columns:

stock_symbol, price_date, price

Then specify that you want an additional column:

stock_symbol, price_date, price, price20day_moving_av­g

I offer some syntax examples of "Window Functions" in my latest blog entry:­

The examples are for Oracle but they should be good enough to get you
started writing Window Functions for Postgres.

A good time for you to wrestle with this syntax is on a Sunday Hackternoon:­

-- Dan, Creator of the DanBot

Some traders make their own luck.
We use a robot.­

Our Sponsors

  • Google

    Google provides the venue for most meetings.

  • New Relic

    New Relic, performance monitoring & analytics company, pays for pizza!

  • Devoxx US

    Great Bay Area Java Conference.

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy