X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9345652AA6 for ; Mon, 28 Feb 2005 11:24:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60162-10 for ; Mon, 28 Feb 2005 11:24:50 +0000 (GMT) Received: from mx5.net.nih.gov (mailfwd.nih.gov [165.112.130.36]) by svr1.postgresql.org (Postfix) with ESMTP id 63EF656628 for ; Mon, 28 Feb 2005 11:24:50 +0000 (GMT) Received: from mx5.net.nih.gov (localhost [127.0.0.1]) by mx5.net.nih.gov (8.12.10/8.11.6) with ESMTP id j1SBOqiS005340 for ; Mon, 28 Feb 2005 06:24:53 -0500 Received: from WATSON (vpn-165-112-10-39.net.nih.gov [165.112.10.39]) by mx5.net.nih.gov (8.12.10/8.11.6) with SMTP id j1SBOpQP005335; Mon, 28 Feb 2005 06:24:52 -0500 Message-ID: <006f01c51d88$1e60b820$1f6df345@WATSON> From: "Sean Davis" To: "Steve Valaitis" , =?iso-8859-1?Q?K=D6PFERL_Robert?= , References: Subject: Re: Junk queries with variables? Date: Mon, 28 Feb 2005 06:24:51 -0500 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.301 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/357 X-Sequence-Number: 20467 ----- Original Message ----- From: "Steve Valaitis" To: "KÖPFERL Robert" ; Sent: Thursday, February 24, 2005 12:15 PM Subject: Re: [SQL] Junk queries with variables? > > >> In pgadmins SQL-window SQL is the 'language' of choice. Or it is >> rather the >> only language. Thus if you intend to program plTk or PL/pgSQL, there's no >> way around defining a function. >> >> (At first you have to define a new language in your schema) > > I'm a little confused, is there no way around this, or are you saying I > need > to use CREATE LANGUAGE to define a new language to use? Currently the only > language I have for the DB is plpgsql. Yes. You need to install the language into the database using CREATE LANGUAGE and then you can use the language to create functions. Sean