Re: [SQL] Calling the CTE for multiple inputs

2012-10-04 Thread Craig Ringer
On 10/05/2012 03:31 AM, air wrote: I have a CTE that takes top left and bottom right latitude/longitude values along with a start and end date and it then calculates the amount of user requests that came from those coordinates per hourly intervals between the given start and end date. However, I

Re: [SQL] String Search

2012-10-04 Thread David Johnston
> -Original Message- > From: [email protected] [mailto:pgsql-sql- > [email protected]] On Behalf Of Fabio Ebner - Dna Solution > Sent: Thursday, October 04, 2012 3:41 PM > To: [email protected] > Subject: [SQL] String Search > > Anyone know the best way to do one sel

Re: [SQL] Calling the CTE for multiple inputs

2012-10-04 Thread David Johnston
> -Original Message- > From: [email protected] [mailto:pgsql-sql- > [email protected]] On Behalf Of air > Sent: Thursday, October 04, 2012 3:32 PM > To: [email protected] > Subject: [SQL] Calling the CTE for multiple inputs > > I have a CTE that takes top left and bo

[SQL] String Search

2012-10-04 Thread Fabio Ebner - Dna Solution
Anyone know the best way to do one select in String field? tks -- Sent via pgsql-sql mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

[SQL] Calling the CTE for multiple inputs

2012-10-04 Thread air
I have a CTE that takes top left and bottom right latitude/longitude values along with a start and end date and it then calculates the amount of user requests that came from those coordinates per hourly intervals between the given start and end date. However, I want to execute this query for about