Table:
CREATE TABLE venue (id INTEGER DEFAULT NEXTVAL('venue_id_seq'), building_code building_code, floorNo int, roomNo int, width int, length int);
The function:
CREATE or REPLACE FUNCTION roomCode(_id int ) RETURNS text AS
$$
SELECT building_code + floorNo + roomNo FROM venue as v WHERE _id = v.id;
$$ LANGUAGE SQL;
How can I Concatenate certain attributes together?
I dont know if this is the best way to do it, But I think it will get the job done:
You can use SELECT TEXTCAT( param 1, param 2)
If you want more than one attribute then you have to use a TEXTCAT within a TEXTCAT such as:
TEXTCAT( param 1, TEXTCAT(param 2, param3))
If your attributes are not of type text already then you will have to cast them to text as so:
attribute::text
So to answer your question in a whole:
SELECT TEXTCAT(building_code::text, TEXTCAT( floorNo::text , roomNo::text))
you can use string concatenation operator - ||
CREATE or REPLACE FUNCTION roomCode(_id int ) RETURNS text AS
$$
SELECT building_code || ' ' || floorNo::text || ' - ' || roomNo::text FROM venue as v WHERE _id = v.id;
$$ LANGUAGE SQL;