Tom, > No, this isn't right. If you check the source code you will discover > that plpgsql is extremely lax about the positioning of the INTO > clause, > and will in fact accept it almost anywhere. Datatype has nothing to > do with this. (It probably should be stricter, but at this point I > doubt we could change it without drawing howls of anguish from those > who did it the other way.) Thanks for setting me straight, Tom. I guess I combines some bugs in 7.0.2 with the original sketchy instructions and assumed that there were stricter syntactical rules than there are. This is good because it now means I can use the logical syntax of SELECT data INTO var ... which to me is easier to read, for everything. -Josh ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html