| From: | Jeff MacDonald <jeff(at)pgsql(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | misc questions |
| Date: | 2000-05-09 18:53:43 |
| Message-ID: | Pine.BSF.4.21.0005091553290.357-100000@rage.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi folks
Few questions..
1: Has anyone found a way to fake INNER JOINS, basically I'm helping someone
convert some MSSQL code over to Postgres and they use INNER JOINS heavly
2: Have any of y'all ever seeen this error
""transformExpr: does not know how to transform node 501 (internal error)"
from statement:
"SELECT DISTINCT ss.stateID, ss.stateValue FROM State ss INNER JOIN Standard
st ON ss.stateID = st.stateID"
It stikes me as kinda strange because first and formost it should complain about
the INNER JOIN and not this other thing.
3: what is the maximum depth of nested sub queries ?
4: just out of the blue, how great or not great is our alpha support ?
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wenjin Zheng | 2000-05-09 19:00:50 | Primary Key on Inherited Table |
| Previous Message | Marc G. Fournier | 2000-05-09 18:26:29 | Re: Commercializing PostgreSQL: What do you thing? |