Split string character separated data into columns Postgresql

Having a code in column cod_catastral with format: 01-15-05-23, I use split_part function for extract cardinally every row:

split_part(string text, delimiter text, field int)

In execution:

UPDATE censo.area_muestra SET 
zona = split_part(cod_catastral, '-', 1)::smallint, 
sector = split_part(cod_catastral, '-', 2)::smallint,
mz = split_part(cod_catastral, '-', 3)::smallint,
solar = split_part(cod_catastral, '-', 4);
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s