Hello list,
Any idea how I could generate this SQL statement under SQLAlchemy
(especially the PostreSQL ARRAY clause ...) ?
SELECT
i.id,
t.name AS taxo,
i.geographic_range,
ARRAY(
(SELECT h.name
FROM habitats h, invasive_habitats ih
WHERE h.id=ih.habitat_id AND ih.invasive_id=i.id)
) AS habitats,
(SELECT
ivn.name
FROM invasive_names ivn, languages l
WHERE
ivn.language_id=l.id AND
l.iso_code='la' AND
ivn.invasive_id=i.id
) AS scientific_name
FROM invasives i, taxonomies t
WHERE t.id=i.group_id
ORDER BY i.id;
Thanks,
Julien
--
Julien Cigar
Belgian Biodiversity Platform
http://www.biodiversity.be
Université Libre de Bruxelles
Campus de la Plaine CP 257
Bâtiment NO, Bureau 4 N4 115C (Niveau 4)
Boulevard du Triomphe, entrée ULB 2
B-1050 Bruxelles
office: [EMAIL PROTECTED]
home: [EMAIL PROTECTED]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
