Michael Chaney wrote:
On Thu, Mar 04, 2004 at 10:50:50AM -0500, Tom Lane wrote:
If I understood the requirements correctly, it might be sufficient to
put a unique index on (id1,id2). If two transactions simultaneously try
to insert for the same id1, one would get a duplicate-index-entry
failure,
Dear all,
I'm sorry if this sounds stupid or have been talked about before.
Suppose I have a field in my table that's called duration with type
'time without timezone'. How do I do sum on this field based on another
field let say called dateofevent?
SQL: SELECT SUM(duration) FROM durtable
Hello,
you can sum only interval type
create type x (a inteval);
testdb011= insert into x values ('1 day'::interval);
INSERT 18871 1
testdb011= insert into x values ('1 day'::interval);
INSERT 18872 1
testdb011= insert into x values ('1 day'::interval);
INSERT 18873 1
testdb011= insert into x
Tom Lane wrote:
David Garamond [EMAIL PROTECTED] writes:
Does it currently work? src/backend/utils/mb/conversion_procs/*/ is not
building anything, and 'make install' fails because it tries to copy
*.so files.
For sufficiently small values of current, it builds. You do realize
you won't have
DeJuan Jackson wrote:
Just dropping a quick not for Tom Lane. I sent a personal message
today, but I wasn't sure if you'd get it after I remembered all of the
spam filters you've got set up.
Sorry for the off topic post.
That's ok. He is only filtering me :-)
Actually, you get a rejection
I'm making a relocatable Postgres binary distribution for my clients.
Everything goes into postgresql-7.4.1/ directory, including libraries
and binaries. This will be installed by a non-privileged user under his
own home directory. The goal is that they could just extract the
tarball, adjust
On Thu, Mar 04, 2004 at 06:12:36PM -0800, Glen Parker wrote:
This popped up because we're doing dev work against a 7.4 server but
deploying against a 7.2 server.
Don't do that. You're going to have loads of trouble.
these queries are concerned. I'm considering Postgres to be broken. Am
* Tom Lane [EMAIL PROTECTED] [2004-03-04 11:24:11 -0500]:
snip
Double quotes are for names (identifiers). Single quotes are
for string literals (constants).
BTW: is this general SQL syntax or just PostgeSQL ?
mysql does no distinction (which is IMHO very unclean), and it gets
even worse
David Garamond said:
I'm making a relocatable Postgres binary distribution for my clients.
Everything goes into postgresql-7.4.1/ directory, including libraries
and binaries. This will be installed by a non-privileged user under his
own home directory. The goal is that they could just
