On Mon, Jul 14, 2003 at 12:54:55AM -0500, Ron Johnson wrote:
SQL is only one possible relational query language. It didn't
become de facto standard until the mid- to late-80s.
It is an outgrowth of SEQEL (Structured English QuEry Language),
which was IBM's 1st try at a descriptive query
The
select null + 0
is not the same as the
select sum(a) from a
statement.
Something equivalent would be
select sum(a) where a in (select null as a union select 1 as a)
In other words: As far as I understand it, sum() sums up all non null
values. In statement you have only one value, which
Oops forgot to cc the list.
Unfortunately, intra-row functions using nulls return nulls. Inter-row
functions usually ignore the nulls. I think there may be a few
exceptions.
Though there is a relational theory which has is rigorously consistent,
nulls are not part of the theory. Nulls are
Jean-Christian Imbeault wrote:
Shouldn't the sum() and + operators behave the same?
No, see SQL99, Section 6.16, General Rules 1.b:
Otherwise, let TX be the single-column table that is the result of
applying the value expression to each row of T and eliminating null
values. If one or more null
Jean-Christian Imbeault wrote:
Why is it that select null + 1 gives null but select sum(a) from
table where there are null entries returns an integer?
Shouldn't the sum() and + operators behave the same?
---
SQL92 (6.5 set function specification):
1) Case:
a) If COUNT(*) is specified,
This is a great technique. It is especially useful in finance for
compounded interest for problems like the following
total return = ((1+janReturn)(1+febReturn)(1+marReturn))-1
I first learned it from an MBA in finance when I was looking over a
spreadsheet that she wrote.
Vincent Hikida,
On Sun, Jul 13, 2003 at 11:14:15PM -0700, Vincent Hikida wrote:
Oops forgot to cc the list.
I just happened to notice another difference recently between Oracle and
Postgresql for the clause
WHERE 1 IN (1,2,NULL)
In Oracle, this clause is false because 1 compared to a NULL is false.
On Sun, 13 Jul 2003, Vincent Hikida wrote:
Oops forgot to cc the list.
Unfortunately, intra-row functions using nulls return nulls. Inter-row
functions usually ignore the nulls. I think there may be a few
exceptions.
Though there is a relational theory which has is rigorously
Suppose the following:
create table test (a int primary key);
insert into test values (1);
select * from test;
a
=
1
In Postgresql if you do the following in a transaction (either with
autocommit=off or with an explizit begin):
insert into test values (2); - ok
insert into test values (1); -
Standard issue. When you specify an unquoted number in a query it's
interpreted as an int4 which doesn't match your indexes. Suggestions are:
- Put quotes around your numbers or eg. '1'
- Cast them to the right type eg. 1::bigint
Huh, yeah, I remember now reading about this.
Um, the behaviour you are seeing is what would happen in PostgreSQL if
everything were all in one transaction. What you show for Oracle is what
would happen if each statement were in it's own transaction.
On the postgresql server here, without transactions:
create temp table test (a int primary
On Mon, 14 Jul 2003, Jörg Schulz wrote:
Suppose the following:
create table test (a int primary key);
insert into test values (1);
select * from test;
a
=
1
In Postgresql if you do the following in a transaction (either with
autocommit=off or with an explizit begin):
insert into
This worked for me...
./configure --with-libs=/sw/lib --with-includes=/sw/include
After reading this:
http://marc.theaimsgroup.com/?l=postgresql-generalm=103886532224699w=2
It looks like some of you out there have successfully installed
postgresql on OS X with readline support. I
... I have this feeling the reason Oracle gives this result may
be again because transactions have been switched off!
This snippet comes from the Oracle console:
(table name is a not test / messages are in german)
SQL show autocommit;
autocommit OFF
SQL select * from a;
A
--
Jörg Schulz wrote:
... I have this feeling the reason Oracle gives this result may
be again because transactions have been switched off!
This snippet comes from the Oracle console:
(table name is a not test / messages are in german)
...
SQL select * from a;
A
--
On Mon, 14 Jul 2003, Mike Mascari wrote:
Jörg Schulz wrote:
... I have this feeling the reason Oracle gives this result may
be again because transactions have been switched off!
This snippet comes from the Oracle console:
(table name is a not test / messages are in german)
...
This was executed via sql+ on an Oracle 9i installation:
SQL select 1 from dual where 1 in (1,2,null);
1
--
1
SQL select 1 from dual where 1 in (null);
no rows selected
I would say the Oracle implementation is correct and the same as in
Postgres. For your problem I
Hi,
I'm having trouble with libpg.so.2.
Specifically:
Can't load '/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/
Pg/Pg.so' for module Pg: libpq.so.2: cannot open shared object file: No
such file or directory at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/
DynaLoader.pm line 229.
Oracle does not roll back any transaction unless explicitly requested by
the client application. If there are errors while executing statements
inside a transaction, their effect is rolled back, not the whole
transaction. The application can then decide if the successful part of
the transaction is
On Mon, 2003-07-14 at 10:43, Peter Childs wrote:
On Mon, 14 Jul 2003, Mike Mascari wrote:
Jrg Schulz wrote:
... I have this feeling the reason Oracle gives this result may
be again because transactions have been switched off!
This snippet comes from the Oracle console:
(table
Peter Childs wrote:
On Mon, 14 Jul 2003, Mike Mascari wrote:
Jörg Schulz wrote:
Presumably Oracle is not rolling back a duplicate key violation,
allowing the transaction to continue. This is an often requested
feature not present in PostgreSQL.
Bug. Not Feature
Transactions
On 14 Jul 2003 at 5:18, Mike Mascari wrote:
I agree. However a common scenario that has appeared on these lists is
a request for an atomic 'CREATE IF NOT EXISTS, ELSE REPLACE' without
race conditions. Because Oracle doesn't rollback the transaction, it
is implementable in SQL. For PostgreSQL,
Hi
On 14 Jul 2003, Peter Moscatt wrote:
I can manually start the server using: pg_ctl start -l -D
/usr/local/pgsql/data.
But when I put this line in the: /etc/rc.d/rc.local file then check the
boot.log file to see if it's loading - I see this is not the case.
AFAIK you should write
On Mon, 14 Jul 2003, Alvaro Herrera wrote:
On Mon, Jul 14, 2003 at 12:54:55AM -0500, Ron Johnson wrote:
SQL is only one possible relational query language. It didn't
become de facto standard until the mid- to late-80s.
It is an outgrowth of SEQEL (Structured English QuEry
Ok - discovered the solution in pgsql-php, repeated below for reference:
From: Peter De Muer (Work) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: 7.3.1 update gives PHP libpq.so.2 problem
Date: Tue, 4 Feb 2003 14:06:04 +0100
try making a soft link
On 14 Jul 2003 at 19:32, Peter Moscatt wrote:
I have just installed postgresql from the RPMs on the MD dist CDs - all
went to plan.
I can manually start the server using: pg_ctl start -l -D
/usr/local/pgsql/data.
You should place a logfile name after -l option. See if that log file gets
This has been discussed for many times on this list, but shortly: when
inserting a new row, there's no previous row to select for update. If
you have 2 concurrent transactions, both of them can execute the select
for update at the same time, select nothing, and then try to insert the
same key, and
Elein,
actually I do not store my source in a cvs or anything similar.
Yes, you are absolutally right I should but I'm allways busy and
do not have the time to deal enought with these nice softwares.
But I think my problem is not about this. I have the latest
source code in a separate file so I
On Mon, 2003-07-14 at 04:07, Csaba Nagy wrote:
[snip]
This feature is often requested because it's very useful, especially in
Amen! Give the app developer the opportunity to travel down a different
code path if s/he tries, for example, to insert a duplicate key.
[snip]
The main reason why
On 14 Jul 2003 at 15:16, Terence Chang wrote:
Hi all:
I am new to PostgreSQL DB, however I have years experience with Oracle
8i and MS SQL. I am in the process to promot PostgreSQL to my future
client, due to the cost. I am just wondering if overall people feels
frustrated with PostgreSQL
I think I figured out what went wrong.
regression.diffs is created by compareing src/test/regress/expect/name.out with
src/test/regress/results/name.out.
Since expected/name.out comes with the jar, so any changes I made won't be
reflected in the that file.
Now the question is, is there a way
--- Terence Chang [EMAIL PROTECTED] wrote:
I have the following questions. Please reply me
offline, so the mailling
list won't get flood. Thanks!
But if they don't read it, they can't correct me!
;-)
1. What is your favorite GUI tool for PostgreSQL?
I create apps using MS Access as the GUI
On Mon, 2003-07-14 at 17:44, Dan Langille wrote:
On 14 Jul 2003 at 15:16, Terence Chang wrote:
Hi all:
[snip]
Stored procedures is one reason I moved http://www.FreshPorts.org/
from MySQL to PostgreSQL.
Oh, the shame! Advertising AOL For Broadband on a FreeBSD ports
site?
--
I have been working with various databases since the 80's.
Terence Chang wrote:
Hi all:
I am new to PostgreSQL DB, however I have years experience with Oracle 8i
and MS SQL. I am in the process to promot PostgreSQL to my future client,
due to the cost. I am just wondering if overall people feels
On 14 Jul 2003 at 20:55, Ron Johnson wrote:
On Mon, 2003-07-14 at 17:44, Dan Langille wrote:
On 14 Jul 2003 at 15:16, Terence Chang wrote:
Hi all:
[snip]
Stored procedures is one reason I moved http://www.FreshPorts.org/
from MySQL to PostgreSQL.
Oh, the shame! Advertising
Hi;
Hermes is the foundation for CRM and ERP tools for business processes
such as field service automation, sales force automation, contact
management and some scheduling tasks as well. It supports both MySQL
(mostly) and PostgreSQL (fully).
The 0.1.0 release will be suitable for small
On Mon, 2003-07-14 at 17:13, Jay O'Connor wrote:
What impact in performance does vacuum have on an active database? I'm
being asked about this...or rather...someone is questioning the use of
postgresql because of this
There is no easy answer to this question, other than if you vacuum
The demo on the hermes website is not working. I tried to login with
the demo username and password and got this:
Warning: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in
/home/groups/h/he/hermesweb/htdocs/demo/hermes/DBAL_mysql-1.0.0-b.php on
line 40
Warning: MySQL
On Mon, Jul 14, 2003 at 04:10:15PM -0600, Kathy Zhu wrote:
parallel group (13 tests): float8 boolean float4 oid int4 int8 char int2 name t
ext varchar bit numeric
boolean ... ok
char ... ok
name ... FAILED
I am attaching the
Updated my RH80 installation with the full complement of Postgres 7.3.3 RPMs.
Added python and tcl ( already have pl/sql) language bindings to the database
without issue. However, the compiler complains about perl:
ERROR: Load of file /usr/lib/pgsql/plperl.so failed: libperl.so: cannot open
Alvaro Herrera [EMAIL PROTECTED] writes:
On Mon, Jul 14, 2003 at 04:10:15PM -0600, Kathy Zhu wrote:
The question is, is it ok to fail this regression test since I do change
the NAMEDATALEN ???
AFAICS this is testing the ability to correctly truncate the identifier
length to 31 chars,
Hi Robert,
I admit your opinion. But I thought it could be a kind of service just for
convenience.
On the other hand there are a lot of commands in the PostgreSQL language
which does not appear in the original SQL standard.
Despite I think almost everybody find them very useful. So I would not say
1. What is your favorite GUI tool for PostgreSQL?
Just psql in an emacs window.
Emacs lets me see large result sets, and keep a history of my commands.
2. In your organization, do you have someone who works as full time
PostgreSQL DBA?
Our Oracle DBA is also the DBA for our production
43 matches
Mail list logo