Article View: dk.edb.database
Article #15247Re: Parameteriseret view i postgresql
From: Jonas Delfs
Date: Sun, 17 Jun 2001 21:33
Date: Sun, 17 Jun 2001 21:33
19 lines
1830 bytes
1830 bytes
"Morten Breum Mikkelsen" <mbreum@odense.kollegionet.dk> skrev i en meddelelse news:9gj2lg$qg4$1@sunsite.dk... > > Kan man ikke bare > > select asdf, zxcv from myview WHERE qwer=ghjk > > S� fjerner jeg vel den optimering ved at bruge WHERE-statements i > sub-selects /inden/ jeg joiner? Overlever du ikke med et enkelt statement i din WHERE-klausul? Jeg aner ikke hvordan du overhovedet kunne forestille dig at det skulle fungere - et view er jo dybest set bare en tabel baseret p� data fra en anden tabel. Du kan da heller ikke parametisere et query til en "nomal" tabel ? -- Mvh. Jonas Delfs, http://delfs.dk "Rigtige m�nd scorer p� ICQ" -Christian J�rgensen
Technical Details
Message-ID:
<9gj7j1$dk$1@sunsite.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!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mailReferences:
<9gd497$31n$1@sunsite.dk> <3B2A22EC.7C3B785E@netgroup.dk> <9gj2lg$qg4$1@sunsite.dk>Show Full Headers
Complete Article Headers
X-Google-Language: DANISH,ASCII X-Google-Thread: fcdf9,455e7c36f3b70c82 X-Google-Attributes: gidfcdf9,public X-Google-ArrivalTime: 2001-06-17 14:31:46 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!news.tele.dk!212.54.64.131!news100.image.dk!sunsite.dk!not-for-mail From: "Jonas Delfs" <jonas@nospam.delfs.dk> Newsgroups: dk.edb.database Subject: Re: Parameteriseret view i postgresql Date: Sun, 17 Jun 2001 23:33:28 +0200 Organization: SunSITE.dk - Supporting Opensource Software Lines: 21 Sender: jonas@131.165.143.165 Message-ID: <9gj7j1$dk$1@sunsite.dk> References: <9gd497$31n$1@sunsite.dk> <3B2A22EC.7C3B785E@netgroup.dk> <9gj2lg$qg4$1@sunsite.dk> NNTP-Posting-Host: 131.165.143.165 X-Trace: sunsite.dk 992813473 436 131.165.143.165 (17 Jun 2001 21:31:13 GMT) X-Complaints-To: news@sunsite.dk NNTP-Posting-Date: Sun, 17 Jun 2001 21:31:13 +0000 (UTC) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.3018.1300 X-Authenticated: jonas@delfs.dk