220
edits
Changes
Jump to navigation
Jump to search
→Building stageflags
END AS excludeflag
FROM round;
==Sample output==
The psql file was copied to an output text file using:
\COPY stageflags TO 'flag.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV;
A sum column was added in excel which is the sum of the last 3 columns. Notice how all entries are 1. This is good.
coname stage3 seedflag earlyflag laterflag growthflag transactionflag excludeflag Sum
0-In Design Automation Inc. Seed 1 0 0 1 0 0 1
0-In Design Automation Inc. Expansion 0 0 0 0 1 0 1
0-In Design Automation Inc. Expansion 0 0 0 0 1 0 1
0-In Design Automation Inc. Early Stage 0 1 0 1 0 0 1
0-In Design Automation Inc. Expansion 0 0 0 0 1 0 1
1000 Markets Inc. Early Stage 0 1 0 1 0 0 1
1000Memories Inc. Early Stage 0 1 0 1 0 0 1
1000Memories Inc. Early Stage 0 1 0 1 0 0 1
1000Museums Inc Expansion 0 0 0 0 1 0 1
1000Museums Inc Expansion 0 0 0 0 1 0 1
100Plus Seed 1 0 0 1 0 0 1
