Received: from shaked.cc.openu.ac.il (shaked.cc.openu.ac.il [147.233.145.65]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA22805 for ; Tue, 16 Jun 1998 05:12:59 -0400 (EDT) Received: from [147.233.159.109] (herouth@mac-herouth.pc.openu.ac.il [147.233.159.109]) by shaked.cc.openu.ac.il (8.8.5/8.8.5) with ESMTP id MAA06206; Tue, 16 Jun 1998 12:12:45 +0300 (IDT) X-Sender: herouth@shaked.cc.openu.ac.il Message-Id: In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Date: Tue, 16 Jun 1998 12:12:52 +0300 To: lynch@lscorp.com (Richard Lynch), pgsql-sql@postgreSQL.org From: Herouth Maoz Subject: Re: [SQL] cast text as date At 11:14 +0300 on 16/6/98, Richard Lynch wrote: > I've never created a function of my own, and maybe that's the way to go, > but I'm not sure where to start... > The strings in question actually only have a month/year (no date), if that > matters (they're expirations)... > The resulting date can just default to 1 for the date. What version of Postgres, and what error, exactly, did it report? Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma