Skip site navigation (1) Skip section navigation (2)

Re: Columnas afectadas en Postgresql

From: Eric Aponte <eaponte(at)usb(dot)ve>
To:
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Columnas afectadas en Postgresql
Date: 2004-07-20 19:09:05
Message-ID: 40FD6DD1.8080408@usb.ve (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Hice los cambios, pero no le asigna valor a la variable registros

CREATE OR REPLACE FUNCTION query (text) RETURNS numeric AS'

declare
var_sw numeric;
registros integer;
begin
execute $1;
get diagnostics registros = row_count;
if registros > 0 then
  var_sw := 1;
else
  var_sw := 0;
end if;
return var_sw;
end;
'LANGUAGE 'plpgsql';

Gracias

In response to

Responses

pgsql-es-ayuda by date

Next:From: Jaime CasanovaDate: 2004-07-20 21:10:15
Subject: Re: Columnas afectadas en Postgresql
Previous:From: Jaime CasanovaDate: 2004-07-20 17:28:07
Subject: Re: Columnas afectadas en Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group