Re: [HACKERS] INSERT INTO ... SELECT problem

2000-12-05 Thread Alex Perel
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

[HACKERS] INSERT INTO ... SELECT problem

2000-12-04 Thread Alex Perel
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

Re: [HACKERS] Question about Oracle compatibility

2000-11-27 Thread Alex Perel
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

Re: [HACKERS] Question about Oracle compatibility

2000-11-27 Thread Alex Perel
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