Title: RE: [GENERAL] return two elements
I don't know that it happens with my email I will change the email of my subscription.
The examples are very interesting for my, and Alvaro Herrera's comments too.
In reference to INOUT/OUT params and return a set I have a doubt: I will be able to
19:22
Para: Michael Fuhr
CC: Rodríguez Rodríguez,Pere; pgsql-general@postgresql.org
Asunto: Re: [GENERAL] return two elements
On Tue, Jun 07, 2005 at 07:45:03AM -0600, Michael Fuhr wrote:
On Tue, Jun 07, 2005 at 10:08:27AM +0200, Rodríguez Rodríguez, Pere wrote:
I suppose that IN/OUT
Title: RE: [GENERAL] return two elements
In future releases is planned to incorporate IN/OUT declaration in parameters of user functions?
-Mensaje original-
De: Tom Lane [mailto:[EMAIL PROTECTED]]
Enviado el: lunes 6 de junio de 2005 17:10
Para: Rodríguez Rodríguez, Pere
CC: pgsql
,Pere
CC: pgsql-general@postgresql.org
Asunto: Re: [GENERAL] return two elements
On Tue, Jun 07, 2005 at 09:00:28AM +0200, Rodríguez Rodríguez, Pere wrote:
In future releases is planned to incorporate IN/OUT declaration in
parameters of user functions?
Yes -- it's already in the development
code gets to be more than a few pages it can become hell to debug
and work with. Plus breaking it out might allow you to use that same
logic in other parts of your system because it will be stand alone piece of
logic/code.
On 6/2/05, "Rodríguez
Rodríguez, Pere" [EMAIL
Title: return two elements
Hello,
how can I write a function that return two or more elements?
I try to return a record but after I don't know how to assign returned value to a variable. For example,
CREATE OR REPLACE FUNCTION test1() RETURNS record AS '
declare
rec record;
begin
Title: writting a large store procedure
Hello,
I'm writing a large store procedures (more than 700 lines) and I have much problems to debug it. How can I debug it easily?
I use pgAdmin, is there another editor (free software) that permit write large store procedure more easily?
Thanks in
Title: query with table alias
Hello,
I think I have found a query problem when the query has an alias for a table and use alias item and table name.
I ilustrate the problem with a simple table and query.
prr=# create table foo (c1 int2, c2 int2);
CREATE TABLE
prr=# insert into foo
Title: row level lock
Hello,
I thought that with the new release I could lock at row level with nowait option, but it seems that nowait option is only for table level lock, so, Can I do a row level lock with nowait option?
Thanks,
pere