> -----Original Message-----
> From: Andrew Piskorski [mailto:[EMAIL PROTECTED]
> Sent: Sunday, May 02, 2004 12:09 PM
> To: Puneet Kishor
> Cc: D. Richard Hipp; SQLite
> Subject: Re: [sqlite] CONCAT in SQLite (was Re: [sqlite]
> correct syntax
> for CASE...)
>
>
> On Sun, May 02, 2004 at 01:59:34PM -0500, Puneet Kishor wrote:
>
> > >Probably you mean the concatenate operator, which in
> > >SQL is ||, not &. & is not an SQL operator as far as
>
> > drats... concat is '+' in Javascript, '.' in Perl, '&' in
> Access and
> > SQL Server, '||' in SQlite, and, well, 'CONCAT' in Oracle.
> Why can't
> > the entire world just speak Hindi ;-).
>
> It is '||' in Oracle, and I believe PostgreSQL as well. 'CONCAT' may
> also work there, but if so I've never seen it used.
>
CONCAT is used in a few DBMS's as it allows one to use a function call instead of an
(infix?) operator.
E.g.
select concat('Hello', ' world') from mytable
Obviously many nested uses of concat() can look rather hairy...
As a side note SQL Server also uses "+" (I think "&" was just added to keep Access
users happy :-p).
Chris
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
