----- Original Message ----- From: "Steve Valaitis" <[EMAIL PROTECTED]>
To: "KÖPFERL Robert" <[EMAIL PROTECTED]>; <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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
