Thread: Create a temporary table in a function
View Single Post
  #6 (permalink)  
Old 01-22-10, 03:35
shammat shammat is offline
Registered User
  
Join Date: Nov 2003
Posts: 2,297
Quote:
Originally Posted by tcliam View Post
Yes I did this but I am getting an error saying PreviousProject.MemberID doesn't exist. This is something that I have come a accross a number of times when using RETURN QUERY and assigning a name to a table like "PreviousProject". It always seems to say that the table doesn't exist.
If anyone knows why this would happen please let me know?
If you care to show us the statement that generates the error?
Sounds like something is wrong with the aliasing.
Reply With Quote