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
* Tom Lane <[EMAIL PROTECTED]> [2004-03-04 11:24:11 -0500]:
> 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 si
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.
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
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 not
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 hav
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
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 GROU
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,
