Revision 57596
Added by Michele Artini over 4 years ago
| schema.sql | ||
|---|---|---|
| 188 | 188 |
u.email, |
| 189 | 189 |
u.valid, |
| 190 | 190 |
u.role, |
| 191 |
array_agg(uc.country) AS countries |
|
| 191 |
array_agg(uc.country) FILTER (WHERE uc.country IS NOT NULL) AS countries
|
|
| 192 | 192 |
FROM |
| 193 | 193 |
users u |
| 194 | 194 |
LEFT OUTER JOIN user_countries uc ON (u.email = uc.email) |
Also available in: Unified diff
User Registration form