X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 3F72DD1C4DC for ; Mon, 21 Jul 2003 12:08:33 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 98738-09 for ; Mon, 21 Jul 2003 12:08:31 +0000 (GMT) Received: from mail.ramprecision.com (unknown [65.88.137.140]) by svr1.postgresql.org (Postfix) with ESMTP id C97AED1C4C7 for ; Mon, 21 Jul 2003 09:08:28 -0300 (ADT) Received: from exchanger.ramprecision.com ([192.168.170.3] helo=srv-03.ramprecision.com) by mail.ramprecision.com with esmtp (Exim 4.20) id 19eZSy-0003qE-DK for pgsql-sql@postgresql.org; Mon, 21 Jul 2003 07:08:32 -0500 Received: by SRV-03 with Internet Mail Service (5.5.2653.19) id ; Mon, 21 Jul 2003 08:10:53 -0400 Message-ID: <71650A6F73F1D411BE8000805F65E3CB3B3457@SRV-03> From: jwsacksteder@ramprecision.com To: pgsql-sql@postgresql.org Subject: query or function Date: Mon, 21 Jul 2003 08:10:43 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: * X-Archive-Number: 200307/305 X-Sequence-Number: 14419 I need to create a set for use in a query that includes all dates between a start and ending date. Is this something I can do with a simple sql statement or do I need to make a function for this?