[SQL] Strange behavior with timestamptz

2003-08-25 Thread George Weaver
Hi Everyone,   I have a situation where two tables have a "Created" field defined as follows:   table seedlot "created  timestamptz  DEFAULT now(), "   table transaction"created  timestamptz  NOT NULL  DEFAULT now(),"   The transaction table records when a seedlot record

Re: [SQL] [ZODB-Dev] What are the ZopeDB limit?

2003-08-25 Thread Michele Bendazzoli
On Mon, 2003-08-25 at 09:12, Michele Bendazzoli wrote: ops ... apologies for the message. Michele ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [SQL] [ZODB-Dev] What are the ZopeDB limit?

2003-08-25 Thread Michele Bendazzoli
On Sat, 2003-08-23 at 23:01, Dieter Maurer wrote: cut > > What do you think of? > > When your data fits well in a relational database > (a huge number of highly structured records, no full text indexes), > put it in Postgres. Otherwise, try the ZODB. > Make some preliminary mass tests before your

Re: [SQL] Joined deletes but one table being a subquery.

2003-08-25 Thread Tomasz Myrta
I apologize for the silence. t_a as been created as CREATE TABLE t_a as SELECT userid,category_id from eyp_listing where userid=21742 and size ilike '%WEBFL%' EXCEPT SELECT userid,category_id from company_export_profile where userid=21742 ; so the subquery is basically ( SELECT userid,catego