Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 018B6632199
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 17 Apr 2009 09:34:31 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 09667-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 17 Apr 2009 09:34:27 -0300 (ADT)
X-Greylist: delayed 00:06:39.491966 by SQLgrey-1.7.6
Received: from sapo.pt (relay3.ptmail.sapo.pt [212.55.154.23])
	by mail.postgresql.org (Postfix) with SMTP id F09F062DBDD
	for <pgsql-sql@postgresql.org>; Fri, 17 Apr 2009 09:34:26 -0300 (ADT)
Received: (qmail 22975 invoked from network); 17 Apr 2009 12:27:43 -0000
Received: from unknown (HELO sapo.pt) (10.134.37.163)
	by relay3 with SMTP; 17 Apr 2009 12:27:43 -0000
Received: (qmail 13899 invoked from network); 17 Apr 2009 12:27:43 -0000
X-AntiVirus: PTMail-AV 0.3-0.92.0
X-Virus-Status: Clean (0.00422 seconds)
Received: from unknown (HELO hmv02) (hmv@[85.240.118.185])
	(envelope-sender <hmv@mail.telepac.pt>)
	by mta13 (qmail-ldap-1.03) with SMTP
	for <pgsql-sql@postgresql.org>; 17 Apr 2009 12:27:42 -0000
Message-ID: <041E5E02645042CC839F3E8421DBF2BA@hmv02>
From: =?iso-8859-1?Q?H=E9lder_M._Vieira?= <hmv@mail.telepac.pt>
To: <pgsql-sql@postgresql.org>
References: <49E86A4A.4060507@o2tecnologia.com.br>
Subject: Re: Problemas com Procedure no PostgreSQL
Date: Fri, 17 Apr 2009 13:27:40 +0100
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200904/100
X-Sequence-Number: 32446


Bom dia.

...
>acusado o seguinte erro "sintax error at or near "SELECT" at character 487", e infelizmente não conseguimos achar o que esta 
>errado, dai peço ajuda aos colegas. Segue abaixo a procedure:
...
>   IF ( pCNPJ = '' ) THEN
>   BEGIN
...
>   END IF
...


Numa leitura sumária, parece-me que há vários problemas neste procedimento. Desde logo, a condição tem estrutura inválida :

IF ... THEN
BEGIN
    ...
END IF


Deverá ser substituída por ( atenção ao ponto e vírgula após o END IF ) :

IF ... THEN
    ...
END IF;


P.f. experimente essa alteração e, caso continue a ter problemas, volte a publicar aqui o script na sua nova redacção.
Já agora, quando publicar mensagens nesta lista, caso lhe seja possível escreva em inglês.


Cumprimentos,

Helder M. Vieira