uggest, or upgrade to 9.x, for which I've found simple examples due to
dynamic limit and offset.
thanks and regards,
Maarten
On Wed, 2010-11-17 at 09:53 +1300, Brent Wood wrote:
> Hi Maarten,
>
> The best way I know of to do this is not to do statistical queries
> "in"
le directly.
Furthermore, I need the median for a timestamp column, which would
probably complicate things more than when it is a number column.
I'd like to be able to do this using only the database. (So no
programming functions, special addons etc...)
Any ideas anyone?
regards,
Maarte
Hi,
sum doesn't like booleans, but it does like integers so:
sum(boolval::int) solves that problem for you.
SELECT id,sum(good::int + fair::int + nice::int) would get you a total
of the three for each row
good luck,
Maarten
On Tue, 2010-11-16 at 17:23 +0100, Alexander Farber wrote:
&g
hould give you a list of all polynames.
The trick is figuring out what polyname goes with which point. But I
leave that as an exercise to the reader, as it's tea time.
regards,
Maarten
On Thu, 2010-10-28 at 01:00 -0700, trevor1940 wrote:
> Hi
>
> I have a PostGIS table and I wish
plpgsql' VOLATILE
COST 100;
regards,
Maarten
On Tue, 2010-06-15 at 17:54 +0200, maarten wrote:
> Hi all,
>
> I've been looking for a while now to solve my problem.
> I'd like to store an integer (and other things) in a bytea field of a
> table from a trigger functi
, I realize
I'll need something along the lines of
IF v_temp = 0 -> E'\\000'
ELSIF v_temp < 128 -> chr(v_temp)
ELSE ...
It's the ... I'm looking for. (or some function that can replace that
entire IF block, or even better, the entire functi
;)
> Are there any other strings with backslashes in your statements?
Don't know, probably yes. The backslashes are probably generated by the
escape function.
Greetings,
Maarten Deprez
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscri
ings to on?
Laurenz Albe wrote:
> Depends.
Okay, what do you need to know? It can be any string, a part of an email
message. Should strings escaped by EscapeBytea be included in "''", or
"E''" in the SQL command, to avoid the warning?
Greetings,
Maarten
?
Greetings,
Maarten Deprez
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello.
My dbmail server using postgresql produces a lot of warnings about '\\'
in strings. The particular string it is complaining about is escaped by
EscapeBytea, and included in single quotes (not E''). Is it all right to
set standard_compliant_strings to on?
Greet
se "change user /install" inside a terminal session to make
this work? Open a CMD prompt, and type "change user /install"...
http://support.microsoft.com/kb/320185
Maarten
---(end of broadcast)---
TIP 9: In versions belo
PostgreSQL creates an Administrator user you can only get rid of by
booting XP in "sans echec mode", or whatever this is called in your
language.
You otherwise won't be able to see this user.
You will also most likely need some register cleaning tools to get rid
of it completely and or change
closing of the resultset. Here's
part of the DAO method: Query q =
getSession(false).createQuery(query);
q.setMaxResults(RESULT_SIZE);
List list = q.list();
No rocketscience but somehow this causes a problem on
the DB Server.
Does anyone have an idea where to look?
Thanks,
Maarten
ps: Java
Original Message
Subject: Re: [GENERAL] CGI program cannot access database
Date: Fri, 08 Oct 2004 10:34:12 +0400
From: Maarten Boekhold <[EMAIL PROTECTED]>
To: Samik Raychaudhuri <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Samik Raychaudhuri wrote:
Hel
artup.
Perhaps it's possible to first start postmaster in single user mode to
clean up the system catalogs?
Maarten
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hi,
AFAIK when an entity EJB is instantiated it will be read from the DB.
Similarly, when it is destroyed, it will be serialized to the DB again.
Thus an update, which causes your table to grow.
Maarten
Maarten Boekhold, [EMAIL PROTECTED]
Reuters Consulting
Entrada 308
1096 ED
econdary if the primary dies should be
possible.
You'd also want some way of switching the IP-address of the machines so
that the whole fail-over is transparent to clients.
Maarten
On 13/12/2000 17:30:31 Schmidt, Peter wrote:
>-Original Message-
>From: Tom Lane [mailto:[EMAIL
bably another 74 megs to be allocated somewhere in
memory(?) and finally it gets to psql which needs to get yet another 74
megs.
Does this make any sense to the experts?
Maarten
--
Maarten Boekhold, [EMAIL PROTECTED]
TIBCO Finance Technology Inc.
"Sevilla" Building
Entrada 308
1096
be touching that disk, there's only linux
partitions on it).
Maarten
--
Maarten Boekhold, [EMAIL PROTECTED]
TIBCO Finance Technology Inc.
The Atrium
Strawinskylaan 3051
1077 ZX Amsterdam, The Netherlands
tel: +31 20 3012158, fax: +31 20 3012358
http://www.tibco.com
> 1) All Celerons ship with a 128K on chip cache. Which means the cache runs
> at the same clock rate as the chip.
> 2) The PIIs ship with 512K cache, however it's level 2 so it only runs at bus
> speed.
No, it runs at half the core speed.
Maarten
ps. do you also find it
:
create index product_artit_idx2 on product (lower(artit::text) text_ops);
ERROR: parser: parse error at or near "::"
How can I do this? Isn't there a simple fix to some system table that
tells postgres that using lowe
On Thu, 30 Jul 1998, Maarten Boekhold wrote:
> Hi,
>
> I have a 6.3.2 server, and I want to use password authentication.
> So, I gave the user 'postgres' and some other user a password, and I put this
> in my pg_hba.conf:
>
> host all 127.0.0.1
'postgres' as username
while supplying a fake password.
Am I doing something wrong here?
Maarten
_
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
|
.primus.baynet.de/mgeisler/kpgsql
> - KDE frontend
Maarten
_
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of Electrical Engineering
user). Maybe you gave to create the database first
on machine b.
At least, I think this should work And no need to stop any postmasters..
Maarten
_
| TU Delft, The Netherlands, Faculty of Inf
:(
I must say that I think that the link on the 'submit' page is very confusing.
Maarten
_
| TU Delft, The Netherlands, Faculty of Information Technology and Systems |
| Department of
27;t even test for this special case
(PGRES_EMPTY_QUERY) and then continue, cos it's considered an error, and
all queries are ignored till the end of the transaction.
Anybody knows what's going on here?
Maarten
27 matches
Mail list logo
