pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: skip weekends
3+ messages / 3 participants
[nested] [flat]
* Re: skip weekends
@ 2002-06-21 06:08 Rudi Starcevic <rudi@oasis.net.au>
2002-06-21 07:43 ` Re: skip weekends Cliff Wells <logiplexsoftware@earthlink.net>
2002-06-21 19:37 ` Re: skip weekends Josh Berkus <josh@agliodbs.com>
0 siblings, 2 replies; 3+ messages in thread
From: Rudi Starcevic @ 2002-06-21 06:08 UTC (permalink / raw)
To: pgsql-sql
Hello,
Nice reply Josh.
I wouldn't call your solution 'ugly' at all.
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.
My only problem is trying to decide on whether to use PL/pgSQL or PLPerl.
Cheers
Rudi
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: skip weekends
2002-06-21 06:08 Re: skip weekends Rudi Starcevic <rudi@oasis.net.au>
@ 2002-06-21 07:43 ` Cliff Wells <logiplexsoftware@earthlink.net>
1 sibling, 0 replies; 3+ messages in thread
From: Cliff Wells @ 2002-06-21 07:43 UTC (permalink / raw)
To: Rudi Starcevic <rudi@oasis.net.au>; +Cc: pgsql-sql
On Thu, 2002-06-20 at 23:08, Rudi Starcevic wrote:
> Hello,
>
> Nice reply Josh.
> I wouldn't call your solution 'ugly' at all.
>
> 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.
> My only problem is trying to decide on whether to use PL/pgSQL or PLPerl.
You might also consider PL/Python. I haven't used it, but I use Python
a lot outside of PG and it's an excellent language.
http://developer.postgresql.org/docs/postgres/plpython.html
Regards,
Cliff
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: skip weekends
2002-06-21 06:08 Re: skip weekends Rudi Starcevic <rudi@oasis.net.au>
@ 2002-06-21 19:37 ` Josh Berkus <josh@agliodbs.com>
1 sibling, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2002-06-21 19:37 UTC (permalink / raw)
To: Rudi Starcevic <rudi@oasis.net.au>; pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-06-21 19:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-06-21 06:08 Re: skip weekends Rudi Starcevic <rudi@oasis.net.au>
2002-06-21 07:43 ` Cliff Wells <logiplexsoftware@earthlink.net>
2002-06-21 19:37 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox