0

I'm trying to get an extra column into a crosstab query in PostgreSQL

The code I use is as shown

SELECT * FROM crosstab(
'SELECT
wkowono,
/*wkoptno,*/
prowkc,
CONCAT(wkowono,''-'',to_char(proopno,''FM000''),''-'',''1'') AS scan  
FROM keltech.wkofile
LEFT JOIN keltech.profile ON proptno = wkoptno
ORDER BY wkowono')
AS ct(wkowono character varying, /*wkoptno text,*/ FOLD text, "W/GR" text, SPRY text, ASMB text )

I want to uncomment /wkoptno,/ and /wkoptno text,/ to allow an extra column. As it stands the code works but I need the extra column.

Is this possible?

enter image description here

0 Answers0