Re: parse error in function

From: Richard Huxton <dev(at)archonet(dot)com>
To: Uros <uros(at)sir-mag(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: parse error in function
Date: 2004-01-15 16:01:27
Message-ID: 200401151601.27025.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-01-15 16:04:02 Re: Returning large select results from stored procedures
Previous Message Tom Lane 2004-01-15 15:57:04 Re: parse error in function