Tag Info

New answers tagged


There is an answer on Stack Overflow to the question Show a one to many relationship as 2 columns — 1 unique row (ID & comma separated list) which demonstrates how to create a user-defined aggregate in Informix that functions more or less like the GROUP_CONCAT aggregate in MySQL. You can then easily use this to solve the problem in this question: ...


This answer assumes that your table Ex1 has columns: key_col — the key column. flag_col — the flag column, containing L or P (with a check constraint). data_col — a proxy for the unidentified set of columns containing the other data. Primary key on key_col and flag_col. A view like this should work (I didn't say it would work fast): CREATE VIEW ...

Top 50 recent answers are included