Updating by concatenating columns in PostgreSQL

postgresql syntax-error
namalfernandolk picture namalfernandolk · May 18, 2012 · Viewed 10.8k times · Source

I need to set the hotelcode by concatenating it with the vendorcitycode (separated by an underscore) as follows.

update schema.table_name set
       hotelcode = hotelcode+"_"+vendorcitycode)
 where vendorid = 'INV27' and vendorcitycode = 'LON'

Note : hotelcode and vendorcitycode are two columns of type character varying(100). I use PostgreSQL 8.0.

Answer

Quassnoi picture Quassnoi · May 18, 2012 
UPDATE   table_name
SET      hotelcode = hotelcode || '_' || vendorcitycode
WHERE    (vendorid, vendorcitycode) = ('INV27', 'LON')

Related questions

Laravel: Error [PDOException]: Could not Find Driver in PostgreSQL

I'm trying to connect with PostgreSQL database through Laravel in order to do a php artisan migrate but doesn't seem to be directed since it's reading the database name of MySQL. Here are the commands from database.php: 'connections' => …

Read More
PostgreSQL syntax error when using EXECUTE in Function

I'm trying to create a function which references a temporary table in PostgreSQL 8.4. Based on my research it seems the best way to do this is to use the EXECUTE command to execute my query from a defined string. Unfortunately …

Read More
How to pass string with ' ' (timestamp) in prepared statement?

I am trying to execute the following query INSERT INTO hotspot(timestamp) VALUES (timestamp with time zone '2012-10-25 14:00:00 +05:00' at time zone 'EET'); and i want to pass the timestamp as a variable. My timestamp column is type …

Read More