Re: function likes sprintf - Mailing list pgsql-general

From Tom Lane
Subject Re: function likes sprintf
Date
Msg-id 12139.982340847@sss.pgh.pa.us
Whole thread Raw
In response to Re: function likes sprintf  ("Mikhail V. Majorov" <mik@ttn.ru>)
List pgsql-general
"Mikhail V. Majorov" <mik@ttn.ru> writes:
> I use plpgsql becase this language permit to use SQL command.
> As I undestand I can't use SQL command from plperl or pltcl. Is it
> right?

Not so --- pltcl has "SPI" commands that let you issue SQL queries.
(plperl seems not to have the equivalent functionality yet, which is
a shame because it really hobbles plperl.)

See the documentation at
http://www.postgresql.org/devel-corner/docs/postgres/programmer-pl.htm
(this is for 7.1 but it mostly applies to the 7.0 release).

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: Re: PostgreSQL vs Oracle vs DB2 vs MySQL - Which should I use?
Next
From: Tom Lane
Date:
Subject: Re: Storing double-byte strings in text fields.