Re: Junk queries with variables?

----- Original Message -----
From: "Steve Valaitis" <steve(at)digitalnothing(dot)com>
To: "KÖPFERL Robert" <robert(dot)koepferl(at)sonorys(dot)at>;
<pgsql-sql(at)postgresql(dot)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