Re: [SQL] selects on differing subsets of a query

2006-05-03 Thread Markus Schaber
Hi, Bruno, Bruno Wolff III wrote: >>I think this is a result of the "only subscribers may post" policy, but >>I'm getting of topic. > > Note the policy is really only subscribers may post without moderator > approval. Thanks for clarification. I also think that the moderators are aided by som

Re: [SQL] selects on differing subsets of a query

2006-05-03 Thread Bruno Wolff III
On Wed, May 03, 2006 at 09:47:49 +0100, [EMAIL PROTECTED] wrote: > First post, be gentle as I have terminology problems and so the > subject might be wrongly worded. > > Say I have a table with fields > ... > gender > diet_pref > ... > > What I am trying to construct is a *single* query showing

Re: [SQL] selects on differing subsets of a query

2006-05-03 Thread Bruno Wolff III
On Wed, May 03, 2006 at 14:19:27 +0200, Markus Schaber <[EMAIL PROTECTED]> wrote: > > I think this is a result of the "only subscribers may post" policy, but > I'm getting of topic. Note the policy is really only subscribers may post without moderator approval. ---(end

Re: [SQL] selects on differing subsets of a query

2006-05-03 Thread Markus Schaber
Hi, Ed, [EMAIL PROTECTED] wrote: > It's actually a temporary mailbox just in case the list attracts spam :-) As far as I can see, the PostgreSQL lists are extremely low on spam attraction, compared to other lists. I think this is a result of the "only subscribers may post" policy, but I'm getti

Re: [SQL] selects on differing subsets of a query

2006-05-03 Thread ed . temp . 01
Hello Markus, It's actually a temporary mailbox just in case the list attracts spam :-) Thank you for your help, I will study it when I get development time on the database. On 03/05/06, Markus Schaber <[EMAIL PROTECTED]> wrote: Hi, Ed Temp, [EMAIL PROTECTED] wrote: > First post, be gentle a

Re: [SQL] selects on differing subsets of a query

2006-05-03 Thread Markus Schaber
Hi, Ed Temp, [EMAIL PROTECTED] wrote: > First post, be gentle as I have terminology problems and so the > subject might be wrongly worded. Hmm, the biggest mistake seems that "et temp 01" is a very unlikely real name, so you should reconfigure your mail client :-) > What I am trying to construc

[SQL] selects on differing subsets of a query

2006-05-03 Thread ed . temp . 01
First post, be gentle as I have terminology problems and so the subject might be wrongly worded. Say I have a table with fields ... gender diet_pref ... What I am trying to construct is a *single* query showing the total number of males in the table and also the total number of male vegetarians