Postgres Update from function

By Andrew Hopper | Published: June 3, 2009
I always forgot the syntax of the Postgresql update from functionality
UPDATE employees SET sales_count = sales_count + 1 FROM accounts
  WHERE accounts.name = 'Acme Corporation'
  AND employees.id = accounts.sales_person;
This entry was posted in Postgresql. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

6 Trackbacks

  1. By BRADLEY on July 4, 2010 at 5:23 am


    Pillspot.org. Canadian Health&Care.No prescription online pharmacy.Best quality drugs.Special Internet Prices. No prescription drugs. Order drugs online…

    Buy:Levitra.Viagra Super Force.Propecia.Viagra Soft Tabs.Viagra.Super Active ED Pack.VPXL.Tramadol.Cialis Super Active+.Cialis Soft Tabs.Viagra Professional.Zithromax.Soma.Viagra Super Active+.Maxaman.Cialis Professional.Cialis….

  2. By k2 on August 29, 2010 at 11:09 pm

    Skis http://acopperzga.AUTOTECHGUIDE.INFO/tag/rei+k2+Skis/ : Skis…

    Skis…

  3. By 850i on September 15, 2010 at 1:50 am

    850i http://jns.yuo.ii88.co : 850i…

    850i…

  4. By dwrrrew on August 20, 2011 at 3:38 pm

    ….

    best.place.to@buy.clothes” rel=”nofollow”>.…

  5. By dw541 on August 21, 2011 at 8:43 am

    ….

    .@cialis.reviews” rel=”nofollow”>.…

  6. By bptbdo on August 30, 2011 at 2:18 am

    ….

    best.place.to@buy.diamonds” rel=”nofollow”>.…

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>