On Mon, 8 Oct 2001, Aasmund Midttun Godal wrote:
> 1. Is there a plperlu? ... unsafe version of perl?
In 7.2, there will be. In 7.1, you have to apply patches manually.
> 2. Is it possible to select which packages the plperl should have access to?
In 7.2, plperlu can do anything. plperl in eithe
On Fri, 5 Oct 2001, Bruce Momjian wrote:
>
> What actually should happen is that the view should go away at the end
> of the session. However, unlike indexes, we can have several tables
> involved in a view so it is hard to know exactly how to handle this.
>
> Seems like a TODO item, at least.
On Sun, 23 Sep 2001, Stephan Szabo wrote:
> On Sun, 23 Sep 2001, Alex Pilosov wrote:
>
> > It may be just me, or I am grossly misunderstanding syntax of outer joins,
> > but I see that plans for my queries are different depending on how I place
> > join conditions and so
It may be just me, or I am grossly misunderstanding syntax of outer joins,
but I see that plans for my queries are different depending on how I place
join conditions and sometimes even on order of the tables.
Basically, if I mix ANSI-syntax outer joins (a left outer join b on
a.id=b.id) and "wher
On Mon, 10 Sep 2001, Stephan Szabo wrote:
>
> On Mon, 10 Sep 2001, Alex Pilosov wrote:
>
> > On Mon, 10 Sep 2001, Stephan Szabo wrote:
> >
> > > On Mon, 10 Sep 2001, Jeff Barrett wrote:
> > >
> > > > How can I call a shell script from within
On Mon, 10 Sep 2001, Stephan Szabo wrote:
> On Mon, 10 Sep 2001, Jeff Barrett wrote:
>
> > How can I call a shell script from within a pl/pgsql function that is called
> > as from a trigger. I do not want to interact with the script I just want it
> > to run. I do want the trigger to wait for th
On Thu, 23 Aug 2001, Tom Lane wrote:
> "Josh Berkus" <[EMAIL PROTECTED]> writes:
> >> What's the correct syntax to return two VARCHAR(255)?
>
> > There isn't one. At this time, functions cannot return arrays.
>
> Well, they *can*, it's just that there's no syntax to support
> constructing an a
g worked
> on. Is it?
>
> > -Original Message-----
> > From: Alex Pilosov [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 11, 2001 10:03 AM
> > To: Peter Eisentraut
> > Cc: R Vijayanath; [EMAIL PROTECTED]
> > Subject:Re: can
On Wed, 11 Jul 2001, Peter Eisentraut wrote:
> R Vijayanath writes:
>
> > It would be great if you can tell me if I can write a
> > procedure that can write the output to the OS(Linux
> > OS) file.
>
> You could try out PL/sh for that.
>
> http://www.postgresql.org/~petere/plsh.html
Well, as l
Currently, this is not possible.
It will be possible in 7.2, or with a patch I'm working on...
On Mon, 9 Jul 2001, Alvar Freude wrote:
> Hi,
>
> I want to create a function (PL/pgSQL), which return multiple rows. But it
> fails -- when Creating the function, I get a notice:
>
> NOTICE: Pro
we do this? Please help.
>
> Thank you very much,
>
> Markus
>
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [EMAIL P
On Wed, 21 Feb 2001, Jeff MacDonald wrote:
> 1: can you call other stored procedures from within pl/Perl
No.
> 2: from within a pl/Perl script , can i do a select etc..
>i'm assuming no, because you cannot use DBI.. but just wondering
>if there is a way..
Not currently.
> 3: installing
Get an SQL book.
select * from basket
where date=(select max(date) where fruit='Apples)
and fruit='Apples';
On Thu, 15 Feb 2001, Steve Meynell wrote:
> Ok what I am trying to do is select out of the database the latest
> record meeting a certain criteria.
>
> Example:
>
> Number
Um, no.
You should run vacuum analyze AFTER you loaded up the data, otherwise,
your table statistics will be all wrong (it'll contain 'empty table'
statistics).
-alex
On Thu, 8 Feb 2001, Brice Ruth wrote:
> Stephan,
>
> Here is what EXPLAIN shows:
>
> NOTICE: QUERY PLAN:
>
> Sort (cost=0.0
14 matches
Mail list logo
