Am Montag, den 05.09.2005, 03:00 +0300 schrieb Sterpu Victor:
> Can I do something like this?
> SELECT sum(name) FROM table;
>
> Where name is a text field.
> I know 'sum' doesn't work, but is there another solution?
> '||' is not good because it will take just 2 arguments.
>
Yes you can write a
On Sun, 2005-09-04 at 20:37 -0400, Allan Wang wrote:
> On Mon, 2005-09-05 at 03:00 +0300, Sterpu Victor wrote:
> > Can I do something like this?
> > SELECT sum(name) FROM table;
> >
>
> You can add a custom aggregate function that turns your data into an
> array, see http://www.postgresql.org/doc
On Mon, Sep 05, 2005 at 03:00:30AM +0300, Sterpu Victor wrote:
> Can I do something like this?
> SELECT sum(name) FROM table;
>
> Where name is a text field.
> I know 'sum' doesn't work, but is there another solution?
> '||' is not good because it will take just 2 arguments.
Are you looking for a
There is no reason why you couldn't just use Inno setup to include the
setup of your app and Postgresql in a single setup.
I do something similar with Firebird for a IM server with Inno setup, I
do not use the embedded "dll" version of Firebird either.
I plan to create a Inno setup for the win3
On Mon, Sep 05, 2005 at 03:00:30AM +0300, Sterpu Victor wrote:
> Can I do something like this?
> SELECT sum(name) FROM table;
>
> Where name is a text field.
> I know 'sum' doesn't work, but is there another solution?
> '||' is not good because it will take just 2 arguments.
Currently, you can us
Can I do something like this?
SELECT sum(name) FROM table;
Where name is a text field.
I know 'sum' doesn't work, but is there another solution?
'||' is not good because it will take just 2 arguments.
Thank you.
---(end of broadcast)---
TIP 4: Hav
On Sep 5, 2005, at 6:41 AM, Shanta McBain wrote:
bash-3.00$ postmaster -D /var/lib/pgsql/data/
FATAL: database files are incompatible with server
DETAIL: The data directory was initialized by PostgreSQL version
7.4, which
is not compatible with this version 8.0.1.
I have been trying to f
I have been trying to get my postgress installation to work. I install
upgrades to my system the update manager. Mandarack 10.2 Now I can't access
the database.
bash-3.00$ postmaster -D /var/lib/pgsql/data/
FATAL: database files are incompatible with server
DETAIL: The data directory was initi
you want to create 1 million tables, all with one of
2 schemas?
I started out with a schema for each file, thinking I could utilize
the schema
structure in queries, but I don't see how. Schemas are useful for grouping
tables according to users/owners. Other than that, do they add anyth
> CSN wrote:
> > Perhaps another possible feature request! I've
looked
> > through the docs and it doesn't appear that it's
> > possible to create deferred triggers - i.e. they
don't
> > get called unless the current transaction commits.
>
> The semantics of such a thing appear to be
indeterminat
Hi,
I noticed that PG 8.1 beta has been released. With 8.0 I have problems
with code points above U+. Can someone please tell me whether the
Unicode problems in 8.0.x have been fixed in this version?
If so, is the beta version stable enough to use yet?
LL
---(en
Hi Everyone
Im setting up a machine that will host postgres 8.0.3.
The main tables will be:
Product - around 5 million records.
keywords - around 80 million records.
The machine that will host it is IBM x345 with two XEON, 3GB RAM,
ServeRAID 6i and 6 15K HD.
The OS ( Centos4.1 ) will be
Poul Jensen <[EMAIL PROTECTED]> writes:
>>you want to create 1 million tables, all with one of
>>2 schemas?
>>
>>
>
> I started out with a schema for each file, thinking I could utilize
> the schema
> structure in queries, but I don't see how. Schemas are useful for grouping
> tables according t
Thank you very much for your response! It leads to another couple of
questions:
I'm building a database containing key parameters for ~500,000 data
files. The design I found logical is
Two tables for each file:
1) Larger table with detailed key parameters
(10-15 columns, ~1000 rows), call i
Hi there,
for a program I am building, which uses PostgreSQL as its backend, I
want to embed the DB engine into the application's setup. Now I wonder
if something like Firebird's "Embedded server" (a DLL ) is also
available for PostgreSQL, or if there are other ways to minimize or
remove compl
15 matches
Mail list logo
