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
相关阅读
Help needed in SQLsybase高手看过来question about SQL*LOADERORACLE VARCHAR2一问关于FoxPro的容量问题How did they track the article status in this BBS?How to dump tables from Oracle to Access?can't start Oracle management service on Win2khow to include record deleted date into trigger?[转载] Java/JSP/Servlets... and Database(Oracle/DB2)直线回归后95%可信限的Plot是怎么得到的?怎么是曲线呢?新手请教ACCESS的SUM功能is there a 'personal editon' of Oracle8i/9i for如何进行INFORMIX到DB2移植的可行性分析？[转载] How to sort chinese data?anybody got oracle 9i certificate? 急for that drop table errorDo you thing the thread view is good or the chronical view is good?Drop table error.Help!!!! How to synchronized the data in SQL server