Re: [SQL] How do I quit in the middle of a SQL script?

2005-05-20 Thread Mischa Sandberg
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. (W

Re: [SQL] DBD::Pg on Enterprise 3

2005-05-20 Thread Tom Lane
"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 Fe

[SQL] DBD::Pg on Enterprise 3

2005-05-20 Thread Mark Fenbers
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 Core has been removed from RH Enterprise 3 ba

Re: [SQL] Does Postgresql have a similar pseudo-column "ROWNUM" as

2005-05-20 Thread Scott Marlowe
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 > vers

Re: [SQL] How do I quit in the middle of a SQL script?

2005-05-20 Thread John DeSoi
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 following

Re: [SQL] Does Postgresql have a similar pseudo-column "ROWNUM" as

2005-05-20 Thread Keith Worthington
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

Re: [SQL] Transaction in plpgslq

2005-05-20 Thread Andrew Hammond
-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

[SQL] How do I quit in the middle of a SQL script?

2005-05-20 Thread Wei Weng
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 tha

[SQL] Transaction in plpgslq

2005-05-20 Thread Rafa Couto
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 contactos.operadora_

Re: [SQL] Aggregate Functions Template

2005-05-20 Thread Mark Fenbers
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 an