[src]SELECT 

 "F_DateAnaliz",  
 string_agg("F_Value", ' , ')
 
FROM    "SC_Chemlog"."T_AnalizData", "SC_Chemlog"."T_AnalizCreate" 
GROUP by "F_DateAnaliz";

SELECT   "F_DateAnaliz",  "F_Value","F_AnalizCreate_ID"
    FROM "SC_Chemlog"."T_AnalizCreate", "SC_Chemlog"."T_AnalizData" ;
    WHERE "F_AnalizCreate_ID"= "ID_AnalizCreate";

SELECT -- Grab the user_account columns.
       acc.id,
       acc.email,
       -- Use max() combined with a case statement to
       -- usher individual attribute values into columns.
       max(CASE WHEN (attr.attribute_type = 'first-name')
                THEN attr.value END) AS fname,
       max(CASE WHEN (attr.attribute_type = 'last-name')
                THEN attr.value END) AS lname,
       max(CASE WHEN (attr.attribute_type = 'title')
                THEN attr.value END) AS title
   FROM user_account AS acc
   -- Join the attribute table /once/.
   LEFT JOIN user_attribute AS attr
     ON (attr.user_account_id = acc.id)
   WHERE (acc.email = 'foo@example.com')
   -- Group by the non-pivoted columns
   GROUP BY acc.id,acc.email;