Re: Junk queries with variables?

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Steve Valaitis" <steve(at)digitalnothing(dot)com>, KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Junk queries with variables?
Date: 2005-02-28 11:24:51
Message-ID: 006f01c51d88$1e60b820$1f6df345@WATSON
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


----- 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Aarni Ruuhimäki 2005-02-28 13:08:27 Re: Read count ?
Previous Message Din Adrian 2005-02-28 10:43:11 Re: SQL error: function round(double precision, integer) does not exist