[postgis-users] Update table based on identical rows but in one call

Gery . 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 mailing list