> [...] > SELECT a_nr, > (SELECT count(*) FROM cylinders WHERE z_a_nr = a_nr) AS #cylinder, > [...] > FROM orders > [...] Is this a documented feature? Where can I find more information about this? I do not want to join the actual discussion about documentation of PostgreSQL but I never before have seen such a construct in SQL! Best regards, Jens Hartwig ============================================= Jens Hartwig --------------------------------------------- debis Systemhaus GEI mbH 10875 Berlin Tel. : +49 (0)30 2554-3282 Fax : +49 (0)30 2554-3187 Mobil : +49 (0)170 167-2648 E-Mail : [EMAIL PROTECTED] =============================================
- [SQL] how to build this query ??? Please help !!! juerg . rietmann
- Sv: [SQL] how to build this query ??? Please help ... Nikolaj Lundsgaard
- Re: Sv: [SQL] how to build this query ??? Plea... Jens Hartwig
- Re: Sv: [SQL] how to build this query ??? ... Tod McQuillin
- Re: Sv: [SQL] how to build this query ... Tom Lane
- Re: Sv: [SQL] how to build this query ... Jens Hartwig
- Re: Sv: [SQL] how to build this q... Tom Lane
- Re: Sv: [SQL] how to build th... Jens Hartwig
- Re: Sv: [SQL] how to buil... Tod McQuillin
- Re: Sv: [SQL] how to buil... Robert B. Easter
- Re: Sv: [SQL] how to buil... Robert B. Easter
- Re: Sv: [SQL] how to buil... Tom Lane
- Re: Sv: [SQL] how to buil... Tom Lane