From: "Josh Berkus" <josh@agliodbs.com>
Subject: Re: skip weekends
To: Rudi Starcevic <rudi@oasis.net.au>, pgsql-sql@postgresql.org
Date: Fri, 21 Jun 2002 12:37:27 -0700
Message-ID: <web-1552113@davinci.ethosmedia.com>
In-Reply-To: <3D12C2C0.2040904@oasis.net.au>
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit

Rudi,

> Nice reply Josh.
> I wouldn't call your solution 'ugly' at all.

Actually I posed te question, and Joe Conway offered the solution.
 I'll be testing and reporting back.

> It's an excellent example of a real world need for Postgresql
> functions.
> I've also been looking at other functions at
> http://www.brasileiro.net/postgres/cookbook/.
> I noticed your name amongst the author's -- nice one -- keep up the
> good work.

Yes.  Sadly, Roberto seems to have lost interest in PostgreSQL, so the
cookbook is frozen.  <frown>  For example, There's a couple of bugs in
name_alike I'd like to fix, but I can't correct them and Roberto
doesn't answer his e-mail.   Anybody wanna take over the Cookbook?

> My only problem is trying to decide on whether to use PL/pgSQL or
> PLPerl.

Use them both.  PL/Perl is better at text parsing, loops and arrays.
 PL/pgSQL is faster for data operations.  Use the best tool for the
job!

One thing I'd love to see is a generic address tokenizer, so that I can
write an "address_alike" function.   My Perl isn't up to it.

Heck, a generic string tokenizer would be even more useful.  Can a
PL/Perl function return an array?

-Josh