Re: Junk queries with variables? - Mailing list pgsql-sql

From Sean Davis
Subject Re: Junk queries with variables?
Date
Msg-id 006f01c51d88$1e60b820$1f6df345@WATSON
Whole thread Raw
In response to Re: Junk queries with variables?  ("Steve Valaitis" <steve@digitalnothing.com>)
List pgsql-sql
----- Original Message ----- 
From: "Steve Valaitis" <steve@digitalnothing.com>
To: "KÖPFERL Robert" <robert.koepferl@sonorys.at>; 
<pgsql-sql@postgresql.org>
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




pgsql-sql by date:

Previous
From: Aarni Ruuhimäki
Date:
Subject: Re: Read count ?
Next
From: Din Adrian
Date:
Subject: Re: SQL error: function round(double precision, integer) does not exist