At 3:30 PM -0800 11/21/07, Selena Deckelmann wrote:
Hello, I have been looking into getting some woman-sized PostgreSQL shirts, in addition to the more typical men-sized tshirts. The particular style is American Apparel shirts, style # 2102. They are "normal looking" t-shirts, just proportioned a bit more correctly for a woman's body. The shirt says 'PostgreSQL' in small print on the front, and has the big elephant logo on the back. We'll most likely ask for a $20 donation to the PostgreSQL non-profit for each shirt. So, I'm conducting a small poll: If you are interested in a woman-sized shirt, please EMAIL ME DIRECTLY with a quantity, and size (XS, S, M, L, XL). If you would not wear a PostgreSQL woman-sized shirt yourself, please consider whether you would maybe get one as a gift for someone else this holiday season :)
In answer to your query, I believe the following SQL would do it: Select count(*), size from postgresqlusers where gender = 'female' or hasFemaleAcquaintance group by size; If this doesn't work, what version are you using? Oh....you're running a POLL! Never mind. -Owen ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
