Hi all,
Testing a port from Oracle to PG 7.1.3. onto PG 7.2 has error trying to use the
following function (frop OpenACS, to port connect by Oracle statments under PG):
create function tree_level(varchar) returns integer as '
declare
inkey alias for $1;
cnt integer def
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Can someone explain why this fixes the problem.
>
> Think about a machine where char is signed by default. Extracting \254
> into an int will produce -2, which will not equal \254 returned by getc.
Oh, I thought that the int return
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Can someone explain why this fixes the problem.
Think about a machine where char is signed by default. Extracting \254
into an int will produce -2, which will not equal \254 returned by getc.
regards, tom lane
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > I have a major problem with string joining in sql query in Postgresql 7.1.3. It is
>always return null string if any of column has null value.
>
> This is not a bug. SQL92 6.13 general rule 2a saith:
>
> a) If either S1 or S2 is the nu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
i configure my PSQL and came across with problem - i cannot use my psql
console with history & readline
i typed psql -V and saw
psql (PostgreSQL) 7.1.3
contains multibyte support
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
I'm also having problems with Postgres' JDBC driver and the tag
libraries. I have a JSP page which selects everything from a table, and
prints it out.
Workaround: back up to using "jdbc7.0-1.2.jar" (or "pgjdbc1.jar", if
you don't need all the Java2 JDBC stuff.)
jdbc7.1-1.2.jar - fet
Can someone explain why this fixes the problem. I thought it was safe
to assign a char to an int and do a compare. The compare I see is:
if (c == delimc)
break;
---
Darcy Buskermo
Darcy Buskermolen <[EMAIL PROTECTED]> writes:
> Postgres was not compiled with Multibyte, if I replace the if (delimc == c)
> with if (strstr(delim,c)) it works as expected. This changes was
> implemented for performance reasons according to the CVS log.
Yeah, my error :-(. See Tatsuo's reply fo
This patch solves the problem.
At 09:16 PM 2/26/02 +0900, Tatsuo Ishii wrote:
>> When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the
>> delimiter and ends up with parse errors when trying to do the insert
>>
>>
>> What the ?? why dind' tthat go through with the body of the tex
Postgres was not compiled with Multibyte, if I replace the if (delimc == c)
with if (strstr(delim,c)) it works as expected. This changes was
implemented for performance reasons according to the CVS log.
At 11:57 PM 2/25/02 -0500, Tom Lane wrote:
>Darcy Buskermolen <[EMAIL PROTECTED]> writes:
>>
[EMAIL PROTECTED] writes:
> I have a major problem with string joining in sql query in Postgresql 7.1.3. It is
>always return null string if any of column has null value.
This is not a bug. SQL92 6.13 general rule 2a saith:
a) If either S1 or S2 is the null value, then the result o
[EMAIL PROTECTED] writes:
> time('now') used to work but it doesn't work anymore in PostgreSQL 7.2.
TIME is a reserved word now, or at least more reserved than it used to
be, because we've added some SQL92 syntax that wasn't supported before.
Try
"time"('now')
or
'now'::time
or
Erol Ozcan ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
string join problem
Long Description
I have a major problem with string joining in sql query in Postgresql 7.1.3. It is
always return null string if any of column has
Ricardo Ryoiti Sugawara Junior ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
time() problems with PostgreSQL 7.2
Long Description
time('now') used to work but it doesn't work anymore in PostgreSQL 7.2.
Sample Code
carteirinh
> When useing COPY FROM 'file' DELIMITER '\254' copyfrom reads past the
> delimiter and ends up with parse errors when trying to do the insert
>
>
> What the ?? why dind' tthat go through with the body of the text.. *sigh*
> I'll resend in the AM..
Good catch. It's definitely a bug in copy com
15 matches
Mail list logo
