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

[Gery .]

Thanks Nicolas, it worked perfectly, and yes, my IDs are INT, I just put the quotes (' ') because I saw that in some examples, btw, where I can find the notation you used to solve this 
problem? I was looking for something like that I didnt find anything like that, also, I'm not receiving the answers to my posts by email, I just saw them in the postgis-user forum website, is there something wrong with it? I edited two times my options and nothing, this website should have also the possibility to post there, something like a quick answer link.

Thanks again.


----------------------------------------
> From: gamejihou at hotmail.com
> To: postgis-users at postgis.refractions.net
> Subject: Update table based on identical rows but in one call
> Date: Fri, 7 Oct 2011 11:43:17 +0000
>
>
>
> Hi,
>
> 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,
>
>