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
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 replic
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 rathe
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 follow
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 fest
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,
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 sel
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 somethin
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 row
