From: | Doug Thistlethwaite <doug(dot)t(at)deltanet(dot)com> |
---|---|
To: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
Cc: | pgsql-sql(at)postgreSQL(dot)org, jens(at)jens(dot)de |
Subject: | Re: [SQL] combining columns in select |
Date: | 1999-10-10 05:04:38 |
Message-ID: | 38001E65.8155F291@deltanet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
What I was trying to do is develop a java application using the ODBC and then
move it to postgres & a linux database when I had everything working.
Unfortunately, I have discovered that there are many differences in the
"standard SQL" that each driver uses.
I could not find any ODBC drivers that us local data that allow the "||"
concatenation symbol. Most of them use the "+" symbol. I have found the same
problem with "Memo" vs "text" fields as well. The ODBC driver for dbase (the
one which seems to work best in my case) also uses the # symbol for dates
while postgres likes the ' symbol.
I guess I have to live with this and write separate query statements for each
implementation.
Doug
Herouth Maoz wrote:
> At 03:15 +0200 on 03/10/1999, "D'Arcy" "J.M." Cain wrote:
>
> > While you are correct in your solution, it isn't a parser bug. It just
> > follows the spec. There has been talk of allowing the first form as
> > an extension.
>
> Since when has "+" become the string concatenation operator? It used to be
> "||" last time I checked.
>
> Herouth
>
> --
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
> http://telem.openu.ac.il/~herutma
From | Date | Subject | |
---|---|---|---|
Next Message | Steffen Emil Thorkildsen | 1999-10-10 08:29:19 | How can I define my alphabet? |
Previous Message | Duncan Kinder | 1999-10-09 23:19:10 | set option question |