scalar subselects

alxtoth
2011-04-12
2013-04-15
  • alxtoth

    alxtoth - 2011-04-12

    Memo to myself (from Postgres mod pages)

    SELECT name, (SELECT max(pop) FROM cities WHERE cities.state = states.name)
        FROM states;

     
  • PAscal

    PAscal - 2011-10-27

    If it should also work for updates like

       update A
       set x = (select x from B where A.y=B.y)
       where …

    It would be great
    Regards
    PAscal

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks