On 5/15/06, Tom Lane <[EMAIL PROTECTED]> wrote:
This could only work if LEVEL is guaranteed to have one and only one value per tuple. I'm not too sure about the spec but it seems like that'd probably fall down in join situations.
Yes, this was another thing handled by Evgen's patch... FakeVar could only exist once and was ignored in joins. So, basically (like rownum), I have to create a pseudocolumn that isn't bound by joins. Do you know of any way around this? -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation | fax: 732.331.1301 33 Wood Ave S, 2nd Floor | [EMAIL PROTECTED] Iselin, New Jersey 08830 | http://www.enterprisedb.com/ "SQL will be the COBOL in the year 2020" -Mike Stonebraker ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
