FAQ

Thangalin writes:
The following code works as expected, returning two columns of data (a row
number and a valid value):
...
The following code does not work as expected; the first column is a row
number, the second column is NULL.
I think the problem is that you're assuming "amount" will refer to a
table column of the query, when actually it's a local variable of the
plpgsql function. The second interpretation will take precedence unless
you qualify the column reference with the table's name/alias.

(BTW, PG 9.0 will throw an error by default when there's an ambiguity of
this type.)
My second question is tangentially related: how do you use PREPARE inside of
a stored procedure?
There is no need to use PREPARE, because every SQL query in plpgsql is
effectively prepared automatically.

regards, tom lane

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 2 | next ›
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMay 29, '11 at 9:47p
activeMay 31, '11 at 1:39a
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Thangalin: 1 post Tom Lane: 1 post

People

Translate

site design / logo © 2022 Grokbase