On 04/14/10 08:33, Feixiong Li wrote:
Hi , guys ,
I am newbie for sql, I have a problem when using max() function, I need
get null when there are null in the value list, or return the largest
value as usual, who can do this?
i.e. max([1,2,3,4,5]) => 5
max([1,2,3,4,5,null]) => null
if u want a
Hi everyone, here is my problem :
I got two tables :
CREATE TABLE "public"."calendar_temp" (
"id" SERIAL,
"dat" DATE,
"heur" TIME WITHOUT TIME ZONE,
CONSTRAINT "calendar_temp_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;
CREATE TABLE "public"."h_part" (
"idh" SERIAL,
"poste_idposte" INTE
Hi, Thomas.
I believe it is because of your WHERE clause, which is filtering out the nulls
from hp table.
According to
WHERE
hp.poste_idposte = 275
You only want registers that have hp.poste_idposte = 275, not the null ones.
HTH
Best,
Oliveiros
- Original Message -
Fr
Hi Tom,
> >> This is a select query. I don't think that's the right error message.
>
> > Yes, but IS the correct error message.
>
> The query being complained of appears to be a generated foreign key
> checking query. It's not surprising it would appear in the context
> of an insert.
Yes,
On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado
wrote:
> Hi Tom,
>
>
>
>> >> This is a select query. I don't think that's the right error message.
>>
>> > Yes, but IS the correct error message.
>>
>> The query being complained of appears to be a generated foreign key
>> checking query.
Try moving the hp.poste_idposte=275 inside the LEFT JOIN condition, somethin
like :
SELECT ct.dat,ct.heur,hp.datmesure,hp.heuremesure,hp.t FROM calendar_temp as ct
LEFT OUTER JOIN h_part as hp
ON (ct.dat = hp.datmesure
AND ct.heur = hp.heuremesure
AND hp.poste_idposte = 275)
ORDER BY ct.dat,
Scott Marlowe writes:
> On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado
> wrote:
>> Maybe but I ran even grant all on schema public for this user to check
>> if this was the problem.
> That doesn't do what you think it does. You need to grant on the actual
> object.
The error he was
In article <987929295d1345b5bce249f42730c...@marktestcr.marktest.pt>,
"Oliveiros" writes:
> Hi, Thomas.
> I believe it is because of your WHERE clause, which is filtering out the nulls
> from hp table.
> According to
> WHERE
> hp.poste_idposte = 275
> You only want registers that have hp.post
Hi Tom,
This may be a clue... Will check
El mié, 21-04-2010 a las 11:23 -0400, Tom Lane escribió:
> Scott Marlowe writes:
> > On Wed, Apr 21, 2010 at 7:25 AM, Gonzalo Aguilar Delgado
> > wrote:
> >> Maybe but I ran even grant all on schema public for this user to check
> >> if this was the pro
Hi,
> SELECT ct.dat,ct.heur,hp.datmesure,hp.heuremesure,hp.t FROM
calendar_temp as ct
> LEFT OUTER JOIN h_part as hp
> ON ct.dat = hp.datmesure
> AND ct.heur = hp.heuremesure
> WHERE
> hp.poste_idposte = 275
> ORDER BY ct.dat, ct.heur
> dat heur datmesure heu
10 matches
Mail list logo