Re: parse error in function - Mailing list pgsql-general

From Richard Huxton
Subject Re: parse error in function
Date
Msg-id 200401151601.27025.dev@archonet.com
Whole thread Raw
In response to Re: parse error in function  (Uros <uros@sir-mag.com>)
Responses Re: parse error in function
List pgsql-general
On Thursday 15 January 2004 15:22, Uros wrote:
>
> RH> Also - make sure you haven't got a column called 'email' in any query
> where RH> you are using the variable 'email' - that can cause confusion.
>
>
> Problem was aliases, becasu alias name was the same as column and then the
> same name was value and rowname. I replace all names like email1 etc. and
> it works. I hope  ;).

The error messages could be a bit clearer with some of these problems - I've
had quite a bit of experience now decoding strange parser errors with
plpgsql.

--
  Richard Huxton
  Archonet Ltd

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: parse error in function
Next
From: Richard Huxton
Date:
Subject: Re: Returning large select results from stored procedures