a*i
2 楼
I am pretty good at it. What do you want to know about it?
【在 l*****s 的大作中提到】
: 因为windows上不方便用?
【在 l*****s 的大作中提到】
: 因为windows上不方便用?
s*i
3 楼
s/he wanted to know why it's not popular.
【在 a*****i 的大作中提到】
: I am pretty good at it. What do you want to know about it?
【在 a*****i 的大作中提到】
: I am pretty good at it. What do you want to know about it?
a*i
4 楼
Not so much publicity(most of the geeks who use mysql and brag about it can
not write a sql statement with more than two selects.:), but it is a very
solid, very good database. And the development has been very active.
【在 s**********i 的大作中提到】
: s/he wanted to know why it's not popular.
not write a sql statement with more than two selects.:), but it is a very
solid, very good database. And the development has been very active.
【在 s**********i 的大作中提到】
: s/he wanted to know why it's not popular.
s*i
5 楼
I don't think they can write one with more than one select in
an SQL statement... :)
what's better than MySQL besides you can write sub-select?
【在 a*****i 的大作中提到】
: Not so much publicity(most of the geeks who use mysql and brag about it can
: not write a sql statement with more than two selects.:), but it is a very
: solid, very good database. And the development has been very active.
a*i
6 楼
I haven't used MySQL much. Tell me what you can do in mysql and I will see
if that can be done in pgsql. Functionality-wise, postgresql is very rich that
I dare say it can compete with Oracle. But speed-wise, it is hmm, a little
lacking. hehe... :)
【在 s**********i 的大作中提到】
:
: I don't think they can write one with more than one select in
: an SQL statement... :)
: what's better than MySQL besides you can write sub-select?
b*e
7 楼
compete with oracle? hmm.. how about an equivalent for the connect by
prior? please don't tell me to RTFM
【在 a*****i 的大作中提到】
:
: I haven't used MySQL much. Tell me what you can do in mysql and I will see
: if that can be done in pgsql. Functionality-wise, postgresql is very rich that
: I dare say it can compete with Oracle. But speed-wise, it is hmm, a little
: lacking. hehe... :)
prior? please don't tell me to RTFM
【在 a*****i 的大作中提到】
:
: I haven't used MySQL much. Tell me what you can do in mysql and I will see
: if that can be done in pgsql. Functionality-wise, postgresql is very rich that
: I dare say it can compete with Oracle. But speed-wise, it is hmm, a little
: lacking. hehe... :)
a*i
8 楼
what does "connect by prior" do? @@
【在 b****e 的大作中提到】
: compete with oracle? hmm.. how about an equivalent for the connect by
: prior? please don't tell me to RTFM
【在 b****e 的大作中提到】
: compete with oracle? hmm.. how about an equivalent for the connect by
: prior? please don't tell me to RTFM
b*e
9 楼
haha.. i'm nice so i am not going to be arrogant and ask you to RTFM :)
but on what basis were you making the assertion that it's not inferior
to oracle feature wise..
connect by prior gives you the hierarchical capabilities.. for example,
to find all children to a given node
【在 a*****i 的大作中提到】
: what does "connect by prior" do? @@
but on what basis were you making the assertion that it's not inferior
to oracle feature wise..
connect by prior gives you the hierarchical capabilities.. for example,
to find all children to a given node
【在 a*****i 的大作中提到】
: what does "connect by prior" do? @@
a*i
10 楼
compete, compete, my friend, I never said it is NOT inferior. :)
Look at the price tag, and you will find why it can *compete* hehe...
【在 b****e 的大作中提到】
: haha.. i'm nice so i am not going to be arrogant and ask you to RTFM :)
: but on what basis were you making the assertion that it's not inferior
: to oracle feature wise..
: connect by prior gives you the hierarchical capabilities.. for example,
: to find all children to a given node
Look at the price tag, and you will find why it can *compete* hehe...
【在 b****e 的大作中提到】
: haha.. i'm nice so i am not going to be arrogant and ask you to RTFM :)
: but on what basis were you making the assertion that it's not inferior
: to oracle feature wise..
: connect by prior gives you the hierarchical capabilities.. for example,
: to find all children to a given node
b*e
11 楼
pricetag wise oracle is the worst.. it's a given. but your original
post says:
Functionality-wise, postgresql is very rich that
I dare say it can compete with Oracle
hehehe :)
【在 a*****i 的大作中提到】
: compete, compete, my friend, I never said it is NOT inferior. :)
: Look at the price tag, and you will find why it can *compete* hehe...
post says:
Functionality-wise, postgresql is very rich that
I dare say it can compete with Oracle
hehehe :)
【在 a*****i 的大作中提到】
: compete, compete, my friend, I never said it is NOT inferior. :)
: Look at the price tag, and you will find why it can *compete* hehe...
a*i
12 楼
of course. subselect has been supported in pgsql for a long time.
【在 s**********i 的大作中提到】
:
: I don't think they can write one with more than one select in
: an SQL statement... :)
: what's better than MySQL besides you can write sub-select?
【在 s**********i 的大作中提到】
:
: I don't think they can write one with more than one select in
: an SQL statement... :)
: what's better than MySQL besides you can write sub-select?
b*e
13 楼
haha.. i'm nice so i am not going to be arrogant and ask you to RTFM :)
but on what basis were you making the assertion that it's not inferior
to oracle feature wise..
connect by prior gives you the hierarchical capabilities.. for example,
to find all children to a given node
【在 a*****i 的大作中提到】
: what does "connect by prior" do? @@
but on what basis were you making the assertion that it's not inferior
to oracle feature wise..
connect by prior gives you the hierarchical capabilities.. for example,
to find all children to a given node
【在 a*****i 的大作中提到】
: what does "connect by prior" do? @@
q*e
14 楼
Can PostgreSQL support embedded SELECT? In mysql,
the lastest version still does not support it even though
this is an ANSI feature. Not sure why it is not supported
by mySql, is it very difficult?
【在 a*****i 的大作中提到】
: Not so much publicity(most of the geeks who use mysql and brag about it can
: not write a sql statement with more than two selects.:), but it is a very
: solid, very good database. And the development has been very active.
the lastest version still does not support it even though
this is an ANSI feature. Not sure why it is not supported
by mySql, is it very difficult?
【在 a*****i 的大作中提到】
: Not so much publicity(most of the geeks who use mysql and brag about it can
: not write a sql statement with more than two selects.:), but it is a very
: solid, very good database. And the development has been very active.
s*i
15 楼
subselect? I think they didn't implement it for speed reasons.
but just a guess.
【在 q***e 的大作中提到】
: Can PostgreSQL support embedded SELECT? In mysql,
: the lastest version still does not support it even though
: this is an ANSI feature. Not sure why it is not supported
: by mySql, is it very difficult?
but just a guess.
【在 q***e 的大作中提到】
: Can PostgreSQL support embedded SELECT? In mysql,
: the lastest version still does not support it even though
: this is an ANSI feature. Not sure why it is not supported
: by mySql, is it very difficult?
s*i
16 楼
found several comparison pages, like this one:
http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html
so even postgresql supports SQL better than MySQL,
there're still reasons MySQL is used more widely on
web servers. :)
【在 a*****i 的大作中提到】
: of course. subselect has been supported in pgsql for a long time.
s*i
17 楼
forgot to say, I'm not going to post the content here
even some people are so lazy that they can't go to
any page and read themselves.
【在 s**********i 的大作中提到】
:
: found several comparison pages, like this one:
: http://phd.pp.ru/Software/SQL/PostgreSQL-vs-MySQL.html
: so even postgresql supports SQL better than MySQL,
: there're still reasons MySQL is used more widely on
: web servers. :)
a*i
18 楼
of course. subselect has been supported in pgsql for a long time.
【在 s**********i 的大作中提到】
: subselect? I think they didn't implement it for speed reasons.
: but just a guess.
【在 s**********i 的大作中提到】
: subselect? I think they didn't implement it for speed reasons.
: but just a guess.
a*i
19 楼
FYI, the latest pgsql is 7.2 (stable).
And outer join has been supported since the day of 7.0
【在 s**********i 的大作中提到】
:
: forgot to say, I'm not going to post the content here
: even some people are so lazy that they can't go to
: any page and read themselves.
And outer join has been supported since the day of 7.0
【在 s**********i 的大作中提到】
:
: forgot to say, I'm not going to post the content here
: even some people are so lazy that they can't go to
: any page and read themselves.
s*i
20 楼
and that's probably part of the reason that MySQL is faster
than PostgreSQL? :)
【在 a*****i 的大作中提到】
: of course. subselect has been supported in pgsql for a long time.
l*s
21 楼
功能太少了吧，比较mysql, sybase和oracle
hoho
【在 l*****s 的大作中提到】
: 因为windows上不方便用?
hoho
【在 l*****s 的大作中提到】
: 因为windows上不方便用?
s*i
22 楼
if you have read the comparisons, postgresql feature-wise
is much stronger than MySQL. it's comparable to Oracle
in many spects. however, it's not as much or stable as
MySQL.
【在 l***s 的大作中提到】
: 功能太少了吧，比较mysql, sybase和oracle
: hoho
相关阅读
Questions about SQL Server Lock timeout请教。Toad for oracle setting. first 500 or whole table!小女子，请求帮助SAS 概率面试题Mysterious PgSQL 8.3 crash有谁用SQL Server的DTS package连过Teradata吗?请问那里可以找到Hierarchical Clustering 算法的 C code请教sqlserver怎么能capture query?请问Reporting Service System (RSS) 客户安装我是外行，请教一个问题请问T-SQL中Group By之后怎么找到特定的record请推荐一本database基础的书，可以回答面试基本问题即可Sqlplus if the column numbers are too many and line too longhow to set a reference to Microsoft Excel in Access?问Jackrun, Beijing等大侠performance问题请问可不可以在sql语句中用序号表示columnbeijing呀，教教我怎么optimize sql server吧。一个大家看起来可能很简单的问题请教一个求职面试题：如何写一个SQL query求表中对角线的和Oracle previledge question.News on MySQL 5.1 (ZZ)