<[EMAIL PROTECTED]> writes:
> I have PostgreSQL v7.02 in RedHat 6.2;
>
> I have problem with is Query:
> select name, 'user' as class from smuser u=
> nion=20
> select name, 'group' as class from smgroup order by class;
>
Please turn off HTML mail :-(
The problem is with the nonspecific-typ
On Mon, 8 Jan 2001 15:50:42 -0400, <[EMAIL PROTECTED]> wrote:
> I have PostgreSQL v7.02 in RedHat 6.2;
>
> I have problem with is Query:
> select name, 'user' as class from smuser union select name, 'group' as class from
>smgroup order by class;
>
> sentence problem is:{ order by class}
>
I have PostgreSQL v7.02 in RedHat 6.2;
I have problem with is Query:
select name, 'user' as class from smuser union
select name, 'group' as class from smgroup order by class;
sentence problem is:{ order by class}
thank you,
Christian Gonzalez
Hi.
I'm trying to compile 7.0.3 on a MIPS1 R3000 processor under NetBSD.
It pukes on the infamous s_lock.c file because of some assembler
that's expecting a MIPS2 processor.
gcc -I../../../include -I../../../backend -O2 -pipe -Wall -Wmissing-
prototypes -Wmissing-declarations -I../.. -c -
On Sun, 14 Jan 2001, Michael Richards wrote:
> I do not understand how this can possibly be correct unless NULL is
> not permitted in a function.
>
> In one case, I've got:
> WHERE value= $1
> Which is called with NULL and therefore should be:
> WHERE value= NULL
> This fails.
Right, but value
I do not understand how this can possibly be correct unless NULL is
not permitted in a function.
In one case, I've got:
WHERE value= $1
Which is called with NULL and therefore should be:
WHERE value= NULL
This fails.
The other case which is logically equivalent I've got:
WHERE value= $1 OR ($1=
[EMAIL PROTECTED] writes:
> ez_money=> select '10/01/2000'::date+'1 month'::interval;
> ?column?
> --
> 2000-10-31 23:00:00+01
> (1 row)
DST transition problem. It's fixed in current sources.
regards, tom lane
Laurent HERVE ([EMAIL PROTECTED]) reports a bug with a severity of 3
The lower the number the more severe it is.
Short Description
Strange results with interval types computations
Long Description
Look at those two queries :
ez_money=> select '10/01/2000'::date+'1 month'::interval;
?column?
---
[EMAIL PROTECTED] writes:
> Problem description:
> The nightly cron jobs return me the following message:
>
> dumpClasses(): command failed. Explanation from backend: 'pqReadData() -- backend
>closed the channel unexpectedly.
> This probably means the backend terminated abnormally
>
Saku Airila ([EMAIL PROTECTED]) reports a bug with a severity of 1
The lower the number the more severe it is.
Short Description
Database corruption in RH 6.2/prepackaged PG
Long Description
Random database corruption. The system I'm running has ~10 databases
online on a single server without ot
On Sun, 14 Jan 2001, Michael Richards wrote:
> Hi.
>
> I'm using 7.0.3 and I've found a bug:
>
> create table test(value int4);
> create function testfunc(int4)
> RETURNS bool AS
> 'SELECT count(*)>0 AS RESULT FROM test where value= $1'
> language 'SQL';
>
> So I want this
11 matches
Mail list logo
