MySQL simply did a better job of marketing themselves to an audience that
typically doesn't know SQL or understand relational databases. MySQL
focuses on speed as it's primary asset. Integration with quick growing
languages (like PHP) helped a lot too. MySQL is also the product of an
existing s
On Mon, Dec 04, 2000 at 03:05:23PM -0800, Dan Lyke wrote:
> I've been seriously programming microcomputers for a decade and a
> half. One of the great accomplishments of my career was shoehorning a
> big database application into a 4.77 MHz PC XT under that 640k limit,
> including the bigger versi
On Mon, Dec 04, 2000 at 05:56:04PM -0500, Camm Maguire wrote:
> Greetings! I've run into this too, and it appears to me not to roll
> back either. A pity, as it forced us to make a separate table to hold
> the last sequence value and update the table in a trigger.
This is a dangerous thing if y
On 4 Dec 2000, Chris Jones wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
>
> > On 30 Nov 2000, Chris Jones wrote:
> >
> > > PG seems to be choosing a sub-optimal query plan. It's doing a
> > > sequential scan of a 12-tuple table, instead of an index scan for
> > > the 16 matching row
Raymond Chui writes:
> I am wonder why most of people choose MySQL in Linux
> world rather than PostgreSQL?
I normally stay out of the advocacy wars, but as a recent convert I
figure I'll pipe up.
I switched to PostgreSQL as the back-end to my services at
http://www.flutterby.com/ from MySQL whe
Greetings! I've run into this too, and it appears to me not to roll
back either. A pity, as it forced us to make a separate table to hold
the last sequence value and update the table in a trigger.
Take care,
igor <[EMAIL PROTECTED]> writes:
> Hi,
>
> Help me please to understand such a thing
On Mon, 4 Dec 2000, Nancy Ellman wrote:
> However, while I have been able to see the results of the first
> example with
>
> \dd mytable
Try \d+ mytable
Rod
Stephan Szabo <[EMAIL PROTECTED]> writes:
> On 30 Nov 2000, Chris Jones wrote:
>
> > PG seems to be choosing a sub-optimal query plan. It's doing a
> > sequential scan of a 12-tuple table, instead of an index scan for
> > the 16 matching rows. Running PG 7.0.2:
> >
> > fastfacts=> vacuum
Joel Burton writes:
> Both PostgreSQL and MySQL say there have been 730485 between 1/1/0
> and 1/1/2000. Something we all can agree on? :-)
Which is pretty odd considering the fact that there was no year 0.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Hello The,
Monday, December 04, 2000, 2:20:51 AM, you wrote:
THH> just re-submit'd my vote ... maybe mycgiserver already has mysql installed
THH> and is only doing the vote to satisfy some ppl, but don't really want to
THH> install PgSQL? *raised eyebrow*
No. Like they said to me, they really d
Zachary Beane <[EMAIL PROTECTED]> writes:
> AS clause. This name is primarily used to label the column for
> display. It can also be used to refer to the column's value in
> ORDER BY and GROUP BY clauses. But the name cannot be used in
> the WHERE or HAVING clauses; write
Ronald Cole <[EMAIL PROTECTED]> writes:
> Postgres, yes. PostgreSQL, no. PostgreSQL was a new project with
> Postgres95 as a starting point. Postgres95 was an attempt to put an
> SQL front-end on Postgres.
Right; original Postgres used a query language called "POSTQUEL",
which was sort of like
Chris Jones <[EMAIL PROTECTED]> writes:
> Now I have a table called pg_temp.1548.0, and I can't delete it:
> fastfacts=> drop table "pg_temp.1548.0";
> ERROR: class "pg_temp.1548.0" is a system catalog
> The same thing happens, whether I'm connected as a mortal user or as
> the PG super-user.
I
[ answer about PG passwords deleted ]
> PgSQL stores the plaintext password. Non-superusers can only look at
> pg_password, where the password is starred out, but pg_shadow shows
> the real passwords.
Oops! I meant "pg_user", not "pg_password". The whole
/etc/passwd and /etc/shadow playing wit
Hi!
You can compile PHP without HTTP server support then you get php exec
'shell'
and:
#!/usr/local/bin/php
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Bernie Huang
> Sent: Monday, November 27, 2000 8:23 PM
> To: PHP_DB; PHP_General; PGSQL-S
I'm sure the convience of having the reports emailed on a specific day is
what you're looking for. But why not just code your PHP to do your
mysql_query() and mail() and place it on a webserver. Obviously have a
simple hardcoded login so just not anyone can request the reports. That way
your boss
On 28 Nov 2000, at 13:12, Brian Aker wrote:
> I've been looking for a good reference for the built
> in time functions and have yet to find any.
Try the functions reference in the postgresql manual--there's a lot of
information about Pgsql date/time functions there, but in your case, no
functi
How about
SELECT
SUM(CASE WHEN otherfield = 'criteria' THEN 1 ELSE 0 END) as count_comply,
SUM(CASE WHEN otherfield = 'criteria' THEN somefield ELSE 0 END) as
sum_comply,
sum_comply/count_comply AS mean_comply
FROM sometable
ORDER BY thirdfield
LIMIT 10
?
-Original Message-
From: [EMAIL
Start psql w/ -E option and you can see the SQL for all \xxx
commands.
On 27 Nov 2000, at 20:20, Rob Burne wrote:
> Hi,
>
> I need to find the query that will return all security access
> permissions.
>
> For example if a INSERT has been granted to a particular user, how do
> I perform the qu
According to the documentation for COMMENT, it puts a comment on
object "that can be easily retrieved with psql's \dd command."
Examples like
COMMENT on table mytable is 'foo';
COMMENT on column mytable.mycolumn is 'bar';
are given.
However, while I have been able to see the
* Tom Lane wrote on Monday, 2000-12-04:
> Christian Ullrich <[EMAIL PROTECTED]> writes:
> > I've just gotten PostgreSQL 7.0.3 to build and actually run under
> > WinNT 4.0, and the regression tests show two problems: one probably
> > minor in horology (I suppose there's a wrong time zone somewhe
Peter Eisentraut schrieb:
> Martin Jacobs writes:
>
> > Now, postmaster is listening, I can connect with telnet, netstat
> > tells that there is a connection, but psql fails to connect to
> > any database.
>
> What did you do and what response did you get?
Nothing serious. I just wanted to test
Hello,
I´m trying to use embedded sql with postgresql through ecpg. But if I
try to make a connection to my database, I get the following error at
runtime:
Could not connect to database buecher@localhost in line 18.
(I´m using postgresql 7.0.2)
psql and the jdbc is working, but not the ecpg con
Matt,
here's some additional information about this issue, as quoted on the "recent news" of
www.mycgiserver.com:
"2000-12-04 07:56:51 CET
As some people contacted us what was going on with the current survey (the PostgreSQL
vote significantly decreased from one second to another), we'd like t
On Mon, Dec 04, 2000 at 12:31:06AM -0400, some SMTP stream spewed forth:
>
> A couple of days ago, one of our brethren noticed and pointed us to your
> survey asking which RDBMS we prefered/were using ... pride in our choice
> prompted alot of us to pop over to your site and register our vote
>
25 matches
Mail list logo
