Re: + x * 31536000

Article View: dk.edb.database

Article #15210

#15210

From: Henrik Hansen
Date: Tue, 10 Jul 2001 07:43

22 lines
1589 bytes

Thomas Lundstr�m <thomas-l@mail.com> wrote:

 > Henrik Hansen wrote:
>> 
>>  > Jeg vil med een SQL querry finde alle felter som opfylder
>>  > 'felt = tal1 + x * tal2' hvor X tilh�rer {..., -3, -2, -1, 0, 1, 2, 3,
>>  > ...}
>> 
>> select felt from table where x in(1,2,3,4,5,6) and felt = tal1 + x * tal2
>> 
 > 
>mysql> SELECT felt FROM test WHERE x in(1,2,3) AND felt = 1+x*1;
 > Empty set (0.00 sec)
 > 
 > Dette giver efter min mening ikke nogle mening! 
 > Burde det ikke give 2,3 og 4 n�r:
 > 

og du har vel en v�rdi p� x's plads?

-- 
Henrik Hansen

Technical Details

Message-ID: <u1ynpkz54.fsf@mailserver.dk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!fr.usenet-edu.net!usenet-edu.net!news.tele.dk!not-for-mail

References:

<3B487A6C.112CCF35@mail.com> <9ia385$gi7$1@sunsite.dk> <3B49873B.DE1DC0F5@mail.com> <uwv5ifkci.fsf@mailserver.dk> <3B4A0030.18DA3295@mail.com>

Show Full Headers

Complete Article Headers

X-Google-Language: DANISH,ASCII
X-Google-Thread: fcdf9,c4586e5e5189cd3b
X-Google-Attributes: gidfcdf9,public
X-Google-ArrivalTime: 2001-07-10 00:41:34 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!fr.usenet-edu.net!usenet-edu.net!news.tele.dk!not-for-mail
Newsgroups: dk.edb.database
Subject: Re: + x * 31536000
References: <3B487A6C.112CCF35@mail.com> <9ia385$gi7$1@sunsite.dk>
 <3B49873B.DE1DC0F5@mail.com> <uwv5ifkci.fsf@mailserver.dk>
 <3B4A0030.18DA3295@mail.com>
From: Henrik Hansen <hh@mailserver.dk>
Date: Tue, 10 Jul 2001 09:43:19 +0200
Message-ID: <u1ynpkz54.fsf@mailserver.dk>
User-Agent: Gnus/5.090004 (Oort Gnus v0.04) Emacs/20.7
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 22
Organization: TDC Internet
NNTP-Posting-Host: 193.88.249.39
X-Trace: 994750893 dread02.news.tele.dk 378 193.88.249.39
X-Complaints-To: abuse@post.tele.dk

Reply to Parent Message