misc questions - Mailing list pgsql-hackers

From Jeff MacDonald
Subject misc questions
Date
Msg-id Pine.BSF.4.21.0005091553290.357-100000@rage.hub.org
Whole thread Raw
Responses Re: misc questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: misc questions  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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




pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Commercializing PostgreSQL: What do you thing?
Next
From: Wenjin Zheng
Date:
Subject: Primary Key on Inherited Table