Hi everyone again ! You've been so useful that I've got more questions
:-)
Sorry about the width of my posts by the way, I'm presuming it is
preferred to have wide tables than try and wrap them.
I'm trying to select all rows from a join, and then also some other
rows from a third join if the
I have two questions:
(1) SECURITY BY OBSCURITY :)
I have a table
CREATE TABLE tbl (
password text,
created timestamp not null default current_timestamp
);
I want to make two triggers on select/insert for this. The
trigger for insert should xor password with the first byte
(or
If you were to instead run your inserts, updates, and selects through a
procedure, you could achieve the same affect. You could have the select
require the decode key be passed.
From the method you're asking about, the whole point of encrypting the
column would be undone by *ANYBODY* doing a
On Thu, 9 Aug 2001, Nicholas Piper wrote:
Hi everyone again ! You've been so useful that I've got more questions
:-)
Sorry about the width of my posts by the way, I'm presuming it is
preferred to have wide tables than try and wrap them.
I'm trying to select all rows from a join, and
On Thu, 09 Aug 2001, Stephan Szabo wrote:
depos=# explain select cdtitles.title, cdtitles.artist, song,
fk_products_id, p.title, p.artist from cdsongs, cdtitles left join
products p on (cdtitles.fk_products_id = p.id) where cdtitles.cdid =
cdsongs.cdid and song like 'mushroom festi%';
I'm curious how PostgreSQL compares to Oracle in terms
of stability and speed. My company is looking into
alternative database software for our product but we
need to know if it's stable enough for our needs.
Our current requirements list for a good Database
software application are the
Tony Hoyt [EMAIL PROTECTED] writes:
Our current requirements list for a good Database
software application are the following.
1. Stability - It can survive power outages.
Check.
2. Speed - We're only going to perform very basic
read and write transactions. Some tables are rather
Hi Tony,
PostgreSQL is *very* stable. Individual backends can be killed off by
weird SQL queries that trigger a known bug (not very many, and always
being fixed), but that is very very rare, and nothing which 99.999% of
normal SQL queries will get even close to.
There are a few 3rd party
From: Allan Engelhardt [EMAIL PROTECTED]
To: Brian C. Doyle [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2001 11:18 PM
Subject: [GENERAL] Re: First Saturday and Last Saturday of a month
You *do* know the algorithm for testing if year is a leap year, don't
you?