[Koha-patches] [PATCH] [followup](MT3160) fix address request

[Michael Hafen]

I wasn't sure if CONCAT_WS was part of the SQL spec.  I only mention it
as a courtesy because I've only recently learned about it myself.  I've
found it to be a pretty slick function.

With a quick google search it seems PostgreSQL does have the same
function.  I suspect that if it isn't in the SQL spec. it is
unofficially supported on some DBMS's.  I just talked with a couple of
our other guys here, and Oracle nor MS SQL have this function.

Yeah, I don't think this should be used in Koha at this point since we
are trying to avoid function specific to a certain RDBMS.

On Wed, 2010-06-30 at 20:03 -0400, Owen Leonard wrote:
> On Wed, Jun 30, 2010 at 11:03 AM, Michael Hafen
> <mdhafen at tech.washk12.org> wrote:
> > I have found in Mysql that CONCAT_WS handles NULL values well.  Have you
> > looked into that?  The syntax is a little different from CONCAT.
> 
> Aren't we trying to avoid functions which are MySQL-specific?
> 
>   -- Owen
> 

-- 
Michael Hafen
Systems Analyst and Programmer
Washington County School District
Utah, USA

for Koha checkout
http://development.washk12.org/gitweb/
or
git://development.washk12.org/koha