From: Sean Davis <sdavis2@mail.nih.gov>
To: Steve Valaitis <steve@digitalnothing.com>
To: KÖPFERL Robert <robert.koepferl@sonorys.at>
To: pgsql-sql@postgresql.org
Subject: Re: Junk queries with variables?
Date: Mon, 28 Feb 2005 06:24:51 -0500
Message-ID: <006f01c51d88$1e60b820$1f6df345@WATSON> (raw)
References: <LDEHKBBOEMIJKHKBOFNFCEHGLLAA.steve@digitalnothing.com>
----- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sdavis2@mail.nih.gov, steve@digitalnothing.com, robert.koepferl@sonorys.at
Subject: Re: Junk queries with variables?
In-Reply-To: <006f01c51d88$1e60b820$1f6df345@WATSON>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox