Home > mailing lists

Re: PL/pgSQL & OVERLAPS operator (SOLVED!) - Mailing list pgsql-general

From	Tuo Pe
Subject	Re: PL/pgSQL & OVERLAPS operator (SOLVED!)
Date	March 24, 2010 09:10:42
Msg-id	906732.74627.qm@web50302.mail.re2.yahoo.com Whole thread Raw
In response to	Re: PL/pgSQL & OVERLAPS operator (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

--- On Tue, 3/23/10, Tom Lane <tgl@sss.pgh.pa.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

pgsql-general by date:

From: Dean Rasheed
Date: 24 March 2010, 07:45:02
Subject: Re: Help me with this multi-table query

From: Frank jansen
Date: 24 March 2010, 10:22:24
Subject: Concatenate

Re: PL/pgSQL & OVERLAPS operator (SOLVED!) - Mailing list pgsql-general

Previous

Next