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?