Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Given 02-01-2006 to 02-28-2006, output all days.
Date: Fri, 17 Feb 2006 15:08:11 -0800
Message-ID: <144D12D7DD4EC04F99241498BB4EEDCC220D78@nelson.osl.com>
Thread-Topic: [SQL] Given 02-01-2006 to 02-28-2006, output all days.
Thread-Index: AcY0DmMtHsBhr5sdQQ6ULXDmtfWkUwAB66Ww
From: "Owen Jacobson" <ojacobson@osl.com>
To: "Henry Ortega" <juandelacruz@gmail.com>
Cc: <pgsql-sql@postgresql.org>

That usually indicates that, for whatever reason, plpgsql.so is from a =
different version of PostgreSQL than the database server.  If you =
installed PostgreSQL from source, make sure you configured the server to =
look in the same lib dir as its libs were installed to; if you've =
installed from package management of some kind (RPM?) make sure you have =
the same versions of all postgres-related packages.

You should also upgrade, if possible.  7.3 is effectively obsolete (37 =
releases old); there are a number of bugfixes and performance =
improvements in more recent versions.

-Owen

-----Original Message-----
From: Henry Ortega [mailto:juandelacruz@gmail.com]
Sent: Friday, February 17, 2006 2:06 PM
To: Owen Jacobson
Subject: Re: [SQL] Given 02-01-2006 to 02-28-2006, output all days.


This sounds good. I don't have plpgsql loaded though.

I am trying to load plpgsql and it's giving me:
ERROR:  Load of file /usr/lib/pgsql/plpgsql.so failed: =
/usr/lib/pgsql/plpgsql.so: undefined symbol: xlateSqlType=20
createlang: language installation failed

I have pgsql 7.3.2
I am googling and can't seem to find the answer. Any help would be =
appreciated.


On 2/17/06, Owen Jacobson <ojacobson@osl.com> wrote:
Henry Ortega wrote:

(question about set of all days between two dates)

I don't know of a builtin way to do it off the top of my head, but it's =
a pretty simple function to write:

create function days (start date, finish date) returns setof date as $$=20
declare
  curdate date;
begin
  curdate :=3D start;
  while (curdate <=3D finish) loop
    return next curdate;
    curdate :=3D curdate + 1;
  end loop;
  return;
end;
$$ language plpgsql;

# select * from days ('2006-02-01', '2006-02-07');
    days
------------
2006-02-01
2006-02-02
2006-02-03
2006-02-04
2006-02-05
2006-02-06
2006-02-07
(7 rows)


---------------------------(end of broadcast)--------------------------- =

TIP 5: don't forget to increase your free space map settings