Hello,
I have temporarily removed the PostgreSQL HOWTO, pending peer review.
Joshua Drake
On Thu, 18 Jan 2001, Brett W. McCoy wrote:
>On Thu, 18 Jan 2001, Poet/Joshua Drake wrote:
>
>> >it seems that the author never used any other think then PHP ...
>>
>> I am afraid I would disagree. I hav
Hi,
Poet/Joshua Drake wrote:
>
> >it seems that the author never used any other think then PHP ...
>
> I am afraid I would disagree. I have used all of the languages he metions
> and for the Web, PHP is the best.
hmm, i guess it's not a good place for a PHP/Perl war here ;) but:
The author wrot
Folks,
Fascinating as this thread is, is the SQL Developers list really the
appropriate place for it? Don't we have a Policy list or something?
-Josh Berkus
--
__AGLIO DATABASE SOLUTIONS___
>>> Best web-scripting (and compiling) language is PHP+Zend
>>> compiler PHP is extremely powerful as it combines the power of
>>> Perl, Java, C++, Javascript into one single language and it
>>> runs on all OSes - unixes and Windows NT/95.
>>
>> it seems that the author never used any other think
On Thu, 18 Jan 2001, Poet/Joshua Drake wrote:
> >it seems that the author never used any other think then PHP ...
>
> I am afraid I would disagree. I have used all of the languages he metions
> and for the Web, PHP is the best.
I think it all depends on what you are building. PHP is good for sm
On Thu, 18 Jan 2001, Michael Richards wrote:
> As I understand Zend is a compiler/interpreter that uses a optimised
> bytecode to run a little faster than the normal apache/php. It shares
> few of the features of perl, even fewer of Java. C++? Last time I
> checked, PHP couldn't do OOP. Next thin
On Wed, 17 Jan 2001, [EMAIL PROTECTED] wrote:
> E.g.
>
> create table mytable (created datetime);
> insert into mytable values ('01-01-2001');
> ...
> insert into mytable values ('01-31-2001');
>
> select created from mytable where date_part('dow', created) = 7 and
>date_part('month', created
> Is everyone sure that this HOWTO is not a work of fiction sort of
> like that report on the computer virus that will cause your
> motherboard to catch fire and burn down your house in the middle of
> the night?
The HOWTO author really reminds me of Jesus Monroy, if anyone remembers
him from
> Hello,
>
> I am the Webmaster of the LDP... What should I know?
OK, just read a little bit of it. After you stop laughing, come on back
and we can talk. :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your
> from http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-11.html
>
>> Best web-scripting (and compiling) language is PHP+Zend
>> compiler PHP is extremely powerful as it combines the power of
>> Perl, Java, C++, Javascript into one single language and it
>> runs on all OSes - unixes and Windows
>|> Best web-scripting (and compiling) language is PHP+Zend compiler
>|> PHP is extremely powerful as it combines the power of Perl,
>|> Java, C++, Javascript into one single language and it runs on
>|> all OSes - unixes and Windows NT/95.
>
>it seems that the author never used any other think the
Hello,
I am the Webmaster of the LDP... What should I know?
Joshua Drake
On Thu, 18 Jan 2001, Tom Lane wrote:
>Kaare Rasmussen <[EMAIL PROTECTED]> writes:
>> Whoever wrote this is putting the PostgreSQL community in a bad light:
>> http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
On Fri, 19 Jan 2001 09:46, Kaare Rasmussen wrote:
> Whoever wrote this is putting the PostgreSQL community in a bad light:
>
> http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
>
> Maybe someone can change the document, or make the author change it?
Most of that HOWTO document is distin
On Thu, 18 Jan 2001, Kaare Rasmussen wrote:
> > I do not see how it puts the Postgres community in a bad light, although I
> > do see how the author is a moron.
>
> People think that it's an official PostgreSQL document. It turned up in a
> discussion (PostgreSQL vs. MySQL round 1000) as "the Pos
> Hello,
>
> I do not see how it puts the Postgres community in a bad light, although I
> do see how the author is a moron.
Many of use fell is puts Linux in a bad light. :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-30
Kaare Rasmussen wrote:
>
> Whoever wrote this is putting the PostgreSQL community in a bad light:
>
> http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
it seems that the author of this HOWTO is a little bit mad in brain:
from http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-11.
> I do not see how it puts the Postgres community in a bad light, although I
> do see how the author is a moron.
People think that it's an official PostgreSQL document. It turned up in a
discussion (PostgreSQL vs. MySQL round 1000) as "the PostgreSQL docs".
--
Kaare Rasmussen--Lin
On Thu, 18 Jan 2001, Kovacs Zoltan Sandor wrote:
> I realized that an error will abort a transaction all the time.
> Unfortunately I usually send millions of rows of INSERTs in a transaction
> and if there is some error in the middle of the code I got the message
> if I try to INSERT a new row:
Hello,
I do not see how it puts the Postgres community in a bad light, although I
do see how the author is a moron.
J
On Thu, 18 Jan 2001, Kaare Rasmussen wrote:
>Whoever wrote this is putting the PostgreSQL community in a bad light:
>
>http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.ht
Kaare Rasmussen <[EMAIL PROTECTED]> writes:
> Whoever wrote this is putting the PostgreSQL community in a bad light:
> http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
> Maybe someone can change the document, or make the author change it?
(Rolls eyes...) See the archives for past discu
"Ligia M. Pimentel" <[EMAIL PROTECTED]> writes:
>> I have a database and a table with 7 records (which i dont think it's
>> too much)
>> I join this table with another of about the same size and put a record
>> restriction (WHERE) and everything works out fine, but when I put two SUMs
>> over
I realized that an error will abort a transaction all the time.
Unfortunately I usually send millions of rows of INSERTs in a transaction
and if there is some error in the middle of the code I got the message
if I try to INSERT a new row:
NOTICE: current transaction is aborted, queries ignored u
What version are you using? I believe this was added in 7.0.x, but
I could be wrong about that. A query of this sort works on my
7.1beta3 system.
On 17 Jan 2001, Mikael Hedin wrote:
> I have a table with a column (int4), and I want to know how many
> different numbers there are. In an exampl
Mikael Hedin <[EMAIL PROTECTED]> writes:
> SELECT COUNT (DISTINCT data ) FROM media;
> ERROR: parser: parse error at or near "distinct"
This is supported since 7.0. I suspect you are running an old release.
regards, tom lane
hi,there,
I don't see the problem except extra space, try:
SELECT COUNT(DISTINCT data) FROM media;
Jie LIANG
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
[EMAIL PROTECTED]
www.ipinc.com
On 17 Jan 2001, Mikael Hedin wrote:
> Hi,
>
> I
Whoever wrote this is putting the PostgreSQL community in a bad light:
http://www.linux.org/docs/ldp/howto/PostgreSQL-HOWTO-4.html
Maybe someone can change the document, or make the author change it?
--
Kaare Rasmussen--Linux, spil,--Tlf:3816 2582
Kaki Data
Bruce,
> > BTW, O'Reilly's "SQL in at Nutshell" also catalogs all PGSQL functions
> > from ver. 6.5.
>
> It does, or only the standard SQL functions? Do they have
> PostgreSQL-specific stuff.
Both. The book is set up to cover 1) the SQL99 standard, and 2)
Specific variants for SQL Serve
Hi,
I have a table with a column (int4), and I want to know how many
different numbers there are. In an example book I saw the query
SELECT COUNT (DISTINCT data ) FROM media;
by then I get
ERROR: parser: parse error at or near "distinct"
Is the query in error or does PostgreSQL not support
Clayton,
> > Hi all,
> > It is a very simple but I am not able to recall how to do it I
> > just need to find out the current value of a seq. It is very simple
> > select statement but I can't recall it... Help me please before I get
> > myself get fired -:).
> > Regards, Najm
>
> select
Thank you all for your help.
Najm
how to run "select from databaseA:tabl1 ,databaseB:table2 "
thanks
On Tue, Jan 16, 2001 at 01:42:45PM -0700, Diehl, Jeffrey wrote:
> I'm having difficulty writing a query which I really can't live without...
>
> I need to get a list of records from table A for which there are
> corresponding records in table B. I've tried to use the intersect clause,
> but it
See my book on sequences:
http://www.postgresql.org/docs/awbook.html
currval() is probably what you need.
> Hi all,
> It is a very simple but I am not able to recall how to do it I
> just need to find out the current value of a seq. It is very simple
> select statement but I can'
Najm Hashmi wrote:
>
> Hi all,
> It is a very simple but I am not able to recall how to do it I
> just need to find out the current value of a seq. It is very simple
> select statement but I can't recall it... Help me please before I get
> myself get fired -:).
> Regards, Najm
select nex
> Najm
>
> CURRVAL('sequence_name')
>
> For this and other sequence and serial functions, please see the online
> version of Bruce's book.
>
> BTW, O'Reilly's "SQL in at Nutshell" also catalogs all PGSQL functions
> from ver. 6.5.
It does, or only the standard SQL functions?
Najm Hashmi wrote:
> Hi all,
> It is a very simple but I am not able to recall how to do it I
> just need to find out the current value of a seq. It is very simple
> select statement but I can't recall it... Help me please before I get
> myself get fired -:).
>
Try:
SELECT last_value FRO
Najm
CURRVAL('sequence_name')
For this and other sequence and serial functions, please see the online
version of Bruce's book.
BTW, O'Reilly's "SQL in at Nutshell" also catalogs all PGSQL functions
from ver. 6.5.
-Josh Berkus
--
Hi all,
It is a very simple but I am not able to recall how to do it I
just need to find out the current value of a seq. It is very simple
select statement but I can't recall it... Help me please before I get
myself get fired -:).
Regards, Najm
I fixed it!, it just added an index!
Thanks anyway...
"Ligia M. Pimentel" <[EMAIL PROTECTED]> wrote in message
944kbb$114p$[EMAIL PROTECTED]">news:944kbb$114p$[EMAIL PROTECTED]...
> I have a database and a table with 7 records (which i dont think it's
> too much)
> I join this table with anot
I have a database and a table with 7 records (which i dont think it's
too much)
I join this table with another of about the same size and put a record
restriction (WHERE) and everything works out fine, but when I put two SUMs
over a couple of fields and add a GROUP BY I keep getting this erro
Hello Sharmad,
Once, Wednesday, January 17, 2001, 12:24:11 AM, you wrote:
SN> I wanted to compile python will an installed postgres package ...can i do it .How?
SN> TIA
SN> Sharmad
There are 2 known python postgresql modules - PyGreSQL and PoPy.
PyGreSQL is in Postgresql distribution, PoPy you
Hi,
In Postgres, which one should be the best data type to be used as
primary/foreign key considering query performance: INT or CHAR? Is there
any "remarkable" difference between them?
Thank you and regards,
--
Renato
Sao Paulo - SP - Brasil
[EMAIL PROTECTED]
Can you send the full schema of the tables you are using for
this?
On Tue, 16 Jan 2001, Michael Richards wrote:
> Hi.
>
> I'm having trouble with committing a transaction. Intuitively it
> should work but does not.
>
> I've got a table with 2 foreign keys, minrev and maxrev. They refer
>
Okay, yep, seems like a garden variety bug to me...
What's happening is that the update trigger is checking to make sure
that there are no rows referencing the one that was changed, but that's
not sufficient for the deferred no action case possibly. It's got to be
that there are no rows that no
44 matches
Mail list logo
