On the other hand, the money you save on Oracle licences can be
spent on bigger iron to run PG - so for non-exotic installations you
should be able to come out ahead. Certainly if you were thinking of
Intel hardware I'd expect PG to do well in terms of
price/performance.
That is exactly
I would like to store some images in my Postgres database. These will
all be thumbnails, limited to 4k or 5k. I know that PG has an 8k row
limit, but this should be fine, because there's not much else in the
row. Which data type could I use to store them, and is there a
performance cost for
I've never used the locking features of Postgres before, and now I
find that I need to use them. I read through the instructions, but
I've never taken a database theory course so I don't understand all
the terms they used.
Here's what I need to do: The database keeps accounts. If one process
Is there a function in Postgres which will DES-encrypt a given string
with a given key? If not, has anyone out there written a linkable C
function to do that? I know it's easy to do, if you know C, but I
don't know C.
Thanks
When I try this function:
CREATE FUNCTION pgtest(INT4, INT4, INT4, INT4, INT8, INT4, INT2,
INT8, VARCHAR(100), VARCHAR(100), INT4, CHAR(40), INT4)
RETURNS INT4
AS '
DECLARE result INT4;
BEGIN
result := $1 + 12;
RETURN result;
END;
' LANGUAGE 'plpgsql';
it always returns NULL. If I have less
Well, I did a dropdb and then I recreated everything, and then it
started working the way I thought it should. There must have been
some function in there that was confusing it, or who knows what. As
I'm writing and debugging functions, I do a lot of DROP FUNCTION and
CREATE FUNCTION, so maybe
The bug is back, and I can't figure it out.
Do a
GET DIAGNOSTICS SELECT PROCESSED INTO int4_variable;
directly after an INSERT, UPDATE or DELETE statement and
you'll know how many rows have been hit.
Also you can get the OID of an inserted row with
GET DIAGNOSTICS SELECT RESULT INTO
Quick question: Is there a way to find out how many rows an UPDATE
affected in pl/pgsql?
Thanks
I looked through all the docs, and I couldn't find a function which
would simply DES encrypt a string. Is DES not implemented in
Postgres? Or am I just not finding the function?
Thanks
I would also like to use SSL, or better SSH, with Postgres. I know I
could use SSH tunneling, but it would be even better if it were
integrated. Does anyone know if this is possible?
Thanks
and everything went smoothly. My main reason for doing this was that
I needed to recompile the whole thing to allow functions with more
than 16 args, and if I'm going to recompile, why not upgrade to 7.03
anyway? It's also good because I'll get a chance to make sure
everything I'm going works
I know it is possible to define a new data type which is a composite
of PG native types, but there seems to be little or no documentation
(that I can find) about how to do this. For example, I have a lot of
data in the form of an address, which contains address-line-1,
address-line-2, city,
13 matches
Mail list logo
