[postgis-users] updating a geometry column, db procedure needed?

[Bart van den Eijnden]

Hi list,

I have 2 tables:

1) an address table with postal code, house no., X and Y columns (no  
geometry column)
2) another table X which has postal code and house no.

I have added a geometry column to table X and want to update it with  
address matching from the address table using postal code and house no.

Can I do this with plain SQL? Or do I need a database procedure to do this  
for all of the records?

Thanks in advance.

Best regards,
Bart

-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/