Re: PL/pgSQL & OVERLAPS operator (SOLVED!)

From: Tuo Pe <tuo_pe(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL & OVERLAPS operator (SOLVED!)
Date: 2010-03-24 09:10:28
Message-ID: 906732.74627.qm@web50302.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- On Tue, 3/23/10, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Yeah --- that SELECT will result in no change to the
> variables, ie,
> they'll still be NULL.  So the OVERLAPS always fails.

Tom & Andreas, I thank you for your help. Renaming the variables solved the problem. :-)

Regards,
Tuo

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Frank jansen 2010-03-24 10:22:48 Concatenate
Previous Message Dean Rasheed 2010-03-24 07:44:48 Re: Help me with this multi-table query