Hello
a := exprx
is internally translated :
get result of SELECT exprx
and store it to a
so you can write select sin(10); then you can a := sin(10)
but you can too use subselect like:
SELECT (SELECT v FROM foo LIMIT 1) ~ you can write
a := (SELECT v FROM foo LIMIT 1);
that is equal to S
Στις Tuesday 04 December 2007 14:59:43 ο/η Pavel Stehule έγραψε:
> On 04/12/2007, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> > I noticed that in pl/pgsql simply
> > result := funcname(func,args,...);
> > just works.
> > Should i rely on it or take it as a coincidence? :)
>
> You found assignme
On 04/12/2007, Achilleas Mantzios <[EMAIL PROTECTED]> wrote:
> I noticed that in pl/pgsql simply
> result := funcname(func,args,...);
> just works.
> Should i rely on it or take it as a coincidence? :)
You found assignment :). Sure, you can use it.
http://www.postgresql.org/docs/8.2/interactive/pl
I noticed that in pl/pgsql simply
result := funcname(func,args,...);
just works.
Should i rely on it or take it as a coincidence? :)
--
Achilleas Mantzios
---(end of broadcast)---
TIP 6: explain analyze is your friend
considdered CASTs?
These are just ideas
|-Original Message-
|From: Jan B. [mailto:[EMAIL PROTECTED]
|Sent: Sonntag, 22. Mai 2005 11:24
|To: [email protected]
|Subject: [SQL] Calling Functions in RULEs
|
|
|Hello,
|
|I would like to call multiple PL/pgSQL procedures (i.e. functions
Hello,
I would like to call multiple PL/pgSQL procedures (i.e. functions
returning void) from INSERT, UPDATE and DELETE RULEs.
Using "SELECT some_procedure();" is a possible way to do that, but it
causes a dummy result table to be delivered to the application invoking
the INSERT/UPDATE/DELET
On Fri, Mar 25, 2005 at 07:53:46AM -0800, Moran.Michael wrote:
> Anyway, by far, this Posgres SQL forum is the best forum I've encountered
> for finding answers to questions like mine below. Much better than the
> Hackers or Admin forums it seems.
Some subjects are off-topic for some mailing list
ding answers to questions like mine below. Much better than the
Hackers or Admin forums it seems.
Thanks all!
-Michael Moran
_
From: Jim Buttafuoco [mailto:[EMAIL PROTECTED]
Sent: Thu 3/24/2005 7:44 PM
To: Moran.Michael; [email protected]
Subject: Re: [SQL] Calling functions f
t;
To: [email protected]
Sent: Thu, 24 Mar 2005 17:30:33 -0800
Subject: [SQL] Calling functions from Delete View (+ contrib/pgcrypto) =
madness ??
> Hello there,
>
> I have a View with a Delete rule and I would like the Delete rule to call a
> function (and pass-in a few of the t
Hello there,
I have a View with a Delete rule and I would like the Delete rule to call a
function (and pass-in a few of the the underlying View's/Table's column
values). How do you do this?
When I do it, I keep getting the following error:
ERROR: function expression in FROM may not refer to ot
Oleg,
> Hi,
> this is a very silly question, but how do I run PL/pgSQL function
> from SQL?
> I created a function test(varchar, varchar) and I am trying to invoke
> it with
> parameters 'hello', 'world' using an SQL statement. I tried selects
> and executes
> - nothing works.
> Please help,
SEL
Em 02 Apr 2001, Josh Berkus escreveu:
>BEGIN WORK;
>COMMIT WORK;
In time... I think that could be great if postgresql implement a commit
inside functions.
Abracos,
Edipo Elder
[[EMAIL PROTECTED]]
_
Oi! Você quer u
Edipo,
> FUNCTION (...) AS '(...)BEGIN
> PERFORM FUNCTION1();
> PERFORM FUNCTION2();
> (...)
> END;' LANGUAGE 'PLPGSQL';
I'm not sure about that syntax (PERFORM). I ususally set my functions
equal to a value ('remote_result := Function1(paramater)'). This has
the added advantage of lett
On Mon, Apr 02, 2001 at 08:50:32AM -0300, Edipo Elder Fernandes de Melo wrote:
>
> and, for my surprise, it take minutes to run. I read the documentation
> and I didn't found any coment abou this behavior. Can anyone explain this?
Cool, one more Brazilian in the list :)
I
Hi all,
I wrote a function that call another functions, like this:
FUNCTION (...) AS '(...)BEGIN
PERFORM FUNCTION1();
PERFORM FUNCTION2();
(...)
END;' LANGUAGE 'PLPGSQL';
The problem is that takes a long time to execute (I stoped after three
days executing). To see
15 matches
Mail list logo
