Re: [SQL] Avoiding "will create implicit index" NOTICE

2009-06-10 Thread Bryce Nesbitt
Thanks, that's good. Rob Sargent wrote: > create table junk_six (foo int) > create unique index junk_six_id on junk_six(foo) -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql

Re: [SQL] setting the where clause

2009-06-10 Thread Rob Sargent
Tom Lane wrote: johnf writes: I'm am programming in python using the Dabo modules. www.dabodev.com if your interested. Dabo is a framework that provides an easy way to build desktop app's. To clear a data entry form. I have been setting the where clause to "where 1=0". This of course

Re: [SQL] setting the where clause

2009-06-10 Thread Tom Lane
johnf writes: > I'm am programming in python using the Dabo modules. www.dabodev.com if your > interested. Dabo is a framework that provides an easy way to build desktop > app's. To clear a data entry form. I have been setting the where clause > to "where 1=0". This of course retrieves 0 re

[SQL] setting the where clause

2009-06-10 Thread johnf
Hi, I'm am programming in python using the Dabo modules. www.dabodev.com if your interested. Dabo is a framework that provides an easy way to build desktop app's. To clear a data entry form. I have been setting the where clause to "where 1=0". This of course retrieves 0 records and my form w