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