my mistakes, zips_max should be zips_300.
Tomasz Myrta <[EMAIL PROTECTED]> wrote:
Christopher Smith wrote:> I have 4 tables that I need to query... 3 of the tables are links by the> field userid.>> below are table sql fragments. as well as the query. The subquery> causes v
I understand cachable functions but your proposed application is a little unclear.
is it possible to see an example?
thanks in advance.
Josh Berkus <[EMAIL PROTECTED]> wrote:
Chris,Here are probably your two main query problems:> strpos(user_match_details.ethnicity,'Asian') !=0 ANDIt is impossible
I have 4 tables that I need to query... 3 of the tables are links by the field userid.
below are table sql fragments. as well as the query. The subquery causes very high
CPU usages. It typically returns ~3000 matches. Is there another way to rewrite this?
SELECT user_login.userid FROM user_log
On 18 Jun 2001 18:04:14 -0400, Tom Lane wrote:
> Christopher Smith <[EMAIL PROTECTED]> writes:
> >> Um ... surely that should be "if count > 0" ? Or was that just a
> >> transcription error?
> >>
> >> This approach certainly ought to
On 18 Jun 2001 17:42:15 -0400, Tom Lane wrote:
> Christopher Smith <[EMAIL PROTECTED]> writes:
> Um ... surely that should be "if count > 0" ? Or was that just a
> transcription error?
>
> This approach certainly ought to work as desired given the exclusive
&g
Hi there. I'm currently using Postgresql 7.0.3, accessing using the JDBC
drivers. I'm enforcing the most severe transaction isolation available
(serializable). I'm currently doing something like the following (this
is pseudo code, with the if being performed in Java):
begin
lock table foo in acce
