On Tue, 5 Dec 2000, Tom Lane wrote:
> Hmm. The rule will generate a query along these lines:
>
> DELETE FROM ips_free
> FROM ips_free ipsfree2
> WHERE ips_free.block_id = ipsfree2.block_id
> AND ips_free.ip = ipsfree2.ip
> AND ipsfree2.ip = '10.10.10.10';
>
> (I'm using ipsfr
Hi everyone,
I've recently encountered a bizzare problem that manifests itself reliably
on my running copy of postgres. I have a system set up to track IPs. The
arrangement uses two mutually-exclusive buckets, one for free IPs and
the other for used ones. There are rules set up on the used pool
On Mon, 27 Nov 2000, Don Baccus wrote:
> >Actually, they aren't the same at all under Oracle or under Postgres.
> >
> >A null represents a lack of data, whereas an empty string is represents
> >data of zero length and zero content. Null is a state and not a value.
>
> Unfortunately Mario's entir
On Mon, 27 Nov 2000, Mario Weilguni wrote:
> Sorry if I'm posting to the wrong list, but I don't know which list is
> appropriate for this question.
>
> I've a question concerning compatibilty Postgres <-> Oracle. In Oracle,
> empty strings and null are basicly the same, but it does not seem t