[GENERAL] Group by and lmit

Hey Folks - have a coded myself into a corner yet? I have a situation with a select count / group by / order by query that I need to limit each group to 500 entries. Not seeing a way to do this in a single query, do I need to use multiple queries? Group x has about 200 entries in it; group y

Re: [GENERAL] using generate_series to iterate through months

Ok, it is Monday -:) Thanks Tom! -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, August 03, 2009 11:44 AM To: Bill Reynolds Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] using generate_series to iterate through months "Bill Reynolds&quo

[GENERAL] using generate_series to iterate through months

Ok, I'm a bit stumped on getting my group by query to work which iterates through a number of months that basically a generate_series provides for me. Here is what I am using in the from clause (along with other tables) to generate the series of numbers for the number of months. This seems to wor

Re: [GENERAL] Left outer join question

Thanks much. Silly Me, I had an extraneous comma -Original Message- From: Raymond O'Donnell [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2008 8:12 PM To: Bill Reynolds Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Left outer join question On 08/10/2008 01:02,

[GENERAL] Left outer join question

Hey folks, stuck on something here and maybe I went down a dead end road. Is it possible to have a left outer join on 2 tables from the same originating table where T1 left outer joins to T2 and T1 left outer joins to T3? I guess I'm stuck on the FROM clause syntax or trying to do something yo

Re: [GENERAL] DELETE

Add the USING list clause: usinglist A list of table expressions, allowing columns from other tables to appear in the WHERE condition. This is similar to the list of tables that can be specified in the FROM Clause of a SELE