Received: from sujebi.rental.co.kr (IDENT:root@[210.180.244.194]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA42619 for ; Wed, 16 Jun 1999 20:42:16 -0400 (EDT) (envelope-from dogget@rental.co.kr) Received: from ws196.rental.co.kr (ws200.rental.co.kr [210.180.244.200] (may be forged)) by sujebi.rental.co.kr (8.9.3/8.9.1a) with SMTP id JAA01635 for ; Thu, 17 Jun 1999 09:42:11 +0900 Message-ID: <003e01beb85a$3ce412e0$c8f4b4d2@ws196.rental.co.kr> From: "Oh Hyun-Su" To: Subject: [SQL] Optimizing query inside a function Date: Thu, 17 Jun 1999 09:42:11 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="euc-kr" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from base64 to 8bit by hub.org id UAA42624 First of all, sorry for my English. I hope you can understand me. ;) I made a function using pl/sql. It seems that optimizer doesn't work in the query inside function. Of course, if I excute the same query outside function, optimizer works well and uses proper index. Is it true that queries inside a function cannot be optimized? or is there a way I can optimize my query inside a function? My pgsql version is 6.4.2. Thanks in advance! Hyun-Su Oh