Yes, your varlena links are what I was looking for as a source of help...
Thanks!
Mark
Michael Fuhr wrote:
On Thu, May 19, 2005 at 03:17:07PM -0400, Mark Fenbers wrote:
I need to create an aggregate function to do some math not currently
provided by the available tools. Can someone point to
I have got a plpgsql function:
CREATE FUNCTION nueva_llamada(integer, integer) RETURNS integer
as
DECLARE
_operadora_id ALIAS FOR $1;
_actividad_id ALIAS FOR $2;
_contacto_id integer;
BEGIN
-- BEGIN;
SELECT min(id) INTO _contacto_id FROM contactos
WHERE
Say if I want to add a small snip of code in front of the sql script
generated by the pg_dump, to check for something then if the condition
doesn't match, the script terminates right away. (Without actually doing the
restoring stuff that the following large chunk is supposed to do)
Can I do
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
The manual is correct, you can not do transactions within a procedure
since the procedure must be called within a transaction. If you're
working with postgres 8, you can achieve similar functionality using
checkpoints. But that won't solve the problem
On Tue, 17 May 2005 12:01:03 -0500, Scott Marlowe wrote
On Thu, 2005-05-12 at 14:07, [EMAIL PROTECTED] wrote:
Hi:
Oracle has a pseudo-column ROWNUM to return the sequence
number in which a row was returned when selected from a table.
The first row ROWNUM is 1, the second is 2, and so
On May 20, 2005, at 1:22 PM, Wei Weng wrote:
Say if I want to add a small snip of code in front of the sql script
generated by the pg_dump, to check for something then if the condition
doesn't match, the script terminates right away. (Without actually
doing the restoring stuff that the
On Fri, 2005-05-20 at 13:27, Keith Worthington wrote:
Scott,
I realize that this thread went off in another direction however your
suggestion proved very helpful for a problem that I was trying to solve. I
wanted the row number of a set returned by a function. Here is a chopped
version
Mark Fenbers [EMAIL PROTECTED] writes:
A colleage of mine in another office has RedHat Enterprise 3 installed.
We do not have this yet, but will in the fall. According to him, the
DBD::Pg module that has been a part of the Red Hat baseline from Redhat
7.2 (or earlier) through RH Fedora
Quoting John DeSoi [EMAIL PROTECTED]:
On May 20, 2005, at 1:22 PM, Wei Weng wrote:
Say if I want to add a small snip of code in front of the sql script
generated by the pg_dump, to check for something then if the condition
doesn't match, the script terminates right away. (Without