[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

[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 (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] Calling the CTE for multiple inputs

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

Re: [SQL] String Search

2012-10-04 Thread David Johnston
> -Original Message- > From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of Fabio Ebner - Dna Solution > Sent: Thursday, October 04, 2012 3:41 PM > To: pgsql-sql@postgresql.org > 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 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