[postgis-users] Update table based on identical rows but in one call
gamejihou at hotmail.com
Fri Oct 7 04:43:17 PDT 2011
I'm trying to update several rows of my table just with one call, based e.g., in the number of ID. For that I would like to do something like the following:
UPDATE line SET survey = 'GT', type = 'MR', source = 'TY' WHERE id = '5' TO id = '15';
I know this doesnt work, it's just to ask if there is a way of doing this in this way, just with one call.
Thanks for any suggestions,
More information about the postgis-users