Hi Tom,in fact,i needed to move the DECLARE before begin and to adjust some autoincrement...and the problem is solved ;-)thx,MaileenTom Lane <[EMAIL PROTECTED]> wrote: "P.M" <[EMAIL PROTECTED]> writes:> here is my function in PostgreSQL :> CREATE OR REPLACE FUNCTION immense_sp001(VARCHAR,VARCHAR, s
On Sat, May 27, 2006 at 08:20:47AM -0700, P.M wrote:
> i've just migrated a stored procedure from MySQl to PostgreSQL and i have the
> following error :
> ERROR: syntax error at or near "SELECT" at character 371
>
> here is my function in PostgreSQL :
> CREATE OR REPLACE FUNCTION immense_sp001(V
"P.M" <[EMAIL PROTECTED]> writes:
> here is my function in PostgreSQL :
> CREATE OR REPLACE FUNCTION immense_sp001(VARCHAR,VARCHAR, service_nom
> VARCHAR, OUT result BOOLEAN, OUT error_message VARCHAR)
> RETURNS record LANGUAGE plpgsql
> AS '
> BEGIN
> DECLARE
> username varchar :=$1;
>
Hi,i've just migrated a stored procedure from MySQl to PostgreSQL and i have the following error :ERROR: syntax error at or near "SELECT" at character 371here is my function in PostgreSQL :CREATE OR REPLACE FUNCTION immense_sp001(VARCHAR,VARCHAR, service_nom VARCHAR, OUT result BOOLEAN, OUT error_
Thanks for the clarification. The problem turned out to be more trivial.
I was not doing something like: employee.f1 := 'value of f1 column'; as
you suggested, but declaring "employee" as record I did not pay
attention to the fact that I use a scheme named employee in the store
proc. My guess is th
On Mon, Oct 10, 2005 at 06:43:25PM +0300, Ivan Pavlov wrote:
> I have a store procedure which returns a record; the query is defined as:
>
> select * from spec_proc.view_empl_1('bg',2) AS (f1 varchar, f2 varchar,
> f3 date, f4 varchar, f5 varchar,f6 varchar,f7 varchar, f8 varchar, f9
> int, f10 va
I have a store procedure which returns a record; the query is defined as:
select * from spec_proc.view_empl_1('bg',2) AS (f1 varchar, f2 varchar,
f3 date, f4 varchar, f5 varchar,f6 varchar,f7 varchar, f8 varchar, f9
int, f10 varchar, f11 varchar, f12 varchar, f13 int, f14 varchar, f15
date, f16 da
Carmen Gloria Sepulveda Dedes <[EMAIL PROTECTED]> writes:
> I get:
> ERROR: variable not found in subplan target list
Could we have enough context to reproduce the problem? I don't have
time to guess at your table definitions ...
regards, tom lane
--
