misc questions

Поиск
Список
Период
Сортировка
От Jeff MacDonald
Тема misc questions
Дата
Msg-id Pine.BSF.4.21.0005091553290.357-100000@rage.hub.org
обсуждение исходный текст
Ответы Re: misc questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: misc questions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Commercializing PostgreSQL: What do you thing?
Следующее
От: Wenjin Zheng
Дата:
Сообщение: Primary Key on Inherited Table