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.

One Trackback

  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….

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>